Configure HA/DR for Database Solutions DP-300 Practice Questions (Page 5)

Questions 21–25

1. 21application · medium

   You have a SQL Server 2016 instance on an Azure VM that hosts a legacy application. The application does not support Always On availability groups. You need to provide disaster recovery to a secondary VM in a different Azure region with minimal administrative overhead and allow the secondary to be used for reporting. What should you configure?

   • AConfigure Azure SQL Database geo-replication and point the application to the secondary.
   • BConfigure an Always On availability group with the secondary as a readable replica.
   • CConfigure an Always On failover cluster instance across regions.
   • DConfigure log shipping from the primary to the secondary VM.
   Reveal Solution Discussion Select an answer first
2. 22foundation · easy

   When setting up Always On availability groups on SQL Server on Azure virtual machines, which component is required to provide high availability at the instance level?

   • AA Windows Server Failover Clustering (WSFC) cluster
   • BA storage account configured for geo-redundant storage
   • CAn Azure SQL Database failover group
   • DA load balancer in front of the virtual machines
   Reveal Solution Discussion Select an answer first
4. 23application · medium

   A company has a failover group with two Azure SQL Databases. They want to perform a manual failover to the secondary region for a planned maintenance. What is the correct way to do this?

   • AChange the application connection string to point to the secondary server.
   • BUse the Azure portal to initiate a failover for the failover group, selecting the secondary server as the new primary.
   • CRun ALTER DATABASE ... FAILOVER on each database.
   • DDrop the secondary databases and recreate them in the primary region.
   Reveal Solution Discussion Select an answer first
5. 24application · medium

   You are deploying SQL Server on Azure VMs for a mission-critical application. You need to ensure high availability for the database with automatic failover and also be able to offload read-only queries to a secondary replica. What should you configure?

   • ADatabase mirroring with a witness.
   • BLog shipping with a secondary database in standby mode.
   • CAn Always On Failover Cluster Instance (FCI) with a second node.
   • DAn Always On availability group with a synchronous secondary replica and a read-only routing list.
   Reveal Solution Discussion Select an answer first
6. 25application · medium

   You are configuring an Always On availability group on two Azure VMs running SQL Server 2019. You need to ensure that automatic failover can occur without manual intervention. What additional component must you configure?

   • AAn Azure Load Balancer to route traffic to the secondary.
   • BA scheduled job to run ALTER AVAILABILITY GROUP ... FAILOVER.
   • CA third VM to act as a file share witness.
   • DA second replica in a different availability zone.
   Reveal Solution Discussion Select an answer first