Exam AZ-305 topic 4 question 51 discussion

Managed Instance + Auto Failover Group

Azure SQL Managed instances & Auto Failover Group - supports User Initiated Backups and minimizes administrative effort for business continuity. https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview?view=azuresql - Auto failover groups https://docs.microsoft.com/en-us/azure/architecture/framework/services/data/azure-sql-managed-instance/reliability

The best solution for migrating your on-premises SQL Server databases to Azure while ensuring backup support, automatic replication across regions, and minimal administrative effort is: Recommended: Azure SQL Managed Instance with Geo-Replication Why Azure SQL Managed Instance? User-Initiated Backups – Supports manual backup operations alongside automated Azure backups. Built-in Geo-Replication – Active Geo-Replication allows multiple secondary replicas across Azure regions for high availability. Minimized Administrative Overhead – Fully managed PaaS solution that automates patching, scaling, and failover. Alternative: Azure SQL Database with Failover Groups If your system can operate without full SQL Server compatibility, Failover Groups can replicate databases across regions with automatic failover. Best for cost-optimized disaster recovery but lacks some SQL Server features. Would you like guidance on configuring geo-replication policies or cost analysis for Managed Instance vs. SQL Database?

WRONG 1. Azure SQL Managed Instance 2. Auto-failover group

Really think it is MI. Microsoft's user initiated backup is a workaround and does not work in all Azure SQL scenarios...https://learn.microsoft.com/en-us/answers/questions/1367837/how-to-initiate-an-on-demand-backup-of-an-azure-ms

Deployment solution: Azure SQL Managed Instance Resiliency solution: Auto-failover group

Based on the below info i would choose MI and Failover-Group Active Geo-Replication: *Configuration: Active Geo-Replication is set up per database and supports manual failover. It allows you to create readable secondary databases in a different Azure region. *Use Case: It’s designed as a business continuity solution, providing a way to maintain a copy of your primary database for disaster recovery purposes. *Number of Secondaries: You can have up to four secondaries for a single primary database. *Applicability: Active Geo-Replication is specific to Azure SQL Database. *Failover: Manual failover is initiated by the user.

If priority is minimal administrative effort and the ability to automate replication across regions with built-in failover, then Azure SQL Database single database with auto-failover group is the way to go.

Final Answer: - Azure SQL Database with Single SQL Database - Active geo replication

My answer is Single SQL Database Active geo MI neither supports manual backup nor multi region

SQL Managed instance supports "copy-only" backups if initiated by users in other words it is not really a backup then. Hence SQL Managed instance is ruled out. Azure SQL DB single DB supports multiple replicas across multiple regions. Hence given answers are correct.

I think it should be Azure SQL managed instance and Auto failover group. Since user initiated backups are supported only in SQL managed instances... https://learn.microsoft.com/en-us/azure/azure-sql/database/features-comparison?view=azuresql

Managed Instance + Auto Failover Group refer the link below https://www.examtopics.com/discussions/microsoft/view/75025-exam-dp-300-topic-6-question-17-discussion/

keyword is "Supports multiple automatically replicated instances" also supports user initiated backups, the only option would be managed instance. Second answer is auto-failover as managed instances don't support active geo replication.

I guess the key here is "support multiple".... given answer is correct

Deployment Solution: c. Azure SQL Database Single Database Azure SQL Database Single Database supports user-initiated backups and minimizes administrative effort as it is a fully managed platform as a service (PaaS) database engine. Resiliency Solution: b. Active Geo-Replication Active Geo-Replication supports multiple automatically replicated instances across Azure regions and provides a business continuity solution with minimal administrative effort. It allows for up to four readable secondary databases in the same or different data center locations (regions).

The recommended deployment solution is Azure SQL Managed Instance and the recommended resiliency solution is Auto-failover groups. This combination supports user-initiated backups, multiple automatically replicated instances across Azure regions, and minimizes administrative effort to implement and maintain business continuity.