Microsoft Certified Data Analyst Associate Azure Data Analyst Associate 4 — Questions and Answers
Question 1: An analyst notices that a DAX measure returns different results when placed in a table visual versus a card visual. What is the most likely cause?
- The measure has a syntax error
- The filter context differs between visuals based on row context in the table (Correct answer)
- Card visuals do not support DAX measures
- The data model has circular dependencies
Correct answer: The filter context differs between visuals based on row context in the table
Table visuals introduce row context for each row, which changes the filter context evaluated by the measure, while a card has no row context.
Question 2: Which Azure service acts as the central metadata and governance hub for tracking data lineage and classifying sensitive data assets across an organization?
- Azure Data Factory
- Microsoft Purview (Correct answer)
- Azure Monitor
- Azure Policy
Correct answer: Microsoft Purview
Microsoft Purview provides a unified data governance solution including data cataloging, classification, lineage tracking, and sensitivity labeling.
Question 3: In Power BI, which visual type is best suited for showing part-to-whole relationships across a hierarchy (e.g., region > country > city)?
- Treemap
- Sunburst chart
- Decomposition Tree (Correct answer)
- Waterfall chart
Correct answer: Decomposition Tree
The Decomposition Tree visual lets users interactively drill into hierarchical dimensions to analyze metric contributions at each level.
Question 4: A dataset has a many-to-many relationship between Products and Promotions. Which Power BI feature enables modeling this without a bridge table?
- Composite models with DirectQuery
- Many-to-many cardinality with bi-directional cross-filtering (Correct answer)
- Calculated columns with RELATED()
- Aggregation tables
Correct answer: Many-to-many cardinality with bi-directional cross-filtering
Power BI supports many-to-many cardinality natively, allowing direct relationships between two tables where neither side has unique keys.
Question 5: When publishing a Power BI report to a workspace, what determines whether other users can edit the report?
- The report's sensitivity label
- The user's workspace role (Viewer, Contributor, Member, or Admin) (Correct answer)
- Whether the dataset uses Import or DirectQuery mode
- The number of pages in the report
Correct answer: The user's workspace role (Viewer, Contributor, Member, or Admin)
Workspace roles in Power BI Service control edit permissions: Viewers can only read, while Contributors, Members, and Admins can modify content.
Question 6: An analyst needs to create a paginated report that exports cleanly to PDF with pixel-perfect layout for invoices. Which tool should they use?
- Power BI Desktop
- Power BI Report Builder (Correct answer)
- Power BI Mobile
- Excel with Power Query
Correct answer: Power BI Report Builder
Power BI Report Builder is the dedicated tool for creating paginated reports (.rdl files) with precise layout control suited for printing and PDF export.
Question 7: Which DAX function should an analyst use to create a virtual table of unique values from a column for use inside CALCULATE()?
- DISTINCT()
- VALUES() (Correct answer)
- ALL()
- FILTER()
Correct answer: VALUES()
VALUES() returns a one-column table of unique values including a blank row if referential integrity is violated, making it suitable as a filter argument in CALCULATE().
Microsoft Certified Data Analyst Associate Azure Data Analyst Associate 4
An analyst notices that a DAX measure returns different results when placed in a table visual versus a card visual.
What is the most likely cause?