MENU
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?
Suggested Answer: D, E
Get Premium AZ-305 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
47 comments · newest first
CH
Chauncey
11 months ago
Not sure if D is the best option, it might be too pricey.
BR
Brett
11 months ago
Wait, I thought Basic was enough for failover?
EL
Elza
11 months ago
A and B could work too, but they might not be as cost-effective.
KR
Kristine
12 months ago
Totally agree, D seems to cover all the requirements!
SH
Shala
12 months ago
I think D is the best choice for no data loss and high availability.
FA
Fabiola
1 year ago
Basic seems too limited for this scenario, but I'm not clear on the differences between Premium and Managed Instance.
DY
Dyan
1 year 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.
JA
Jacinta
1 year ago
I'm not entirely sure, but I remember something about Hyperscale being good for large databases. Does it handle failover well?
JA
Janna
1 year ago
I think we need to ensure no data loss, so maybe the Business Critical option is the best choice?
ME
Melynda
1 year 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.
SA
Sabine
1 year 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.
CA
Carylon
1 year 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.
GE
Gerald
1 year ago
Hmm, this one seems tricky. I'll need to carefully consider the requirements around high availability, data loss, and cost minimization.
TA
Tamesha
1 year 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.
PR
Precious
1 year ago
The keyword is 'aggregate-address'. That's what allows you to advertise just the summary route instead of all the specific routes.
CA
Caren
1 year 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.
TR
Truman
1 year 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.
NO
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!
RO
Roselle
1 year ago
D) Azure SQL Managed Instance Business Critical
RO
Robt
1 year ago
C) Azure SQL Database Basic
RE
Reena
1 year ago
B) Azure SQL Database Hyperscale
DE
Della
1 year ago
A) Azure SQL Database Premium
AS
Ashlyn
2 years 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.
TW
Twana
1 year ago
D) Azure SQL Managed Instance Business Critical
ED
Edward
1 year ago
C) Azure SQL Database Basic
KA
Kami
1 year ago
B) Azure SQL Database Hyperscale
TY
Ty
1 year ago
A) Azure SQL Database Premium
JO
Johana
2 years 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.
CO
Coleen
1 year ago
D) Azure SQL Managed Instance Business Critical
KA
Kallie
1 year ago
C) Azure SQL Database Basic
TE
Tegan
1 year ago
B) Azure SQL Database Hyperscale
KE
Kenneth
1 year ago
A) Azure SQL Database Premium
CL
Clorinda
2 years 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.
ED
Edelmira
2 years ago
But wouldn't Azure SQL Managed Instance Business Critical be a better option for zone outage resilience?
CA
Carey
2 years 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.
BE
Bernadine
1 year ago
D) Azure SQL Managed Instance Business Critical
PA
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.
CA
Cary
1 year ago
D) Azure SQL Managed Instance Business Critical
HA
Hailey
1 year ago
C) Azure SQL Database Basic
JI
Jillian
1 year ago
C) Azure SQL Database Basic
AL
Alverta
1 year ago
B) Azure SQL Database Hyperscale
AD
Adrianna
1 year ago
B) Azure SQL Database Hyperscale
JA
Jamal
1 year ago
A) Azure SQL Database Premium
ER
Ernie
1 year ago
A) Azure SQL Database Premium
CO
Cory
2 years ago
I agree with Izetta, Azure SQL Database Premium offers failover without data loss.
HE
Helga
2 years 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.
IZ
Izetta
2 years ago
I think we should go with Azure SQL Database Premium for high availability.