You ate designing a SQL database solution.

Microsoft AZ-305 Question Answer

You ate 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 databases. The solution must meet the following requirements:

• The compute resources allocated to the databases must scale dynamically.

• The solution must meet an SLA of 99.99% uptime.

• The solution must have reserved capacity.

• Compute charges must be minimized.

What should you include in the recommendation?

20 databases on a Microsoft SQL server that runs on an Azure virtual machine

20 instances of Azure SQL Database serverless

20 databases on a Microsoft SQL server that runs on an Azure virtual machine in an availability set

an elastic pool that contains 20 Azure SQL databases