Q1. Which statement best describes the difference between Power BI Desktop and the Power BI Service?
Type: Multiple Choice
- Desktop is used to view dashboards only; the Service is used to build reports.
- Desktop is the authoring tool used to build and publish reports; the Service is the cloud platform used to host, share, and collaborate on published reports.
- They are two names for the exact same product with no functional differences.
- Desktop only works with SQL databases; the Service only works with Excel files.
Correct Answer: Desktop is the authoring tool used to build and publish reports; the Service is the cloud platform used to host, share, and collaborate on published reports.
Why: Power BI Desktop is the free Windows application analysts use to connect to data, transform it, build the model, and design report pages. Once finished, a report is published to the Power BI Service (app.powerbi.com), the cloud environment where reports are hosted, refreshed, shared, and turned into dashboards.
Q2. Which view in Power BI Desktop lets you inspect raw table rows, separate from how tables relate to each other?
Type: Multiple Choice
- Report view
- Data view
- Model view
- Query view
Correct Answer: Data view
Why: Data view displays the actual rows and columns of each loaded table, like a spreadsheet. Model view shows the relationships between tables instead, and Report view is where you build visuals.
Q3. Power BI Desktop files are saved with a .pbix extension.
Type: True/False
Correct Answer: True
Why: .pbix is the native Power BI Desktop file format, bundling the data model, queries, and report pages into a single file.
Q4. Which pane and button do you use to connect to a new data source, such as a CSV file, in Power BI Desktop?
Type: Short Answer
Correct Answer: The “Get Data” button on the Home ribbon.
Why: Get Data opens a connector list (Excel, Text/CSV, SQL Server, web, etc.); choosing Text/CSV and browsing to the file starts the import process used throughout this course.