Microsoft Exam DP-300 Topic 10 Question 24 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 24
Topic #: 10

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.

Atotal size of all the databases

Bgeo-replication support

Cnumber of concurrently peaking databases * peak CPU utilization per database

Dmaximum number of concurrent sessions for all the databases

Etotal number of databases * average CPU utilization per database

Show Suggested 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:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!