Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 4 question 6 discussion

Actual exam question from Microsoft's DP-300

Question #: 6
Topic #: 4

HOTSPOT -
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:

Show Suggested Answer

Suggested Answer:

Box 1: No -
By default CREATE INDEX is disabled. It is here configured as INHERIT so it is disabled.

Box 2: No -
By default DROP INDEX is disabled.

Box 3: Yes -
FORCE LAST GOOD PLAN (automatic plan correction) - Identifies Azure SQL queries using an execution plan that is slower than the previous good plan, and queries using the last known good plan instead of the regressed plan.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/automatic-tuning-enable

by humpy at March 30, 2021, 3:34 a.m.

Comments

Submit Cancel

cck21

Highly Voted 4 years, 2 months ago

Answer given is correct. Refer to current state, is ON

upvoted 20 times

...

humpy

Highly Voted 4 years, 2 months ago

Should be No, NO, Yes, As Azure defaults are FORCE_LAST_GOOD_PLAN is enabled, CREATE_INDEX is disabled, and DROP_INDEX is disabled. https://docs.microsoft.com/en-us/azure/azure-sql/database/automatic-tuning-enable

upvoted 14 times

learnazureportal

3 years, 10 months ago

You're not correct for the item #1.

upvoted 2 times

...

Eleonora77

3 years, 12 months ago

Raffer is right. The point of this question is that new values are given in the screenshot

upvoted 3 times

...

Raffer

4 years, 2 months ago

The defaults have been overridden in this scenario.

upvoted 8 times

...

sca88

Most Recent 1 year, 2 months ago

https://learn.microsoft.com/en-us/azure/azure-sql/database/automatic-tuning-enable?view=azuresql The answer is correct: NNY "On the server level you can choose to inherit automatic tuning configuration from Azure Defaults or not." This is the case. "Azure Defaults are FORCE_LAST_GOOD_PLAN enabled, CREATE_INDEX disabled and DROP_INDEX disabled"

upvoted 1 times

...

susejzepol

2 years ago

Answer is fine, according to the documentation of microsoft: Azure defaults are FORCE_LAST_GOOD_PLAN enabled, CREATE_INDEX disabled, and DROP_INDEX disabled.

upvoted 3 times

...

des2907

2 years, 6 months ago

Why the first statment is NO if the current state is ON (even when it is INHERIT)

upvoted 4 times

jtrain

10 months, 2 weeks ago

I'm wondering the same thing.

upvoted 1 times

...

cusman

3 years, 2 months ago

Yes - It will create nonclustered indexes No - It can't add columns to existing indexes Yes - It will revert to prior plans automatically in case of regression

upvoted 13 times

...

Fedor

3 years, 6 months ago

Raffer is right. The point of this question is that new values are given in the screenshot Now I see current state ON (for All settings) - IN RIGHT SIDE 1 Y - ( Create Index ON ) ,N ,Y So given answer is correct

upvoted 8 times

Pranava_GCP

2 years, 2 months ago

Agreed, should be 'YNY', to use Current State instead of 'desired state'

upvoted 2 times

...

SQLHell

3 years, 6 months ago

No, No , Yes https://docs.microsoft.com/en-us/azure/azure-sql/database/automatic-tuning-enable

upvoted 1 times

...

Fedor

3 years, 6 months ago

https://docs.microsoft.com/en-us/azure/azure-sql/database/automatic-tuning-enable As of March, 2020 new Azure defaults for automatic tuning are as follows: • FORCE_LAST_GOOD_PLAN = enabled , CREATE_INDEX = disabled, and DROP_INDEX = disabled. As CREATE_INDEX = disabled - so 1-st seems to be inherited and NO

upvoted 3 times

...