Analyzing Data with Microsoft Power BI Flashcards
7 cards from real Microsoft Certified Data Analyst Associate practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 7 Analyzing Data with Microsoft Power BI flashcards as text
Which Power BI feature allows you to ask natural language questions about your data and get visual answers?
Answer: Q&A
Q&A lets users type natural language questions and Power BI returns an appropriate visualization based on the data model.
A report has a slicer for 'Year' and a bar chart. You want the chart to ignore the slicer filter. What should you configure?
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.
What does the USERELATIONSHIP function do in DAX?
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.
Which aggregation function in Power BI would you use to count only the distinct values in a column?
Answer: DISTINCTCOUNT
DISTINCTCOUNT counts the number of unique non-blank values in a column, ignoring duplicates.
You need to display the percentage each product contributes to total sales. Which DAX pattern accomplishes this?
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.
Which Power BI visual type is best suited for showing the relationship and distribution between two continuous numeric variables?
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.
What is the purpose of a 'drillthrough' page in Power BI?
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.
How this page was made: written with AI tools and published by Nathan Beja, founder of Practice Test Geeks, who is responsible for its content. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- learn.microsoft.com — Passing score, renewal, fees, time limit, score validity, retake fee, exam information · verified Oct 2026
- pearsonvue.com — Test delivery · verified Oct 2026