DP-300 Certification Practice Question #169

Question

You have an Azure SQL database named DB1. The automatic tuning options for DB1 are configured as shown in the following exhibit.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Accepted Answer

1. **Statement 1 is Yes:** Based on the exhibit, the current state of `CREATE INDEX` is `ON` (Auto-configured by Azure). This feature automatically creates nonclustered indexes when missing indexes are identified that would improve database performance.
2. **Statement 2 is No:** Automatic tuning only creates (`CREATE INDEX`) and drops (`DROP INDEX`) indexes. It does not modify existing indexes by adding or removing columns.
3. **Statement 3 is Yes:** The current state of `FORCE PLAN` (Force Last Good Plan) is `ON`. This option detects plan choice regression and automatically forces SQL Server to revert to the last known good plan.

More DP-300 practice questions