Storage Modes Quiz

Quiz covering Get or Connect to Data

Questions in this quiz

A preview of the 5 questions covered. Start the quiz above to answer them, check your score, and read the explanations.

1. 1

   When using the 'Import' storage mode in a reporting tool like Power BI, where is the data physically located after the refresh process is complete?

2. 2

   A company requires a dashboard that reflects changes in their SQL Server database as they happen, without waiting for a scheduled refresh. Which storage mode should the developer choose?

3. 3

   You are building a model where a specific dimension table (e.g., Date) is used by both an 'Import' fact table and a 'DirectQuery' fact table. Which storage mode for the Date table will provide the best performance by minimizing cross-source query overhead?

4. 4

   What is a primary trade-off when choosing DirectQuery over Import mode for a large dataset?

5. 5

   You are designing a solution for a dataset with 5 billion rows. Users need high-speed performance for yearly summaries but occasionally need to drill down to individual transactions. What is the most efficient architectural approach?