Microsoft Certified Data Analyst Associate Azure Data Analyst Associate 3

Question 1

What is the purpose of the CALCULATE() function in DAX when used without any filter arguments?

Accepted Answer

It evaluates an expression in a modified filter context, preserving the existing context

Answer

CALCULATE() with no additional filter arguments still transitions from row context to filter context, which is useful inside iterators.

Question 2

An analyst creates a report with sensitive HR data. Which Power BI feature should they use to restrict row-level data visibility based on the viewer's identity?

Accepted Answer

Row-level security (RLS)

Answer

Row-level security (RLS) uses DAX filter expressions tied to user roles to restrict which rows each user can see.

Question 3

Which M (Power Query) function is used to combine multiple tables with identical column structures vertically?

Accepted Answer

Table.Combine

Answer

Table.Combine appends tables with matching column structures into a single table, equivalent to a SQL UNION ALL.

Question 4

In Azure Synapse Analytics, what is the key difference between a Dedicated SQL Pool and a Serverless SQL Pool?

Accepted Answer

Dedicated pools provision fixed compute resources; serverless pools charge per query processed

Answer

Dedicated SQL Pools pre-provision DWUs (Data Warehouse Units) at a fixed cost, while Serverless SQL Pools bill based on the amount of data scanned per query.

Question 5

A Power BI report uses a Star Schema. The fact table has 50 million rows. Which storage mode would provide the best query performance without requiring Premium capacity?

Accepted Answer

Import

Answer

Import mode loads data into Power BI's in-memory VertiPaq engine, providing the fastest query performance regardless of source system speed.

Microsoft Certified Data Analyst Associate Practice Test

Microsoft Certified Data Analyst Associate Practice Test

Microsoft Certified Data Analyst Associate Azure Data Analyst Associate 3