Exam AZ-305 topic 2 question 7 discussion

Correct answer - A Databases vary in usage so an elastic pool would fit best.

A is correct. Elastic pool is needed for SLA 99,95 % and auto scale.

Scaling multiple databases with varying and unpredictable usage demands:- Azure SQL Database elastic pools

A is correct

I'm pretty sure this was on the test I just took. November 2024.

A. An elastic pool that contains 20 Azure SQL databases Reasons: SLA of 99.99% uptime: Azure SQL Database offers a high availability SLA of 99.99%. Dynamic Scaling: Elastic pools dynamically allocate compute resources across the databases based on demand, which helps in managing varying usage patterns. Reserved Capacity: Elastic pools support reserved capacity, which can help reduce costs. Minimized Compute Charges: By pooling resources, elastic pools optimize the overall cost, making compute charges more efficient compared to other options. Reference: https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview?view=azuresql

in the Exam April 2024

it was a exam Question

Elastic pool is the best fit solution based on the requirements.

Correct Answer - A: Elastic Pool containing 20 Azure SQL databases - The primary consideration in the scenario is the presence of 20 databases, each 20 GB, with varying usage patterns. There's a need to ensure 99.99% uptime, dynamic scalability of compute resources, and reserved capacity, while also minimizing compute charges. - Elastic Pool with Azure SQL databases: Elastic pools in Azure are specifically designed to manage multiple databases with varying loads. They allow these databases to share resources in a cost-effective manner, guaranteeing dynamic scalability and a high SLA of 99.99% uptime. This aligns with the question requirements. https://docs.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview

The answer is correct. I had this question in my exam today, I passed with 979.

A. an elastic pool that contains 20 Azure SQL databases Elastic pools in Azure SQL Database are designed to handle multiple databases with varying usage patterns within a shared resource pool. This option meets the following requirements: SLA of 99.99% uptime: Azure SQL Database provides an SLA of 99.99% uptime, ensuring high availability for your databases. Dynamic scaling of compute resources: Elastic pools allow you to allocate resources dynamically, adjusting to the varying usage patterns of your databases. Reserved capacity: Elastic pools enable you to reserve capacity for multiple databases within the pool, ensuring resources are available when needed. Minimize compute charges: By sharing resources among the databases within the elastic pool, you can minimize compute charges while still meeting the performance requirements.

A is the answer. https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview?view=azuresql 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 SQL Database enable software as a service (SaaS) developers to optimize the price performance for a group of databases within a prescribed budget while delivering performance elasticity for each database.

Correct Answer:A C-Not correct because; If you want access your database OS level. You can use this option.It main way. D-Not correct because; Microsoft quotation; Serverless option. Use the serverless compute tier for a single SQL database. You're billed only for the amount of compute used.

A. an elastic pool that contains 20 Azure SQL databases Thanks to all who have mentioned the exam dates

Different usage patterns across dbs is the key thing here

shown on 1/14/23