exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 1 question 1 discussion

Actual exam question from Microsoft's DP-300
Question #: 1
Topic #: 1
[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.

  • A. total size of all the databases
  • B. geo-replication support
  • C. number of concurrently peaking databases * peak CPU utilization per database
  • D. maximum number of concurrent sessions for all the databases
  • E. total number of databases * average CPU utilization per database
Show Suggested Answer Hide Answer
Suggested Answer: ACE 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Waltmas
Highly Voted 4 years, 1 month ago
answer is correct
upvoted 23 times
...
wayejiv
Most Recent 5 days, 11 hours ago
Selected Answer: ACE
The best size for a pool depends on the aggregate resources needed for all databases in the pool. You need to determine: Maximum storage bytes utilized by all databases in the pool - A For the vCore-based purchasing model: https://ln.run/W3HEW MAX(<Total number of DBs × Average vCore utilization per DB>, <Number of concurrently peaking DBs × Peak vCore utilization per DB>) - C + E
upvoted 1 times
...
Jasmine121
3 weeks, 5 days ago
Selected Answer: ACE
https://azure.microsoft.com/en-us/pricing/details/azure-sql-database/elastic/?msockid=145e6c06ec6f666823a47958ed7f67ab Here you can find pricing for elastic pools, and (A) Max Num of DBs Per Pool shoud be considered (e.g. 100/200/500)
upvoted 1 times
...
TashaGirl
3 months, 3 weeks ago
The best size for a pool depends on the aggregate resources needed for all databases in the pool. You need to determine: Maximum storage bytes utilized by all databases in the pool - A For the vCore-based purchasing model: MAX(<Total number of DBs × Average vCore utilization per DB>, <Number of concurrently peaking DBs × Peak vCore utilization per DB>) - C + E
upvoted 1 times
...
TashaGirl
3 months, 3 weeks ago
For the vCore-based purchasing model: MAX(<Total number of DBs × Average vCore utilization per DB>, <Number of concurrently peaking DBs × Peak vCore utilization per DB>)
upvoted 1 times
...
MS_KoolaidMan
5 months, 2 weeks ago
Selected Answer: ACE
The given answer is correct based on the Microsoft Learn documentation. https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview?view=azuresql#how-do-i-choose-the-correct-pool-size
upvoted 2 times
...
b0redj0rd
1 year, 2 months ago
Selected Answer: ACE
ACE is the correct response.
upvoted 3 times
...
Michael_Z
1 year, 6 months ago
Selected Answer: ACE
Correct answer : ACE
upvoted 1 times
...
Pranava_GCP
1 year, 8 months ago
Selected Answer: ACE
Correct answer : ACE
upvoted 1 times
...
kenn1234
1 year, 12 months ago
ACE same question in MS practice exam
upvoted 2 times
...
Adonor1
3 years ago
ACE is the correct Answer
upvoted 2 times
...
smaa
3 years, 1 month ago
Given answer is correct. A,C and E https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview Section: How do I choose the correct pool size.
upvoted 2 times
...
Chandra111
3 years, 2 months ago
Answer: A, D, E
upvoted 1 times
pozdrotechno
3 years ago
D is not correct. The database sessions are not mentioned anywhere in the documentation for elastic pool cost-effectiveness calculations. Each database counts as one. The number of sessions within the databases doesn't matter.
upvoted 2 times
...
...
Mladen_66
3 years, 6 months ago
ACE for the vCore - https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview
upvoted 4 times
...
learnazureportal
3 years, 7 months ago
The Correct Answer is A, D & E.
upvoted 1 times
learnazureportal
3 years, 4 months ago
I meant A,C.E
upvoted 3 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago