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

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?

Accepted Answer

Up to 8 times per day

Answer

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?

Accepted Answer

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

Answer

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?

Accepted Answer

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

Answer

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?

Accepted Answer

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

Answer

Endorsement (Promoted or Certified) labels help consumers identify trusted, high-quality content in the Power BI service.

Microsoft Certified Data Analyst Associate Practice Test

Microsoft Certified Data Analyst Associate Practice Test

Microsoft Certified Data Analyst Associate Power BI Service and Workspaces 2