70-473 · Question #56
You need to recommend a database strategy to support the planned new customers. The solution must minimize costs. What should you recommend?
The correct answer is C. 30 Basic databases. To minimize costs for 30 new customers, recommending 30 individual Basic Azure SQL Databases is the most cost-effective solution.
Question
Options
- Aa Basic database pool that has at least 1,200 eDTUs
- Ba Premium database pool that has at least 1,000 eDTUs
- C30 Basic databases
- D30 Premium P14 databases
How the community answered
(52 responses)- A10% (5)
- B4% (2)
- C85% (44)
- D2% (1)
Why each option
To minimize costs for 30 new customers, recommending 30 individual Basic Azure SQL Databases is the most cost-effective solution.
A Basic database pool with 1,200 eDTUs would be significantly more expensive than 30 individual Basic databases, as each Basic database typically uses 5 DTUs, totaling only 150 DTUs.
A Premium database pool is considerably more expensive than a Basic pool or individual Basic databases, making it unsuitable for minimizing costs.
The Basic service tier in Azure SQL Database offers the lowest cost per database and is suitable for new customers with low, predictable transaction volumes, making 30 individual Basic databases the most economical choice.
30 Premium P14 databases are designed for very high-performance workloads and are extremely expensive, directly contradicting the goal of minimizing costs.
Concept tested: Azure SQL Database service tiers, cost optimization
Source: https://learn.microsoft.com/en-us/azure/azure-sql/database/service-tiers-dtu
Topics
Community Discussion
No community discussion yet for this question.