Microsoft Certified Data Analyst Associate Azure Data Analyst Associate 3 — Questions and Answers
Question 1: What is the purpose of the CALCULATE() function in DAX when used without any filter arguments?
- It removes all filters from the model
- It evaluates an expression in a modified filter context, preserving the existing context (Correct answer)
- It returns an error because filter arguments are required
- It calculates across all rows ignoring slicers
Correct answer: It evaluates an expression in a modified filter context, preserving the existing context
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?
- Object-level security
- Row-level security (RLS) (Correct answer)
- Column-level security
- Workspace permissions
Correct answer: Row-level security (RLS)
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?
- Table.Join
- Table.Combine (Correct answer)
- Table.NestedJoin
- Table.Merge
Correct answer: Table.Combine
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?
- Dedicated pools support only structured data; serverless supports only unstructured
- Dedicated pools provision fixed compute resources; serverless pools charge per query processed (Correct answer)
- Dedicated pools are free; serverless pools have fixed monthly costs
- Dedicated pools use T-SQL; serverless pools use Python only
Correct answer: Dedicated pools provision fixed compute resources; serverless pools charge per query processed
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?
- Import (Correct answer)
- DirectQuery
- Live Connection
- Composite (hybrid)
Correct answer: Import
Import mode loads data into Power BI's in-memory VertiPaq engine, providing the fastest query performance regardless of source system speed.
Question 6: Which DAX time intelligence function calculates the cumulative total from the beginning of the year to the current date in context?
- TOTALYTD() (Correct answer)
- DATESYTD()
- SAMEPERIODLASTYEAR()
- DATESBETWEEN()
Correct answer: TOTALYTD()
TOTALYTD() is a shorthand that wraps CALCULATE() with DATESYTD() to return a year-to-date aggregation.
Question 7: In Power BI, what does 'query folding' mean?
- Collapsing multiple M steps into one for readability
- Pushing transformation logic back to the data source to execute natively (Correct answer)
- Caching query results in the Power BI gateway
- Combining queries from different data sources into one
Correct answer: Pushing transformation logic back to the data source to execute natively
Query folding occurs when Power Query translates M transformation steps into native source queries (e.g., SQL), allowing the source system to handle execution.
Microsoft Certified Data Analyst Associate Azure Data Analyst Associate 3
What is the purpose of the CALCULATE() function in DAX when used without any filter arguments?