BenchMark Quizzes by MDFT Pro

Select Storage Modes For Power BI Tables

You are creating a dataset and modeling data for a Power BI report at MDFT Academy. The report should contain up-to-date information for trainers and students, and you need to choose the best storage mode for each requirement.

You intend to use the Import storage mode. For which scenarios should you use this storage mode to ensure optimal performance and data freshness?

Choose all correct answers from the options below.

Explanations for each answer:

Use Customer and Territory as slicers is correct. Import mode is suitable for tables with a few thousand records and infrequent updates, providing fast performance for slicers.
Use the Q&A feature in reports with calculated tables is correct. Import mode is required for Q&A features using calculated tables.
Create a calculated table using DAX is correct. Calculated tables require Import mode for full DAX support.
Display visualizations containing current Sales data is incorrect. DirectQuery is best for large, frequently updated tables to ensure up-to-date data in visualizations.

Learn more about storage modes in Power BI:

Power BI Storage Modes

Exam Preparation Quiz

Select Storage Modes For Power BI Tables