DP-300 · Question #12
DP-300 Question #12: Real Exam Question with Answer & Explanation
Sign in or unlock DP-300 to reveal the answer and full explanation for question #12. The question stem and answer options stay visible for context.
Question
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.
Options
- AEnable Last_Query_Plan_Stats in the master database
- BEnable Lightweight_Query_Profiling in DB1
- CEnable Last_Query_Plan_Stats in DB1
- DEnable Lightweight_Query_Profiling in the master database
- EEnable PARAMETER_SNIFFING in DB1
Unlock DP-300 to see the answer
You've previewed enough free DP-300 questions. Unlock DP-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.