Exam AZ-305 topic 4 question 67 discussion

Premium should be the answer. Whenever zone-redundancy (availability within the same region) is required you can only choose: -General Purpose -Premium -Business Critical See: https://learn.microsoft.com/en-GB/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell

Actually About 23 questions added today..

Correct answer is "Azure SQL Database Premium". Basic and Standard do not support zone-redundancy: https://learn.microsoft.com/en-GB/azure/azure-sql/database/high-availability-sla

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.

B. Azure SQL Database Premium

B. Azure SQL Database Premium

Premium for failover without data loss.

Azure SQL Database Premium tier supports multiple redundant replicas for each database that are automatically provisioned in the same datacenter within a region. This design leverages the SQL Server AlwaysON technology and provides resilience to server failures with 99.99% availability SLA and RPO=0. With the introduction of Azure Availability Zones, we are happy to announce that SQL Database now offers built-in support of Availability Zones in its Premium service tier. https://azure.microsoft.com/en-us/blog/azure-sql-database-now-offers-zone-redundant-premium-databases-and-elastic-pools/ Zone-redundant configuration is not available in SQL Managed Instance. In SQL Database this feature is only available when the Gen5 hardware is selected. https://docs.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell

The deployment option that should be used to meet the requirements of a highly available Azure SQL database with minimal data loss and minimal cost is option D, Azure SQL Database Standard. This option provides active-passive failover capabilities and also allows for read-access to secondary replicas, which can help minimize costs. Additionally, it also provides zone-redundant databases, so in case of zone outage, the database will remain available

Azure SQL database standard as we have to minimize costs: https://azure.microsoft.com/en-us/blog/azure-sql-database-standard-geo-replication/

seems correct.

This question was added today 05Jan2023. Serves as update confirmation ..