DP-300: Administering Microsoft Azure SQL Solutions

By Microsoft · Question Mode

QuestionQ21

Monitor, configure, and optimize database resources

You have an Azure SQL Database managed instance that begins to experience performance problems.

You need to identify the query causing the problem and obtain that query’s execution plan. The solution must minimize administrative effort.

What should you use?

Explanation

Query Store automatically retains query history, execution plans, and runtime statistics, enabling investigation of high-resource or regressed queries and review of their plans with minimal ongoing administration. It is supported by Azure SQL Managed Instance.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!