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: C
Get Premium AZ-305 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
13 comments · newest first
EM
Emelda
11 months ago
Wait, can you really ensure no data loss with just Standard? That seems risky!
WI
William
11 months ago
Azure SQL Managed Instance could be a good balance for cost and availability.
CL
Claribel
12 months ago
Not so sure about that, isn't it more expensive?
CL
Clarinda
12 months ago
Definitely agree, Premium has the best availability features!
DU
Dustin
1 year ago
I think Azure SQL Database Premium is the way to go for no data loss.
LE
Leoma
1 year ago
I feel like the Standard tier might not meet the no data loss requirement, but I’m not confident about which one to choose.
LE
Leanora
1 year ago
I practiced a similar question, and I think the key is to balance cost with the required availability. Maybe the Managed Instance could work?
SH
Shenika
1 year ago
I’m not entirely sure, but I think Azure SQL Database Premium might be the best choice since it offers better performance and availability features.
TE
Terrilyn
1 year ago
I remember that for high availability with no data loss, we need to consider options that support geo-replication.
WE
Wenona
1 year ago
Hmm, I'm a little unsure about this one. I know in-app billing is used to sell products, but I'm not sure if it's only for paid apps or if free apps can use it too.
CH
Charlene
1 year ago
I feel like the answer is False, but I also remember some discussions about TGWs and their capabilities that made it confusing.
HA
Haydee
1 year ago
Hmm, I'm a little unsure about this one. The roles of HR seem to overlap a bit, and I want to make sure I select the most accurate description. Let me re-read the options carefully.
SU
Sueann
1 year ago
I'm not entirely sure, but changing the partition to pstn_pt sounds familiar. Was that one option in our previous exercises?