Crucial Exams

Microsoft Power BI Data Analyst Practice Question

Your Power BI model contains a fact table with 1.2 billion transaction rows stored in DirectQuery mode against Azure Synapse. Most report visuals display sales amounts by month and product category, and users complain that visuals take several seconds to render. You must improve query performance without significantly increasing the model's memory footprint or removing the ability to drill through to the detailed rows. What should you do?

  • Create an Import-mode table that summarizes the fact data by month and product category, mark it as an aggregation table, and keep the original fact table in DirectQuery mode.

  • Enable the Auto date/time option so Power BI automatically caches monthly totals for the current visuals.

  • Add a row-level security role that restricts the fact table to the last 24 months of data for all users.

  • Change the storage mode of the existing fact table from DirectQuery to Import so that all data is cached in memory.

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