🔥 3-day streak
Microsoft Power BI Data Analyst21 / 205
Question 21 of 205

You are building a report for the finance department from a SQL Server table containing 500,000 rows of historical monthly ledger entries. The data is updated only once per month during a scheduled batch job. Report users complain that similar reports connected live to the database render slowly, and there is no requirement for real-time data. Which storage mode should you choose to give users the fastest possible query and visual performance?

Reviewed for accuracy · Report an issueNext question