🔥 3-day streak
Microsoft Azure Database Administrator Associate73 / 144
Question 73 of 144
You manage an Azure SQL Database at compatibility level 160. A reporting query intermittently spills large sorts to tempdb because SQL Server overestimates the memory grant on some executions and underestimates it on others, causing either wasted memory or disk spills. You want the engine to automatically adjust the memory grant over successive executions based on actual runtime usage, without rewriting the query or forcing plans. Which feature should you rely on?
Reviewed for accuracy · Report an issueNext question