DP-300 · Question #35
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…
The correct answer is A. total size of all the databases C. number of concurrently peaking databases * peak CPU utilization per database E. total number of databases * average CPU utilization per database. 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…
Question
Options
- 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
How the community answered
(24 responses)- A67% (16)
- B21% (5)
- D13% (3)
Explanation
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
Community Discussion
No community discussion yet for this question.