ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam
Go to Exam

Exam DP-300 topic 4 question 1 discussion

Actual exam question from Microsoft's DP-300
Question #: 1
Topic #: 4
[All DP-300 Questions]

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
Show Suggested Answer Hide Answer
Suggested Answer: BC 🗳️
by lobr at Dec. 10, 2022, 6:14 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
voodoo_sh
7 months ago
Selected Answer: BC
use DB1 alter database scoped configuration set LIGHTWEIGHT_QUERY_PROFILING = on alter database scoped configuration set LAST_QUERY_PLAN_STATS = on
upvoted 1 times
...
2f5c7cd
10 months ago
Selected Answer: BC
bc
upvoted 1 times
...
bingomutant
10 months, 1 week ago
AC - Why B (Lightweight Query Profiling) is not the correct option: Lightweight Query Profiling (LWP) provides a way to monitor query execution with minimal overhead, but it does not specifically capture the parameter values used in the last executed query. It is designed for gathering general execution statistics, such as CPU time, execution steps, etc., but not the actual parameter values used during the last execution.
upvoted 1 times
...
dorwai
11 months, 3 weeks ago
Selected Answer: AC
Lightweight Query Profiling (LWP) is used to monitor query execution in a lightweight manner, but it doesn't specifically capture the last executed query's parameters.
upvoted 1 times
...
pjfunner
1 year, 2 months ago
Selected Answer: BE
Chat says B, E: the correct answers are B (Enable Lightweight_Query_Profiling in DB1) and E (Enable PARAMETER_SNIFFING in DB1). These actions will help you capture and analyze parameter values for your sales report queries.
upvoted 1 times
...
KingChuang
2 years, 6 months ago
Selected Answer: BC
I think answer given is correct. Ref: https://learn.microsoft.com/en-us/sql/relational-databases/performance/query-profiling-infrastructure?view=sql-server-ver16
upvoted 3 times
Sr18
1 year, 1 month ago
It is correct, B is obviously first choice but Query Plan can be used for same In the query plan XML (from the query_plan column), look for the ParameterCompiledValue node to find the compiled parameter value
upvoted 1 times
...
...
mmat
2 years, 7 months ago
Not sure if "C. Enable Last_Query_Plan_Stats in DB1" would capture anything related to parameters.
upvoted 1 times
...
lobr
2 years, 8 months ago
Is it ok?
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel