Microsoft Certified Data Analyst Associate Power BI Service and Workspaces 2

Question 1

What is a dataflow in Power BI?

Accepted Answer

A reusable data preparation process stored in the Power BI service using Power Query

Answer

A scheduled email report

Answer

A live streaming dataset from IoT devices

Answer

A connector for external APIs

Question 2

How often can a Power BI dataset be scheduled to refresh with a Pro license?

Accepted Answer

Up to 8 times per day

Answer

Once per day

Answer

Up to 48 times per day

Answer

Unlimited refreshes

Question 3

What is row-level security (RLS) in Power BI?

Accepted Answer

A feature that restricts data access for specific users based on DAX filter rules

Answer

Encryption of individual rows in a dataset

Answer

A sorting mechanism for table rows

Answer

A backup mechanism for dataset rows

Question 4

What is the difference between a Power BI report and a dashboard?

Accepted Answer

Reports are multi-page interactive documents; dashboards are single-page pin boards with tiles from multiple reports

Answer

Dashboards support drill-through; reports do not

Answer

Reports are read-only; dashboards are editable

Answer

There is no meaningful difference

Question 5

What does the 'Endorsement' feature in Power BI do?

Accepted Answer

Marks datasets, dataflows, or reports as Promoted or Certified to signal quality and trustworthiness

Answer

Locks a dataset to prevent changes

Answer

Approves a report for external sharing

Answer

Encrypts a dataset with a customer-managed key

Question 6

What Power BI feature enables users to receive automatic alerts when a KPI tile on a dashboard crosses a threshold?

Accepted Answer

Data alerts

Answer

Subscriptions

Answer

Anomaly detection

Answer

Smart narratives