Question
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 Correct
- B. geo-replication support
- C. number of concurrently peaking databases * peak CPU utilization per database Correct
- D. maximum number of concurrent sessions for all the databases
- E. total number of databases * average CPU utilization per database Correct
Explanation
Pool compute in the vCore model is estimated as the larger of two values: total number of databases multiplied by average vCore utilization per database, and number of concurrently peaking databases multiplied by peak vCore utilization per database. Pool storage is estimated by adding the data size needed for all the databases in the pool. Geo-replication support is a business continuity feature rather than a sizing input, and the maximum number of concurrent sessions is not part of the sizing calculation.
