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 2 Question 29 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 minimizedWhich deployment option should you use?
C) Azure SQL Managed Instance General Purpose
A) Azure SQL Database Standard
B) Azure SQL Database Serverless
D) Azure SQL Database Premium

Microsoft AZ-305 Exam - Topic 2 Question 29 Discussion

Actual exam question for Microsoft's AZ-305 exam
Question #: 29
Topic #: 2
[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: C

by Teddy at Oct 28, 2022, 12:28 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
Emelda
10 months ago
Wait, can you really ensure no data loss with just Standard? That seems risky!
upvoted 0 times
...
William
10 months ago
Azure SQL Managed Instance could be a good balance for cost and availability.
upvoted 0 times
...
Claribel
10 months ago
Not so sure about that, isn't it more expensive?
upvoted 0 times
...
Clarinda
10 months ago
Definitely agree, Premium has the best availability features!
upvoted 0 times
...
Dustin
10 months ago
I think Azure SQL Database Premium is the way to go for no data loss.
upvoted 0 times
...
Leoma
11 months 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.
upvoted 0 times
...
Leanora
11 months 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?
upvoted 0 times
...
Shenika
11 months 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.
upvoted 0 times
...
Terrilyn
11 months ago
I remember that for high availability with no data loss, we need to consider options that support geo-replication.
upvoted 0 times
...
Wenona
11 months 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.
upvoted 0 times
...
Charlene
11 months ago
I feel like the answer is False, but I also remember some discussions about TGWs and their capabilities that made it confusing.
upvoted 0 times
...
Haydee
11 months 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.
upvoted 0 times
...
Sueann
11 months ago
I'm not entirely sure, but changing the partition to pstn_pt sounds familiar. Was that one option in our previous exercises?
upvoted 0 times
...

Save Cancel