Administering Relational Databases on Microsoft Azure — Question 25

You have an Azure SQL managed instance named MI1.

You need to implement automatic tuning for the databases of MI1.

What should you do?

Answer options

• A. Use The REST API to call the patch operation and modify the AutomaticTuningServerMode property.
• B. From the Azure portal, configure automatic tuning.
• C. Use Transact-SQL to enable the FORCE_LAST_GOOD_PLAN option.

Correct answer: C

Explanation

The correct answer is C because enabling the FORCE_LAST_GOOD_PLAN option through Transact-SQL directly facilitates automatic tuning by retaining the best-performing execution plans. Option A is incorrect as modifying the AutomaticTuningServerMode property does not directly relate to enabling automatic tuning for databases. Option B is incorrect because while configuring automatic tuning through the Azure portal is possible, the question specifically asks for a method that directly activates tuning through code.