BenchMark Quizzes by MDFT Pro

Select Metrics To Size An Elastic Pool

You work for MDFT Pro, a well-known training agency that operates multiple Azure SQL databases for their learning management platform. Mark, the Chief Data Officer, has assigned you to optimize the database infrastructure.

Currently, MDFT Pro has 20 Azure SQL databases provisioned using the vCore purchasing model, which store course content, student records, trainer information, and assessment data. To improve resource utilization and reduce costs, Mark wants to consolidate these databases into an Azure SQL Database elastic pool that can handle the varying workload patterns across all databases.

Which three metrics should you use to size the elastic pool to meet the demands of the workload?

Choose all correct answers from the options below.

Explanations for each answer:

Total size of all the databases is correct. This metric is essential for sizing an elastic pool as it determines the storage requirements needed to accommodate all databases.
Geo-replication support is incorrect. Geo-replication support is a feature consideration, not a metric used to size the elastic pool based on workload demands.
Number of concurrently peaking databases * peak CPU utilization per database is correct. This metric helps determine the peak CPU capacity needed by identifying how many databases peak simultaneously and their peak CPU usage.
Maximum number of concurrent sessions for all the databases is incorrect. While session count is important for monitoring, it's not one of the primary metrics for sizing an elastic pool based on workload demands.
Total number of databases * average CPU utilization per database is correct. This metric provides insight into the overall CPU capacity needed by considering the average usage across all databases.

Learn more about Azure SQL Database Elastic Pools:

Azure SQL Database Elastic Pools

Practice Exam

Select Metrics To Size An Elastic Pool

Discuss this question on social media: