BenchMark Quizzes by MDFT Pro

Your data model at MDFT Pro contains Product, Sales, and Calendar tables. The requirements for each table are as follows:

The Product table is small and updated infrequently
The Calendar table is small and updated infrequently
The Sales table is very large and needs immediate updates for accurate reporting

Which storage mode should you use for each table to ensure optimal performance and data freshness?

Choose all correct answers from the options below.

Explanations for each answer:

Product: Import is correct. Import is best for tables with a few thousand rows that are updated infrequently, providing fast performance.
Sales: Import is incorrect. Importing a very large Sales table can cause performance issues and slow refresh times. Import mode also does not provide immediate updates.
Sales: DirectQuery is correct. DirectQuery is ideal for large tables with millions of rows that need immediate updates in reports.
Calendar: Import is correct. Calendar tables are rarely updated and small, so Import is the most efficient storage mode.

Learn more about storage modes in Power BI:

Exam Preparation Quiz