AZ-305 · Question #32
You are designing a SQL database solution. The solution will include 20 databases that will be 20 GB each and have varying usage patterns. You need to recommend a database platform to host the…
The correct answer is A. an elastic pool that contains 20 Azure SQL databases. The compute and storage redundancy is built in for business critical databases and elastic pools, with a SLA of 99.99%. Reserved capacity provides you with the flexibility to temporarily move your hot databases in and out of elastic pools (within the same region and performance…
Question
Options
- Aan elastic pool that contains 20 Azure SQL databases
- B20 databases on a Microsoft SQL server that runs on an Azure virtual machine in an availability
- C20 databases on a Microsoft SQL server that runs on an Azure virtual machine
- D20 instances of Azure SQL Database serverless
How the community answered
(35 responses)- A49% (17)
- B29% (10)
- C14% (5)
- D9% (3)
Explanation
The compute and storage redundancy is built in for business critical databases and elastic pools, with a SLA of 99.99%. Reserved capacity provides you with the flexibility to temporarily move your hot databases in and out of elastic pools (within the same region and performance tier) as part of your normal operations without losing the reserved capacity benefit. https://azure.microsoft.com/en-us/blog/understanding-and-leveraging-azure-sql-database-sla/
Community Discussion
No community discussion yet for this question.