Storage Modes Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Get or Connect to Data

What you'll be asked

  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. 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. 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. What is a primary trade-off when choosing DirectQuery over Import mode for a large dataset?
  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?

Answers and explanations come after you submit.