Administering Relational Databases on Microsoft Azure — Question 21

You have an Azure SQL Database managed instance.
The instance starts experiencing performance issues.
You need to identify which query is causing the issue and retrieve the execution plan for the query. The solution must minimize administrative effort.
What should you use?

Answer options

• A. SQL Profiler
• B. Extended Events
• C. Query Store
• D. dynamic management views

Correct answer: C

Explanation

The correct answer is C, Query Store, as it is specifically designed for tracking query performance and execution plans with minimal configuration. SQL Profiler (A) and Extended Events (B) require more administrative effort and are less efficient for long-term monitoring of query performance. Dynamic management views (D) provide real-time insights but do not store historical execution plans like Query Store does.