You have an Azure SQL managed instance named MI1. You need to implement automatic tuning for the databases of MI1. What should you do?

The correct answer is B. Use Transact-SQL to enable the force_last_good_plan option. For Azure SQL Managed Instance, the supported option FORCE_LAST_GOOD_PLAN can only be configured through T-SQL. The Azure portal based configuration and automatic index tuning options described in this article do not apply to Azure SQL Managed Instance…

Submitted by weili_xi· Mar 6, 2026Monitor, configure, and optimize database resources

Question

You have an Azure SQL managed instance named MI1. You need to implement automatic tuning for the databases of MI1. What should you do?

Options

AUse the REST API to call the patch operation and modify the AutomaticTuningServerMode property.
BUse Transact-SQL to enable the force_last_good_plan option.
CFrom the Azure portal, configure automatic tuning.

How the community answered

(68 responses)

A
12% (8)
B
79% (54)
C
9% (6)

Explanation

For Azure SQL Managed Instance, the supported option FORCE_LAST_GOOD_PLAN can only be configured through T-SQL. The Azure portal based configuration and automatic index tuning options described in this article do not apply to Azure SQL Managed Instance. https://learn.microsoft.com/en-us/azure/azure-sql/database/automatic-tuning- enable?view=azuresql

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice