Basic Concept: This question tests performance optimization for SQL workloads, including Query Store, automatic tuning, index/statistics maintenance, and engine-level resource behavior.
Why B is Correct: Use Transact-SQL to enable the force_last_good_plan option. is related to operational monitoring or tuning, but it must match the exact signal needed: query history, resource utilization, wait
/blocking detail, or automatic remediation. In this scenario, the important constraint is: You need to implement automatic tuning for the databases of MI1. Use Transact-SQL to enable the force_last_good_plan option. satisfies that constraint without adding an unrelated service or manual process.
Why A is Wrong: Use the REST API to call the patch operation and modify the AutomaticTuningServerMode property. is related to operational monitoring or tuning, but it must match the exact signal needed: query history, resource utilization, wait/blocking detail, or automatic remediation. It is useful in other troubleshooting paths, but this scenario requires a more specific monitoring or optimization feature.
Why C is Wrong: Automatic tuning uses built-in recommendations and verification to create/drop indexes or force last known good plans where supported. It does not expose the required metric, query history, wait
/blocking signal, or tuning mechanism; using it would not give the administrator the evidence requested.