Crucial Exams

Microsoft Power BI Data Analyst Practice Question

You are optimizing a Power BI data model that currently occupies 1.2 GB in memory and performs sluggishly when users interact with visuals. Profiling shows that the FactSales table contains 50 million rows and three columns (RowGuid, ETLLoadDate, Comments) that are never referenced in reports, calculated columns, or measures. Which action will most directly reduce memory usage and improve query performance without affecting existing reports?

  • Hide the three columns in Model view so that report authors cannot select them.

  • Disable the Auto Date/Time option for new files in the Power BI Desktop global settings.

  • Use Power Query to remove the RowGuid, ETLLoadDate, and Comments columns and then refresh the dataset.

  • Set the summarization option of the three columns to "Do not summarize" in the properties pane.

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