DP-300: Administering Microsoft Azure SQL Solutions

By Microsoft · Question Mode

QuestionQ50

Monitor, configure, and optimize database resources

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

Question Image

For each statement below, select Yes if it is true. Otherwise, select No.

Yes or No
StatementsYesNo
Nonclustered indexes will be added to tables to improve performance.
Columns will be added to existing indexes automatically.
The query execution plan will revert to a previous plan if query performance degrades.
Explanation

With CREATE INDEX enabled, Azure SQL Database can automatically create recommended nonclustered indexes to improve workload performance. Automatic tuning does not modify an existing index by adding columns. With FORCE_LAST_GOOD_PLAN enabled, Azure SQL detects a regressed execution plan and forces the last known good plan.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!