Microsoft Certified Data Analyst Associate Power BI Service and Workspaces 2 — Questions and Answers
Question 1: What is a dataflow in Power BI?
- A scheduled email report
- A reusable data preparation process stored in the Power BI service using Power Query (Correct answer)
- A live streaming dataset from IoT devices
- A connector for external APIs
Correct answer: A reusable data preparation process stored in the Power BI service using Power Query
Dataflows are cloud-based Power Query transformations stored in the Power BI service, enabling reusable, centralized data prep across multiple datasets.
Question 2: How often can a Power BI dataset be scheduled to refresh with a Pro license?
- Once per day
- Up to 8 times per day (Correct answer)
- Up to 48 times per day
- Unlimited refreshes
Correct answer: Up to 8 times per day
With a Power BI Pro license, you can schedule up to 8 daily refreshes per dataset; Premium capacities allow up to 48 refreshes per day.
Question 3: What is row-level security (RLS) in Power BI?
- Encryption of individual rows in a dataset
- A feature that restricts data access for specific users based on DAX filter rules (Correct answer)
- A sorting mechanism for table rows
- A backup mechanism for dataset rows
Correct answer: A feature that restricts data access for specific users based on DAX filter rules
RLS uses DAX filter expressions applied to roles to ensure users only see data they are authorized to view when accessing a report.
Question 4: What is the difference between a Power BI report and a dashboard?
- Reports are multi-page interactive documents; dashboards are single-page pin boards with tiles from multiple reports (Correct answer)
- Dashboards support drill-through; reports do not
- Reports are read-only; dashboards are editable
- There is no meaningful difference
Correct answer: Reports are multi-page interactive documents; dashboards are single-page pin boards with tiles from multiple reports
Reports are multi-page, interactive documents built from a single dataset; dashboards are single-page canvases with tiles pinned from various reports or datasets.
Question 5: What does the 'Endorsement' feature in Power BI do?
- Locks a dataset to prevent changes
- Marks datasets, dataflows, or reports as Promoted or Certified to signal quality and trustworthiness (Correct answer)
- Approves a report for external sharing
- Encrypts a dataset with a customer-managed key
Correct answer: Marks datasets, dataflows, or reports as Promoted or Certified to signal quality and trustworthiness
Endorsement (Promoted or Certified) labels help consumers identify trusted, high-quality content in the Power BI service.
Question 6: What Power BI feature enables users to receive automatic alerts when a KPI tile on a dashboard crosses a threshold?
- Subscriptions
- Data alerts (Correct answer)
- Anomaly detection
- Smart narratives
Correct answer: Data alerts
Data alerts send email notifications when a KPI, card, or gauge tile on a dashboard goes above or below a user-defined threshold.
Microsoft Certified Data Analyst Associate Power BI Service and Workspaces 2
What is a dataflow in Power BI?