You need to recommend a high-availability solution in Microsoft Azure that meets the following requirements: - Must host a distribution database. - Must be stored in the East US region. - Must be available if a single node fails. - Must be able to replicate data to Microsoft SQL Servers. What should you include in the recommendation?

Question

Accepted Answer

A. an Always On availability group Always On availability groups provide high availability and disaster recovery for one or more user databases, including distribution databases essential for SQL Server replication. They ensure automatic failover of the database group to another replica if the primary node fails, maintaining data replication capabilities.

Answer

B. a database mirror Database mirroring is a deprecated feature for high availability and does not offer the advanced capabilities or support for distribution databases in a modern HA setup like Always On availability groups.

Answer

C. Always On Failover Clustering Always On Failover Cluster Instances provide instance-level high availability by failing over the entire SQL Server instance, but they require shared storage and are not as granular as availability groups for database-specific replication needs.

Answer

D. Active SQL Data Sync Active SQL Data Sync is a data synchronization service for Azure SQL Database instances and is not a high-availability solution for SQL Server on Azure virtual machines.

You need to recommend a high-availability solution in Microsoft Azure that meets the following requirements: - Must host a distribution database. - Must be stored in the East US region. - Must be…

Question

Options

How the community answered

Why each option

Topics

Community Discussion