exam questions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

Exam AZ-305 topic 2 question 7 discussion

Actual exam question from Microsoft's AZ-305
Question #: 7
Topic #: 2
[All AZ-305 Questions]

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 databases. The solution must meet the following requirements:
✑ The solution must meet a Service Level Agreement (SLA) of 99.99% uptime.
✑ The compute resources allocated to the databases must scale dynamically.
✑ The solution must have reserved capacity.
Compute charges must be minimized.

What should you include in the recommendation?

  • A. an elastic pool that contains 20 Azure SQL databases
  • B. 20 databases on a Microsoft SQL server that runs on an Azure virtual machine in an availability set
  • C. 20 databases on a Microsoft SQL server that runs on an Azure virtual machine
  • D. 20 instances of Azure SQL Database serverless
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Eltooth
Highly Voted 2 years, 11 months ago
Selected Answer: A
Correct answer - A Databases vary in usage so an elastic pool would fit best.
upvoted 22 times
...
[Removed]
Highly Voted 2 years, 11 months ago
Selected Answer: A
A is correct. Elastic pool is needed for SLA 99,95 % and auto scale.
upvoted 12 times
...
Thanveer
Most Recent 1 week, 5 days ago
Scaling multiple databases with varying and unpredictable usage demands:- Azure SQL Database elastic pools
upvoted 1 times
...
SeMo0o0o0o
3 weeks, 1 day ago
Selected Answer: A
A is correct
upvoted 2 times
...
frostgiant
3 weeks, 3 days ago
I'm pretty sure this was on the test I just took. November 2024.
upvoted 1 times
...
23169fd
5 months, 2 weeks ago
Selected Answer: A
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
upvoted 2 times
...
MHguy
7 months, 1 week ago
in the Exam April 2024
upvoted 2 times
...
babakeyfgir
1 year ago
it was a exam Question
upvoted 7 times
...
ArunS005
1 year, 2 months ago
Selected Answer: A
Elastic pool is the best fit solution based on the requirements.
upvoted 1 times
...
stonwall12
1 year, 2 months ago
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
upvoted 4 times
...
techrat
1 year, 7 months ago
Selected Answer: A
The answer is correct. I had this question in my exam today, I passed with 979.
upvoted 6 times
...
NotMeAnyWay
1 year, 8 months ago
Selected Answer: A
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.
upvoted 10 times
...
zellck
1 year, 9 months ago
Selected Answer: A
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.
upvoted 7 times
...
omerco61
1 year, 9 months ago
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.
upvoted 2 times
...
OPT_001122
1 year, 10 months ago
Selected Answer: A
A. an elastic pool that contains 20 Azure SQL databases Thanks to all who have mentioned the exam dates
upvoted 2 times
...
Bummer_boy
1 year, 10 months ago
Selected Answer: A
Different usage patterns across dbs is the key thing here
upvoted 1 times
...
Q12346
1 year, 10 months ago
shown on 1/14/23
upvoted 6 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...