Free Microsoft Azure DP-300 Actual Exam Questions - Question 14 Discussion
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. 
I agree with saying No for forced plan since it’s off in the config. Also, the statement about automatic index creation and dropping should be Yes because they’re clearly enabled. The question is pretty straightforward if you just focus on what’s toggled on or off in the settings shown. The confusion probably comes from mixing up current versus recommended states, but from what I see here, it’s definitely the current settings, so trust those for your answers.
I’d say No for the forced plan statement because it’s set to off in the current config. So even if a regression is detected, it won’t automatically force a plan. The other tuning options are clearly enabled though.
I think the key here is that the forced plan option is off according to the image, so it shouldn’t automatically force plans even if it detects regressions. That supports saying No for that statement. Since automatic tuning is enabled for creating and dropping indexes, Yes for both of those makes sense. Also, automatic tuning usually won’t affect things unless it’s explicitly turned on, so sticking with what’s shown in the config seems safest.
Looks like automatic tuning is mostly on, so Yes for index creation and drop, No for forced plan.