🔥 3-day streak
Microsoft Azure Database Administrator Associate24 / 144
Question 24 of 144
An Azure SQL Database (compatibility level 150) hosts a large rowstore-only reporting table. Analysts run heavy aggregation queries (SUM, GROUP BY) over millions of rows, and execution plans show these queries process rows one at a time, consuming significant CPU. There are no columnstore indexes, and business rules prohibit adding them. Which Intelligent Query Processing feature is designed to improve these CPU-bound analytic queries without a columnstore index?
Reviewed for accuracy · Report an issueNext question