Power BI for Data Analytics & Business Intelligence

Back to Ingestion Architecture, Power Query & Storage Modes

Quiz: Storage Modes, Ingestion & Query Folding

10 scenario-based psychometric questions testing storage mode trade-offs, Query Folding, and Power Query architecture.

8 minutesInteractive tutorial

🎯 Free Guest Mode: You are learning for free. Sign in to save your completion progress and quiz answers.

Question 1 of 10Answer saved0 answered

A data analyst connects Power BI Desktop to an Azure SQL Database containing 85 million transaction records. The business requires near-instant interactive slicer response times for historical executive dashboards, but data refreshes only once every 24 hours at midnight. Which storage mode should the analyst select, and why?

← Back to Diagnosing & Fixing Broken Query Folding in Power Query