Crucial Exams

Microsoft Power BI Data Analyst Practice Question

Users complain that a report page loads slowly. The page includes a table visual that shows 50 columns and tens of thousands of rows. You capture a Performance Analyzer trace and observe the following for the table visual: DAX query = 120 ms, Visual display = 4 200 ms, Other = 20 ms. Which action is most likely to significantly improve performance?

  • Disable the Auto date/time option in the report to shrink the hidden model metadata.

  • Rewrite the measure used by the visual to replace CALCULATE with an iterator function such as SUMX.

  • Convert all bidirectional relationships in the model to single-direction filters to shorten query execution.

  • Replace the detailed table with a summarized visual or reduce the number of displayed columns and rows.

Microsoft Power BI Data Analyst
Model the Data
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot