Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 4 question 5 discussion

Actual exam question from Microsoft's DP-300

Question #: 5
Topic #: 4

You have SQL Server on an Azure virtual machine that contains a database named DB1.
You view a plan summary that shows the duration in milliseconds of each execution of query 1178902 as shown in the following exhibit:

What should you do to ensure that the query uses the execution plan which executes in the least amount of time?

A. Force the query execution plan for plan 1221065.
B. Run the DBCC FREEPROCCACHE command.
C. Force the query execution plan for plan 1220917.
D. Disable parameter sniffing.

Show Suggested Answer

Suggested Answer: A 🗳️

by MartinHBA at March 14, 2021, 10:28 a.m.

Comments

Submit Cancel

MartinHBA

Highly Voted 2 years, 9 months ago

correct is A

upvoted 41 times

Prada

2 years, 9 months ago

Agree, 1221065 has the lower execution time. Therefore, the better option is A

upvoted 11 times

...

Pranava_GCP

Most Recent 7 months, 3 weeks ago

Selected Answer: A

A is correct answer. https://learn.microsoft.com/en-us/sql/relational-databases/performance/query-store-usage-scenarios?view=sql-server-ver16#pinpoint-and-fix-queries-with-plan-choice-regressions

upvoted 3 times

...

LarsLarsgren

1 year, 4 months ago

Answer should be A. There is an example given at: https://azure.microsoft.com/de-de/blog/query-store-a-flight-data-recorder-for-your-database/ see: Step 3: Fix performance for regressed queries

upvoted 3 times

...

Itsalwaymethecap

1 year, 5 months ago

Selected Answer: A

Answer A: Need to force the planid 1221065

upvoted 1 times

...

Chunchi

1 year, 7 months ago

Selected Answer: A

The answer is A . 1221065 has the lower execution time/more faster.

upvoted 1 times

...

kcocaep

1 year, 8 months ago

yes, force execution plan for 1221065 is low. So we are forcing 1220917 to use change the query plan (to use 1221065 plan). Its a word game guys

upvoted 4 times

...

CaptainJameson

1 year, 9 months ago

Selected Answer: A

1221065 Is much faster as can be seen in the image

upvoted 2 times

...

quermi

2 years ago

Shows the duration in milliseconds . The queyr 1221065 is close to o ms, and 1220917 is over 250000 ms. Then A is ok

upvoted 1 times

...

TheSwedishGuy

2 years, 1 month ago

The answer "A. Force the query execution plan for plan 1221065" is obviously correct.

upvoted 1 times

...

alzahrani3

2 years, 3 months ago

1220917 < 1221065 so the correct answer is C

upvoted 2 times

valente_sven1

2 years, 2 months ago

This explanation make me laugh. :)

upvoted 9 times

...

Behto

2 years, 2 months ago

This is the ID of the execution plan, not its duration. You can see its duration in the chart and clearly conclude that the execution plan with the id 1221065 is the fastest.

upvoted 3 times

...