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

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
4 months ago
Not sure if D is the best option, it might be too pricey.
upvoted 0 times
...
Brett
4 months ago
Wait, I thought Basic was enough for failover?
upvoted 0 times
...
Elza
4 months ago
A and B could work too, but they might not be as cost-effective.
upvoted 0 times
...
Kristine
4 months ago
Totally agree, D seems to cover all the requirements!
upvoted 0 times
...
Shala
4 months ago
I think D is the best choice for no data loss and high availability.
upvoted 0 times
...
Fabiola
5 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
5 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
5 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
5 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
5 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
5 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
5 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
5 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
5 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
5 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
5 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
6 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
10 months 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
9 months ago
D) Azure SQL Managed Instance Business Critical
upvoted 0 times
...
Robt
9 months ago
C) Azure SQL Database Basic
upvoted 0 times
...
Reena
9 months ago
B) Azure SQL Database Hyperscale
upvoted 0 times
...
Della
10 months ago
A) Azure SQL Database Premium
upvoted 0 times
...
...
Ashlyn
11 months 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
9 months ago
D) Azure SQL Managed Instance Business Critical
upvoted 0 times
...
Edward
9 months ago
C) Azure SQL Database Basic
upvoted 0 times
...
Kami
10 months ago
B) Azure SQL Database Hyperscale
upvoted 0 times
...
Ty
10 months ago
A) Azure SQL Database Premium
upvoted 0 times
...
...
Johana
11 months 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
9 months ago
D) Azure SQL Managed Instance Business Critical
upvoted 0 times
...
Kallie
9 months ago
C) Azure SQL Database Basic
upvoted 0 times
...
Tegan
9 months ago
B) Azure SQL Database Hyperscale
upvoted 0 times
...
Kenneth
10 months ago
A) Azure SQL Database Premium
upvoted 0 times
...
...
Clorinda
11 months 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
11 months ago
But wouldn't Azure SQL Managed Instance Business Critical be a better option for zone outage resilience?
upvoted 0 times
...
Carey
11 months 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
10 months ago
D) Azure SQL Managed Instance Business Critical
upvoted 0 times
...
Paris
10 months 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
10 months ago
D) Azure SQL Managed Instance Business Critical
upvoted 0 times
...
Hailey
10 months ago
C) Azure SQL Database Basic
upvoted 0 times
...
Jillian
10 months ago
C) Azure SQL Database Basic
upvoted 0 times
...
Alverta
10 months ago
B) Azure SQL Database Hyperscale
upvoted 0 times
...
Adrianna
10 months ago
B) Azure SQL Database Hyperscale
upvoted 0 times
...
Jamal
10 months ago
A) Azure SQL Database Premium
upvoted 0 times
...
Ernie
10 months ago
A) Azure SQL Database Premium
upvoted 0 times
...
...
Cory
11 months ago
I agree with Izetta, Azure SQL Database Premium offers failover without data loss.
upvoted 0 times
...
Helga
11 months 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
11 months ago
I think we should go with Azure SQL Database Premium for high availability.
upvoted 0 times
...

Save Cancel