Microsoft DP-300 Exam - Topic 11 Question 66 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 66
Topic #: 11

[All DP-300 Questions]

You have an Azure SQL managed instance named MI1.

You need to implement automatic tuning for the databases of MI1.

What should you do?

AUse the REST API to call the patch operation and modify the AutomaticTuningServerMode property.

BUse Transact-SQL to enable the force_last_good_plan option.

CFrom the Azure portal, configure automatic tuning.

Show Suggested Answer

Suggested Answer: B

by Pamella at Dec 29, 2022, 01:43 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Freeman

4 months ago

I disagree, manual tuning is still better in complex scenarios.

upvoted 0 times

...

Teri

4 months ago

Automatic tuning is a game changer for performance!

upvoted 0 times

...

Hildegarde

4 months ago

Wait, can you really do that with the REST API?

upvoted 0 times

...

Shawana

4 months ago

I think B is more effective for specific queries.

upvoted 0 times

...

Leatha

5 months ago

C is the easiest way to set it up!

upvoted 0 times

...

Annamae

5 months ago

I definitely remember that automatic tuning can be set up in the Azure portal, but I’m not sure if it’s the best option compared to the others listed.

upvoted 0 times

...

Goldie

5 months ago

I’m a bit confused about the REST API option. I don’t recall using it for automatic tuning in our practice scenarios.

upvoted 0 times

...

Annalee

5 months ago

I feel like I've seen a question similar to this before, and I think using Transact-SQL might be more about specific tuning options rather than enabling automatic tuning itself.

upvoted 0 times

...

Dean

5 months ago

I think I remember something about configuring automatic tuning directly from the Azure portal, but I'm not entirely sure if that's the only way.

upvoted 0 times

...

Freeman

5 months ago

This is a tricky one, there are a few different angles to consider. I'll need to really think through each option and how they could negatively impact the company or financial reporting process.

upvoted 0 times

...

Pearlene

5 months ago

This looks like a straightforward probability sampling question. I'm pretty confident I can solve this one.

upvoted 0 times

...

Colene

5 months ago

I'm not so sure about option C. I don't think the teardrop technique is commonly used for logins, right?

upvoted 0 times

...

Glory

5 months ago

This question seems straightforward - I just need to calculate the threshold for major customer disclosure based on the given financial information.

upvoted 0 times

...

Shelba

5 months ago

Hmm, the challenge seems to be related to the service providers and their relationship with the service integrator. I'll need to think through the dynamics there.

upvoted 0 times

...