New Year Sale 2026! 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 10 Question 24 Discussion

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

You have 20 Azure SQL databases provisioned by using the vCore purchasing model.

You plan to create an Azure SQL Database elastic pool and add the 20 databases.

Which three metrics should you use to size the elastic pool to meet the demands of your workload? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer: A, C, E

CE: Estimate the vCores needed for the pool as follows:

For vCore-based purchasing model: MAX(<Total number of DBs X average vCore utilization per DB>, <Number of concurrently peaking DBs X Peak vCore utilization per DB)

A: Estimate the storage space needed for the pool by adding the number of bytes needed for all the databases in the pool.


https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview

by Winfred at May 03, 2022, 05:28 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
Judy
4 months ago
Wait, are we really using average CPU for sizing? That seems off!
upvoted 0 times
...
Vallie
5 months ago
I agree, max concurrent sessions matter a lot for performance.
upvoted 0 times
...
Valentin
5 months ago
Not sure about geo-replication support being a sizing metric.
upvoted 0 times
...
Lawana
5 months ago
I think the number of concurrently peaking databases is crucial too!
upvoted 0 times
...
Shala
5 months ago
Definitely need to consider the total size of all the databases.
upvoted 0 times
...
Allene
5 months ago
I’m a bit confused about the average CPU utilization part. Would option E really help in sizing the pool effectively?
upvoted 0 times
...
Roslyn
5 months ago
I'm not entirely sure, but I feel like the total size of all the databases might be important too. Maybe option A?
upvoted 0 times
...
Adell
5 months ago
I remember we discussed the importance of CPU utilization, so I think option C could be relevant for sizing the elastic pool.
upvoted 0 times
...
Casandra
5 months ago
I think we practiced a question similar to this, and I recall that the maximum number of concurrent sessions is crucial for performance, so option D seems like a good choice.
upvoted 0 times
...
Fernanda
5 months ago
Okay, I've got this. The hacker is trying to exploit a software vulnerability to gain admin access and modify the site's configuration. That's a textbook privilege escalation attack. I'm confident this is the correct answer.
upvoted 0 times
...
Tamekia
5 months ago
I feel like I saw a similar question during practice that emphasized QoS settings. I'm leaning towards option C, but I'm not completely sure about it.
upvoted 0 times
...

Save Cancel