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 4 Question 118 Discussion

You need to recommend a solution to ensure that the performance of DB3 is optimized after the migration to Azure SQL Database. The solution must meet availability requirements.What should you include in the recommendation?
C) vertical scaling
A) Resource Governor
B) a custom resource pool
D) horizontal scaling

Microsoft DP-300 Exam - Topic 4 Question 118 Discussion

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

You need to recommend a solution to ensure that the performance of DB3 is optimized after the migration to Azure SQL Database. The solution must meet availability requirements.

What should you include in the recommendation?

Show Suggested Answer Hide Answer
Suggested Answer: C

by Amira at Jul 31, 2025, 08:26 AM

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
Werner
9 months ago
Wait, can vertical scaling really handle all that traffic?
upvoted 0 times
...
Lenny
9 months ago
A custom resource pool? Not sure that’s the best choice.
upvoted 0 times
...
Beckie
9 months ago
I think vertical scaling is the way to go!
upvoted 0 times
...
Malinda
10 months ago
Horizontal scaling is definitely more flexible.
upvoted 0 times
...
Leota
10 months ago
Resource Governor helps manage workloads effectively.
upvoted 0 times
...
Virgina
10 months ago
A custom resource pool sounds familiar, but I can't recall if it directly addresses performance after migration.
upvoted 0 times
...
Mitzie
11 months ago
I practiced a similar question where horizontal scaling was mentioned as a solution, but I’m not sure if it fits this scenario.
upvoted 0 times
...
Argelia
11 months ago
I think vertical scaling might be the way to go since it can improve performance, but I’m not confident about the availability aspect.
upvoted 0 times
...
Lavina
11 months ago
I remember we discussed Resource Governor in class, but I'm not entirely sure how it applies to Azure SQL specifically.
upvoted 0 times
...
Gregg
11 months ago
Vertical scaling seems like it could be a good solution, but I'm not sure if it would fully address the availability requirements. I'll need to do some more research on the pros and cons of each option.
upvoted 0 times
...
Ivory
11 months ago
Resource Governor sounds like it could be a good option, but I'm not entirely sure how it would work in this scenario. I'll have to review the material on that feature again.
upvoted 0 times
...
Dean
11 months ago
Hmm, I'm a bit unsure about this one. I'm torn between B and D, but I'm not sure which one would be the better choice. I'll have to think it through a bit more.
upvoted 0 times
...
Tammara
12 months ago
I think I'll go with option B - a custom resource pool. That seems like the best way to ensure the performance is optimized while still meeting the availability requirements.
upvoted 0 times
...
Truman
1 year ago
I agree with Francisca, horizontal scaling can improve performance by adding more resources.
upvoted 0 times
...
Noe
1 year ago
C) Vertical scaling is the way to go. It's like upgrading your computer - sure, you might have to sell a kidney, but at least your database will run like a cheetah on Red Bull.
upvoted 0 times
Teri
9 months ago
Plus, it simplifies management. Great call!
upvoted 0 times
...
Wilda
9 months ago
Upgrading resources can really make a difference.
upvoted 0 times
...
Cassi
9 months ago
Vertical scaling is definitely the best choice!
upvoted 0 times
...
Werner
10 months ago
Totally agree! It boosts performance significantly.
upvoted 0 times
...
...
Ty
1 year ago
B) a custom resource pool? Isn't that just a fancy way of saying 'let's overcomplicate things'? I'll stick with the simple solution, thank you very much.
upvoted 0 times
Mirta
1 year ago
A) Resource Governor
upvoted 0 times
...
...
Karan
1 year ago
A) Resource Governor? Sounds like something from a dystopian novel. I'm not sure I want my database to be governed by anyone or anything!
upvoted 0 times
...
Quentin
1 year ago
D) Horizontal scaling is the way to the future! Throw more servers at the problem and watch it disappear. It's like the cloud version of 'more cowbell'.
upvoted 0 times
Clay
1 year ago
A) Resource Governor
upvoted 0 times
...
...
Francisca
1 year ago
But horizontal scaling can help distribute the workload more efficiently.
upvoted 0 times
...
Karan
1 year ago
C) Vertical scaling sounds like the way to go. I mean, who doesn't love a good ol' vertical upgrade? It's like going from a Honda Civic to a Ferrari - sure, it might cost ya, but the performance boost is worth it!
upvoted 0 times
Vallie
1 year ago
B) a custom resource pool
upvoted 0 times
...
Youlanda
1 year ago
A) Resource Governor
upvoted 0 times
...
...
Princess
1 year ago
I disagree, I believe vertical scaling would be more effective.
upvoted 0 times
...
Francisca
1 year ago
I think we should go with horizontal scaling.
upvoted 0 times
...

Save Cancel