Pre-Summer Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: validbest

Discussions
  1. Home
  2. Discussions
  3. Microsoft
  4. Microsoft Certified: Azure Database Administrator Associate
  5. DP-300 Discussions
  6. DP-300 Exam Topic 4 Question 34 Discussion
 Microsoft Discussions
Exam DP-300 All Questions
Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Go to Exam

Microsoft Certified: Azure Database Administrator Associate DP-300 Question # 34 Topic 4 Discussion

DP-300 Exam Topic 4 Question 34 Discussion:
Question #: 34
Topic #: 4

You have an Azure SQL managed instance.

You need to gather the last execution of a query plan and its runtime statistics. The solution must minimize the impact on currently running queries.

What should you do?
A.

Generate an estimated execution plan.

B.

Generate an actual execution plan.

C.

Run sys.dm_exec_query_plan_stats.

D.

Generate Live Query Statistics.

Get Premium DP-300 Questions
Actual exam question for Microsoft DP-300 exam by Orion12784 at May 7, 2026, 12:03:27 AM

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.

Submit