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

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

Microsoft Administering Relational Databases on Microsoft Azure DP-300 Question # 51 Topic 6 Discussion

 Microsoft Discussions      Browse All Questions      Go to Exam Detail      Get Premium Access
 Previous
Next  

Microsoft Administering Relational Databases on Microsoft Azure DP-300 Question # 51 Topic 6 Discussion

DP-300 Exam Topic 6 Question 51 Discussion:
Question #: 51
Topic #: 6

You have SQL Server on an Azure virtual machine that contains a database named DB1.

You have an application that queries DB1 to generate a sales report.

You need to see the parameter values from the last time the query was executed.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.
A.

Enable Last_Query_Plan_Stats in the master database

B.

Enable Lightweight_Query_Profiling in DB1

C.

Enable Last_Query_Plan_Stats in DB1

D.

Enable Lightweight_Query_Profiling in the master database

E.

Enable PARAMETER_SNIFFING in DB1

Get Premium DP-300 Questions
Actual exam question for Microsoft DP-300 exam by Nyx80163 at Jun 2, 2026, 7:19:55 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
 Previous
Next