A SaaS company hosts 500 separate Azure SQL Databases for its customers. The databases have unpredictable usage patterns; some are idle while others spike randomly. The company wants to optimize costs while ensuring performance during spikes. Which deployment option should you recommend?

Answer options:

Azure SQL Database Serverless.

Azure SQL Database Elastic Pool.

Azure SQL Managed Instance.

Azure SQL Database Hyperscale.

How to approach this question

Identify the SQL deployment model designed for sharing resources across multiple databases.

Full Answer

B.Azure SQL Database Elastic Pool.✓ Correct

Azure SQL Database Elastic Pool.

Elastic Pools provide a simple and cost-effective solution for managing and scaling multiple databases that have varying and unpredictable usage demands by sharing a set amount of resources.

Common mistakes

Choosing Serverless, which is optimized for single databases rather than a fleet of 500.

Question 15 All questions Question 17

Practice the full Azure Solutions Architect Expert AZ-305 Practice Exam 6

55 questions · hints · full answers · grading

More questions from this exam

Q01Contoso Ltd is a global manufacturing company with 50,000 employees. They operate a mix of on-pre...Medium Q02A financial institution has 500 Windows Server VMs on-premises and 200 VMs in Azure. They need to...Hard Q03An enterprise uses Azure Sentinel and Log Analytics. They ingest 500 GB of logs daily. The IT bud...Hard Q04You are designing a monitoring strategy for a new Azure deployment consisting of App Service, Azu...Easy Q05A healthcare company uses Microsoft Entra ID (Azure AD). They need to implement a security policy...Medium

View all 55 questions →