
Q1. Which configuration in SQL Server 2016 enables all query optimizer hotfixes from previous versions?
- Enabling Priority Boost
- Enabling Query Store
- Database compatibility level 130
- Running the Database Tuning Advisor
Q2. Fill in the blank
ALTER DATABASE _________ CONFIGURATION SET QUERY_OPTIMIZER_HOTFIXES = ON;
SCOPEDQ3. If you enable Query Optimizer Hotfixes at the database scope and want to test how a query compiles with it OFF, what could you do?
- Use the legacy cardinality estimator
- Enable Trace Flag 4199 globally instead
- Disable Trace Flag 4199 for your session
- Compile the query in the context of a database where Query Optimizer Hotfixes is off, using three-part naming
Q4. If you enable Trace Flag 4199 globally and want to test how a query compiles with it DISABLED, what could you do?
- Disable Trace Flag 4199 for your session
- Disable the trace flag globally
- Compile the query in the context of a database where Query Optimizer Hotfixes is off, using three-part naming
- Use the legacy cardinality estimator