Microsoft Certified Azure Data Engineer Associate · Free Practice Question Medium
Question 21
Scenario: You are a consultant at Avengers Security which has an SaaS solution which uses Azure SQL Database with elastic pools. The solution contains a dedicated database for each customer organization where each organization has peak usage at staggered periods throughout the year.
Required: Implement an Azure SQL Database elastic pool to minimize cost.
Which option or options should you recommend to the Avengers IT team to configure?
-
A
eDTUs per database only
-
B
eDTUs and max data size
-
C
CPU usage only
-
D
Number of databases only
-
E
Number of transactions only
Reveal correct answer
Correct answer: B
Explanation
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.
A. Configuring eDTUs per database alone does not fully optimize cost within an Azure SQL Database elastic pool. While eDTUs per database impact performance, it is essential to also consider other factors such as maximum data size to effectively minimize costs.
B. Configuring eDTUs (elastic Database Transaction Units) allows for adjusting the performance level of the elastic pool based on the workload requirements of each customer organization. Additionally, setting a maximum data size helps in managing storage costs efficiently within the elastic pool.
C. Focusing solely on CPU usage does not address the cost optimization aspect of an Azure SQL Database elastic pool. While CPU usage is a performance metric to consider, it is not the most effective way to minimize costs in this scenario.
D. Configuring the number of databases alone does not directly impact cost optimization within an Azure SQL Database elastic pool. While it is important to consider the number of databases, it is not the sole factor in minimizing costs.
E. Considering the number of transactions alone does not provide a comprehensive cost optimization strategy for an Azure SQL Database elastic pool. While transaction volume is important, it is not the only factor to consider in minimizing costs.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
