Microsoft Certified Data Analyst Associate Power BI Service and Workspaces 1 — Questions and Answers
Question 1: What is a Power BI workspace?
- A local folder for storing .pbix files
- A collaborative environment in the Power BI service for sharing datasets, reports, and dashboards (Correct answer)
- A virtual machine for running Power BI Gateway
- A premium feature only available in Power BI Premium
Correct answer: A collaborative environment in the Power BI service for sharing datasets, reports, and dashboards
Workspaces are containers in the Power BI service where teams collaborate on datasets, reports, and dashboards with shared access.
Question 2: What is the purpose of a Power BI Gateway?
- To export reports to PDF
- To enable on-premises data sources to connect to the Power BI service for refresh (Correct answer)
- To embed reports in external websites
- To manage user licenses
Correct answer: To enable on-premises data sources to connect to the Power BI service for refresh
The On-premises Data Gateway acts as a bridge allowing the Power BI service to securely refresh data from on-premises sources like SQL Server.
Question 3: Which Power BI service feature allows you to pin visuals from multiple reports into a single view?
- Report
- App
- Dashboard (Correct answer)
- Dataflow
Correct answer: Dashboard
Dashboards are single-page canvases where you pin visuals from multiple reports, datasets, or Q&A results for an at-a-glance overview.
Question 4: What does publishing a Power BI report from Desktop to the Service do?
- Shares the .pbix file via email
- Uploads the report and its dataset to a Power BI workspace (Correct answer)
- Exports the report as a PDF to OneDrive
- Creates a live connection to the desktop file
Correct answer: Uploads the report and its dataset to a Power BI workspace
Publishing uploads the .pbix file's report and dataset to the selected Power BI workspace, making it available in the cloud.
Question 5: What is a Power BI App?
- The Power BI Desktop application
- A packaged collection of dashboards and reports distributed to a broad audience from a workspace (Correct answer)
- A mobile application for viewing reports
- A Python or R script embedded in a report
Correct answer: A packaged collection of dashboards and reports distributed to a broad audience from a workspace
Power BI Apps bundle workspace content (dashboards, reports) into a single polished package that can be distributed to large audiences with controlled access.
Question 6: What Power BI license is required to share content with colleagues in your organization using the Power BI service?
- Power BI Free
- Power BI Pro or Premium Per User (PPU) (Correct answer)
- Power BI Desktop only
- Microsoft 365 Basic
Correct answer: Power BI Pro or Premium Per User (PPU)
Power BI Pro or Premium Per User (PPU) is required to share reports and dashboards with others and collaborate in workspaces.
Microsoft Certified Data Analyst Associate Power BI Service and Workspaces 1
What is a Power BI workspace?