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
A time intelligence function like SAMEPERIODLASTYEAR requires what in order to work correctly?
Answer: A continuous date table marked as a date table
Time intelligence functions require a contiguous date table with no gaps that has been marked as a date table in the model.
Which visual in Power BI is specifically designed to display hierarchical data as nested rectangles sized by value?
Answer: Treemap
A treemap displays hierarchical data as a set of nested rectangles where the size of each rectangle represents the value of that category.
You want to prevent report users from seeing the underlying data by right-clicking a visual. Which feature should you configure?
Answer: Disable 'See data' in visual options
You can disable the 'See data' and 'Export data' options per visual in the visual's header icons or at the report level in settings.
What is the difference between a calculated column and a measure in Power BI?
Answer: Calculated columns are stored row by row in the table; measures are evaluated dynamically at query time
Calculated columns are computed during data refresh and stored in the model row by row, while measures are computed dynamically based on the current filter context when a visual is rendered.
In a Power BI report, which filter scope applies only to a single visual and does not affect other visuals on the page?
Answer: Visual-level filter
Visual-level filters in the Filters pane apply only to the specific visual they are set on, leaving other visuals unaffected.
What does the RANKX function return when two items have the same value?
Answer: The same rank for both, then skips the next rank
By default, RANKX assigns the same rank to tied items and then skips subsequent ranks (dense ranking must be specified explicitly).
Which Power BI service feature enables automatic page refresh at a defined interval for real-time data monitoring?
Answer: Automatic page refresh
Automatic page refresh in Power BI service allows report pages to refresh at a set interval (e.g., every 30 seconds) when connected to DirectQuery or streaming datasets.
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