Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft AZ-305 Exam - Topic 10 Question 51 Discussion

You need to design a highly available Azure SQL database that meets the following requirements:* Failover between replicas of the database must occur without any data loss.* The database must remain available in the event of a zone outage.* Costs must be minimized.Which deployment option should you use?
D) Azure SQL Managed Instance Business Critical
A) Azure SQL Database Premium
B) Azure SQL Database Hyperscale
C) Azure SQL Database Basic

Microsoft AZ-305 Exam - Topic 10 Question 51 Discussion

Actual exam question for Microsoft's AZ-305 exam
Question #: 51
Topic #: 10
[All AZ-305 Questions]

You need to design a highly available Azure SQL database that meets the following requirements:

* Failover between replicas of the database must occur without any data loss.

* The database must remain available in the event of a zone outage.

* Costs must be minimized.

Which deployment option should you use?

Show Suggested Answer Hide Answer
Suggested Answer: D, E

by Christiane at Mar 09, 2024, 02:21 PM

Limited Time Offer

25%

Off

Get Premium AZ-305 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Chauncey
8 months ago
Not sure if D is the best option, it might be too pricey.
upvoted 0 times
...
Brett
8 months ago
Wait, I thought Basic was enough for failover?
upvoted 0 times
...
Elza
8 months ago
A and B could work too, but they might not be as cost-effective.
upvoted 0 times
...
Kristine
8 months ago
Totally agree, D seems to cover all the requirements!
upvoted 0 times
...
Shala
9 months ago
I think D is the best choice for no data loss and high availability.
upvoted 0 times
...
Fabiola
9 months ago
Basic seems too limited for this scenario, but I'm not clear on the differences between Premium and Managed Instance.
upvoted 0 times
...
Dyan
9 months ago
I practiced a similar question, and I feel like Premium might be a good balance, but I'm not confident about the zone outage requirement.
upvoted 0 times
...
Jacinta
9 months ago
I'm not entirely sure, but I remember something about Hyperscale being good for large databases. Does it handle failover well?
upvoted 0 times
...
Janna
9 months ago
I think we need to ensure no data loss, so maybe the Business Critical option is the best choice?
upvoted 0 times
...
Melynda
9 months ago
Hmm, this is a tricky one. I'm leaning towards the Hyperscale option, as it seems to offer the best combination of high availability and cost-effectiveness. But I'll need to double-check the specifics to be sure.
upvoted 0 times
...
Sabine
9 months ago
Based on the details provided, I think Azure SQL Managed Instance Business Critical would be the most appropriate choice. It meets the high availability and data loss requirements while potentially being more cost-effective than the Premium option.
upvoted 0 times
...
Carylon
9 months ago
Okay, let's see. The question is asking for a highly available Azure SQL database, so I'm thinking the Hyperscale option might be the way to go.
upvoted 0 times
...
Gerald
9 months ago
Hmm, this one seems tricky. I'll need to carefully consider the requirements around high availability, data loss, and cost minimization.
upvoted 0 times
...
Tamesha
10 months ago
I'm a bit confused here. The requirements mention failover between replicas without data loss, but also mention minimizing costs. Not sure if Premium or Hyperscale is the best fit.
upvoted 0 times
...
Precious
10 months ago
The keyword is 'aggregate-address'. That's what allows you to advertise just the summary route instead of all the specific routes.
upvoted 0 times
...
Caren
10 months ago
I'm pretty confident I know this one - TOGAF defines a view as a representation of a system from the perspective of a related set of concerns.
upvoted 0 times
...
Truman
10 months ago
Okay, let's see. The options cover things like freeing up RAN capacity, lowering costs, and coverage. I think I know which one is not an advantage, but I want to double-check my reasoning.
upvoted 0 times
...
Novella
1 year ago
I wonder if the Azure SQL Database 'Hyperbole' tier promises 99.999999999% availability and can withstand a direct hit from a nuclear warhead. Sign me up!
upvoted 0 times
Roselle
1 year ago
D) Azure SQL Managed Instance Business Critical
upvoted 0 times
...
Robt
1 year ago
C) Azure SQL Database Basic
upvoted 0 times
...
Reena
1 year ago
B) Azure SQL Database Hyperscale
upvoted 0 times
...
Della
1 year ago
A) Azure SQL Database Premium
upvoted 0 times
...
...
Ashlyn
1 year ago
Wait, there's an 'Azure SQL Database Meme-scale' tier? I hear that one comes with built-in dad jokes and a guarantee of at least one Monty Python reference per query.
upvoted 0 times
Twana
1 year ago
D) Azure SQL Managed Instance Business Critical
upvoted 0 times
...
Edward
1 year ago
C) Azure SQL Database Basic
upvoted 0 times
...
Kami
1 year ago
B) Azure SQL Database Hyperscale
upvoted 0 times
...
Ty
1 year ago
A) Azure SQL Database Premium
upvoted 0 times
...
...
Johana
1 year ago
I'm not sure, but I heard that Azure SQL Database Basic is the most affordable option. Maybe it's worth considering if they're really looking to minimize costs.
upvoted 0 times
Coleen
1 year ago
D) Azure SQL Managed Instance Business Critical
upvoted 0 times
...
Kallie
1 year ago
C) Azure SQL Database Basic
upvoted 0 times
...
Tegan
1 year ago
B) Azure SQL Database Hyperscale
upvoted 0 times
...
Kenneth
1 year ago
A) Azure SQL Database Premium
upvoted 0 times
...
...
Clorinda
1 year ago
This is a tough one, but I think Azure SQL Database Premium is the way to go. The premium tier ensures zero data loss during failover, which is critical for this use case.
upvoted 0 times
...
Edelmira
1 year ago
But wouldn't Azure SQL Managed Instance Business Critical be a better option for zone outage resilience?
upvoted 0 times
...
Carey
1 year ago
I'm leaning towards Azure SQL Managed Instance Business Critical. The business-critical tier provides the necessary failover and availability features, and it might be a more cost-effective solution than the premium tier.
upvoted 0 times
Bernadine
1 year ago
D) Azure SQL Managed Instance Business Critical
upvoted 0 times
...
Paris
1 year ago
I agree, Azure SQL Managed Instance Business Critical seems like the best option for meeting all the requirements while keeping costs low.
upvoted 0 times
...
Cary
1 year ago
D) Azure SQL Managed Instance Business Critical
upvoted 0 times
...
Hailey
1 year ago
C) Azure SQL Database Basic
upvoted 0 times
...
Jillian
1 year ago
C) Azure SQL Database Basic
upvoted 0 times
...
Alverta
1 year ago
B) Azure SQL Database Hyperscale
upvoted 0 times
...
Adrianna
1 year ago
B) Azure SQL Database Hyperscale
upvoted 0 times
...
Jamal
1 year ago
A) Azure SQL Database Premium
upvoted 0 times
...
Ernie
1 year ago
A) Azure SQL Database Premium
upvoted 0 times
...
...
Cory
1 year ago
I agree with Izetta, Azure SQL Database Premium offers failover without data loss.
upvoted 0 times
...
Helga
1 year ago
Azure SQL Database Hyperscale seems like the perfect choice here. It offers high availability, zone-redundancy, and cost-optimization - exactly what the requirements call for.
upvoted 0 times
...
Izetta
1 year ago
I think we should go with Azure SQL Database Premium for high availability.
upvoted 0 times
...

Save Cancel