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…

Question

Options

• A20 databases on a Microsoft SQL server that runs on an Azure virtual machine
• B20 instances of Azure SQL Database serverless
• C20 databases on a Microsoft SQL server that runs on an Azure virtual machine in an availability
• Dan elastic pool that contains 20 Azure SQL databases

• A
  9% (2)
• B
  4% (1)
• C
  4% (1)
• D
  83% (19)

Explanation

Azure SQL Database elastic pools are a simple, cost-effective solution for managing and scaling multiple databases that have varying and unpredictable usage demands. The databases in an elastic pool are on a single server and share a set number of resources at a set price. Elastic pools in Azure SQL Database enable SaaS developers to optimize the price performance for a group of databases within a prescribed budget while delivering performance elasticity for each Guaranteed 99.995 percent uptime for SQL Database https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview https://azure.microsoft.com/en-us/pricing/details/sql-database/elastic/

No community discussion yet for this question.