DP-300 Certification Practice Question #165

Question

You have SQL Server on an Azure virtual machine that contains a database named Db1.
You need to enable automatic tuning for Db1.
How should you complete the statements? To answer, select the appropriate answer in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Accepted Answer

To enable automatic tuning (specifically plan correction) on SQL Server hosted on an Azure Virtual Machine, you must first satisfy the pre-requisite of enabling the Query Store in read-write mode, using the statement `SET QUERY_STORE=ON(OPERATION_MODE=READ_WRITE)`. Once Query Store is collecting data, you can enable automatic plan correction using the command `SET AUTOMATIC_TUNING (FORCE_LAST_GOOD_PLAN=ON)`. The option `SET AUTOMATIC_TUNING=AUTO` is only applicable for Azure SQL Database at the server/logical level, not for SQL Server on a virtual machine.

More DP-300 practice questions