Exam DP-300 topic 4 question 6 discussion

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

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

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"

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

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

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

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

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

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