Microsoft Certified Data Analyst Associate Azure Data Analyst Associate 2 — Questions and Answers
Question 1: In Power BI, which DAX function returns the current row context value from a related table?
- RELATED() (Correct answer)
- LOOKUPVALUE()
- CALCULATE()
- USERELATIONSHIP()
Correct answer: RELATED()
RELATED() traverses a many-to-one relationship to fetch a column value from the related table in the current row context.
Question 2: A data analyst needs to schedule automatic dataset refresh in Power BI Service. What is the maximum number of daily refreshes allowed on a Power BI Pro license?
- 4
- 8 (Correct answer)
- 24
- 48
Correct answer: 8
Power BI Pro allows up to 8 scheduled refreshes per day per dataset.
Question 3: Which Power BI feature allows you to define reusable data transformation logic that can be called from multiple queries?
- Parameters
- Custom Functions (Correct answer)
- Query Groups
- Data Flows
Correct answer: Custom Functions
Custom Functions in Power Query allow you to encapsulate transformation steps and invoke them across multiple queries.
Question 4: When using DirectQuery mode in Power BI, which of the following is a known limitation?
- Data cannot be filtered
- Calculated tables are not supported (Correct answer)
- Row-level security cannot be applied
- Relationships cannot be created
Correct answer: Calculated tables are not supported
Calculated tables are not supported in DirectQuery mode because they require data to be stored in the model, which DirectQuery does not do.
Question 5: An analyst wants to compare sales performance against a dynamic benchmark that changes based on slicer selection. Which DAX function is most appropriate?
- SELECTEDVALUE() (Correct answer)
- HASONEVALUE()
- VALUES()
- ALLSELECTED()
Correct answer: SELECTEDVALUE()
SELECTEDVALUE() returns the value of a column when the context contains exactly one distinct value, making it ideal for capturing slicer selections.
Question 6: In Power BI Desktop, what does the 'Manage Relationships' dialog allow you to configure that the automatic detection cannot?
- Table joins only
- Cross-filter direction and cardinality (Correct answer)
- Query folding settings
- Data source credentials
Correct answer: Cross-filter direction and cardinality
The Manage Relationships dialog lets you manually set cardinality (one-to-many, many-to-many) and cross-filter direction (single or both).
Question 7: Which Power BI Service feature enables analysts to subscribe colleagues to a report and send email snapshots on a schedule?
- Data Alerts
- Email Subscriptions (Correct answer)
- Usage Metrics
- Export to PDF
Correct answer: Email Subscriptions
Email Subscriptions in Power BI Service allow users to schedule and send report or dashboard snapshots to themselves and others automatically.
Microsoft Certified Data Analyst Associate Azure Data Analyst Associate 2
In Power BI, which DAX function returns the current row context value from a related table?