Microsoft Certified Data Analyst Associate Analyzing Data with Microsoft Power BI 2 — Questions and Answers
Question 1: Which Power BI feature allows you to ask natural language questions about your data and get visual answers?
- Quick Insights
- Q&A (Correct answer)
- Analyze in Excel
- Smart Narratives
Correct answer: Q&A
Q&A lets users type natural language questions and Power BI returns an appropriate visualization based on the data model.
Question 2: A report has a slicer for 'Year' and a bar chart. You want the chart to ignore the slicer filter. What should you configure?
- Edit interactions and set the slicer to have no filter on the chart (Correct answer)
- Delete the slicer and use a page filter instead
- Use CALCULATE to override the slicer context
- Add a visual-level filter to the chart
Correct answer: Edit interactions and set the slicer to have no filter on the chart
In Power BI, you can use Edit Interactions to control how visuals interact, including setting a slicer to have no filter effect on specific visuals.
Question 3: What does the USERELATIONSHIP function do in DAX?
- Creates a new relationship between two tables
- Activates an inactive relationship for use within a specific calculation (Correct answer)
- Removes an existing relationship temporarily
- Forces a bidirectional filter on a relationship
Correct answer: Activates an inactive relationship for use within a specific calculation
USERELATIONSHIP activates an inactive relationship between two columns for the duration of a specific DAX expression.
Question 4: Which aggregation function in Power BI would you use to count only the distinct values in a column?
- COUNT
- COUNTA
- DISTINCTCOUNT (Correct answer)
- COUNTROWS
Correct answer: DISTINCTCOUNT
DISTINCTCOUNT counts the number of unique non-blank values in a column, ignoring duplicates.
Question 5: You need to display the percentage each product contributes to total sales. Which DAX pattern accomplishes this?
- SUM(Sales[Amount]) / MAX(Sales[Amount])
- SUM(Sales[Amount]) / CALCULATE(SUM(Sales[Amount]), ALL(Products)) (Correct answer)
- DIVIDE(SUM(Sales[Amount]), COUNTROWS(Sales))
- SUM(Sales[Amount]) / AVERAGE(Sales[Amount])
Correct answer: SUM(Sales[Amount]) / CALCULATE(SUM(Sales[Amount]), ALL(Products))
Using CALCULATE with ALL removes the product filter context so the denominator returns total sales across all products.
Question 6: Which Power BI visual type is best suited for showing the relationship and distribution between two continuous numeric variables?
- Clustered bar chart
- Scatter chart (Correct answer)
- Treemap
- Funnel chart
Correct answer: Scatter chart
A scatter chart plots data points using two numeric axes, making it ideal for identifying correlations and distributions between two continuous variables.
Question 7: What is the purpose of a 'drillthrough' page in Power BI?
- To allow users to expand hierarchy levels in a visual
- To provide a dedicated detail page that users navigate to by right-clicking a data point (Correct answer)
- To display data at multiple aggregation levels simultaneously
- To embed an external URL within a report page
Correct answer: To provide a dedicated detail page that users navigate to by right-clicking a data point
A drillthrough page is a separate report page that users reach by right-clicking a data point, filtered to show details for that specific item.
Microsoft Certified Data Analyst Associate Analyzing Data with Microsoft Power BI 2
Which Power BI feature allows you to ask natural language questions about your data and get visual answers?