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

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

Contribute your Thoughts:

0/2000 characters
Emelda
4 months ago
Wait, can you really ensure no data loss with just Standard? That seems risky!
upvoted 0 times
...
William
5 months ago
Azure SQL Managed Instance could be a good balance for cost and availability.
upvoted 0 times
...
Claribel
5 months ago
Not so sure about that, isn't it more expensive?
upvoted 0 times
...
Clarinda
5 months ago
Definitely agree, Premium has the best availability features!
upvoted 0 times
...
Dustin
5 months ago
I think Azure SQL Database Premium is the way to go for no data loss.
upvoted 0 times
...
Leoma
5 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
5 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
5 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
5 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
6 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
6 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
6 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
6 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