Implementing Azure SQL Database Elastic Pool for Cost Optimization | Exam DP-200 Question Answer

Minimize Cost with Azure SQL Database Elastic Pool | DP-200 Exam Answer

Question

A company has a SaaS solution that uses Azure SQL Database with elastic pools. The solution contains a dedicated database for each customer organization.

Customer organizations have peak usage at different periods during the year.

You need to implement the Azure SQL Database elastic pool to minimize cost.

Which option or options should you configure?

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D. E.

E

The best size for a pool depends on the aggregate resources needed for all databases in the pool. This involves determining the following:

-> Maximum resources utilized by all databases in the pool (either maximum DTUs or maximum vCores depending on your choice of resourcing model).

-> Maximum storage bytes utilized by all databases in the pool.

Note: Elastic pools enable the developer to purchase resources for a pool shared by multiple databases to accommodate unpredictable periods of usage by individual databases. You can configure resources for the pool based either on the DTU-based purchasing model or the vCore-based purchasing model.

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-pool

To minimize cost for a SaaS solution that uses Azure SQL Database with elastic pools, you need to configure the elastic pool based on the peak usage of customer organizations. Since each customer organization has peak usage at different periods during the year, you need to ensure that the elastic pool is flexible enough to handle the peak usage without overprovisioning and incurring unnecessary costs.

Out of the options provided, the most appropriate ones to configure are:

B. eDTUs per database only C. Number of databases only E. eDTUs and max data size

Option A, number of transactions only, is not a recommended option as it does not provide sufficient information about the performance requirements of the system. The number of transactions does not necessarily correspond to the resource usage of the system.

Option D, CPU usage only, is also not a recommended option as it does not take into account the other resource requirements of the system, such as storage and memory. The CPU usage may not accurately reflect the overall resource usage of the system.

Option B, eDTUs per database only, is a recommended option as it allows you to allocate a specific amount of resources to each database based on their individual requirements. This option enables you to scale up or down each database as needed, without affecting the performance of other databases in the same pool.

Option C, number of databases only, is also a recommended option as it allows you to set a limit on the number of databases that can be created in the elastic pool. This option helps to prevent overprovisioning of resources and ensures that the elastic pool can handle the peak usage of customer organizations.

Option E, eDTUs and max data size, is also a recommended option as it allows you to set a limit on the amount of data that can be stored in each database in the elastic pool. This option helps to prevent overprovisioning of resources and ensures that the elastic pool can handle the peak usage of customer organizations.

In conclusion, the recommended options to configure for the Azure SQL Database elastic pool to minimize cost are eDTUs per database, number of databases, and optionally eDTUs and max data size.