DP-300 Certification Practice Question #51

Question

SIMULATION
 -

You need to ensure that any enhancements made to the Query Optimizer through patches are available to db1 and db2 on sql12345678.

To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.

Accepted Answer

Enabling query optimizer hotfixes at the database scoped level allows database-specific optimizer enhancements (equivalent to trace flag 4199) to be active. Since the requirement is to ensure enhancements made to the Query Optimizer through patches are available to both `db1` and `db2`, running `ALTER DATABASE SCOPED CONFIGURATION SET QUERY_OPTIMIZER_HOTFIXES = ON;` in the context of both databases is the correct administrative action.

More DP-300 practice questions