Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-300 Exam - Topic 5 Question 54 Discussion

You have an Azure SQL database named db1 on a server named server1.The Intelligent Insights diagnostics log identifies queries that cause performance issues due to tempDB contention.You need to resolve the performance issues.What should you do?
A) Implement memory-optimized tables.
B) Run the dbcc flushprocindB command.
C) Replace the sequential index keys with nonsequential keys.
D) Run the dbcc dbreindex command.

Microsoft DP-300 Exam - Topic 5 Question 54 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 54
Topic #: 5
[All DP-300 Questions]

You have an Azure SQL database named db1 on a server named server1.

The Intelligent Insights diagnostics log identifies queries that cause performance issues due to tempDB contention.

You need to resolve the performance issues.

What should you do?

Show Suggested Answer Hide Answer
Suggested Answer: A

https://docs.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-troubleshoot-performance#tempdb-contention

by Vincenza at May 27, 2022, 09:16 PM

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Bo
7 months ago
Wait, can tempDB contention really be fixed this way?
upvoted 0 times
...
Jacquline
7 months ago
D seems outdated, not sure it’s relevant anymore.
upvoted 0 times
...
Melissa
7 months ago
C sounds interesting, but not sure it’ll help much.
upvoted 0 times
...
Daisy
8 months ago
I disagree, B might be more effective here.
upvoted 0 times
...
Ashlee
8 months ago
A is a solid choice for tempDB issues.
upvoted 0 times
...
Rasheeda
8 months ago
This question feels similar to one we practiced on performance tuning. I wonder if replacing sequential index keys could actually reduce contention.
upvoted 0 times
...
Una
8 months ago
I think implementing memory-optimized tables could help, but I’m not entirely confident if that’s the best approach for tempDB problems.
upvoted 0 times
...
Lisbeth
8 months ago
I remember reading about tempDB contention, but I'm not sure which option directly addresses that issue.
upvoted 0 times
...
Florinda
8 months ago
I vaguely recall that dbcc commands are more for maintenance than for resolving contention issues. I’m leaning towards option A, but I’m not completely sure.
upvoted 0 times
...
Janine
8 months ago
Ugh, I hate long package paths. At least option A gives us a way to deal with it, so I'll consider that one.
upvoted 0 times
...
Tamar
8 months ago
I'm a little confused by this question. Wouldn't deleting the backup be the worst thing to do? I'm leaning towards submitting the file, but I want to make sure I'm not missing something.
upvoted 0 times
...
Colton
8 months ago
I think the answer is GLBP. It's designed to maximize uplink utilization and minimize configuration compared to the other options.
upvoted 0 times
...

Save Cancel