Exam AZ-305 topic 3 question 14 discussion

duplicate with Quesion 13. The given answer is correct

Appeared in todays exam (29/01/23) But Premium was not in choices had Business Critical instead for Azure SQL and Azure MI I answered Azure MI Business Critical assuming Failover meant Auto-Failover groups Scored 903

You can activate geo-replication on another zone even with basic tier. So I guess is basic. Maybe in the post was different

Duplicate question but this time the suggested answer is correct. B.

why some ppl say this question is duplicated with question 13?? question 13 correct solution is D: Azure SQL Managed Instance General Purpose, which is not existed in this question 14.

Duplicate to previous question. The answer is "Azure SQL Database Premium".

duplicate, B is correct fo sho

this is duplicate with right answer

Same as Question 16. https://www.examtopics.com/discussions/microsoft/view/79423-exam-az-305-topic-2-question-16-discussion

B is the answer. https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview?view=azuresql#service-tiers The Premium service tier is designed for OLTP applications with high transaction rates and low latency I/O requirements. It offers the highest resilience to failures by using several isolated replicas.

The best option would be to use Azure SQL Database Premium as it provides failover between replicas of the database with no data loss and also supports zone redundancy to ensure availability in the event of a zone outage. Additionally, Azure SQL Database Premium is more cost-effective compared to the higher-tier options such as Azure SQL Managed Instance Business Critical. If Premium isn't given option in exam then A

B. Azure SQL Database Premium

https://docs.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell Zone-redundant configuration is not available in SQL Managed Instance. In SQL Database this feature is only available when the Gen5 hardware is selected. To prevent Data Loss, Premium/Business Critical is required: The primary node constantly pushes changes to the secondary nodes in order and ensures that the data is persisted to at least one secondary replica before committing each transaction. This process guarantees that if the primary node crashes for any reason, there is always a fully synchronized node to fail over to

The B is the correct.