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

Questions 6–10

1. 6application · medium

   Your organization has an Azure SQL Database in the UK South region. You need to configure automatic failover to UK West with a recovery point objective (RPO) of 5 seconds. You also need to be able to manually fail back without data loss. What should you configure?

   • AConfigure an Always On availability group with a synchronous replica in UK West.
   • BConfigure log shipping to a SQL Server VM in UK West.
   • CConfigure a failover group with UK West as the secondary region.
   • DConfigure active geo-replication to UK West and manually promote the secondary during an outage.
   Reveal Solution Discussion Select an answer first
2. 7application · medium

   A company uses Azure SQL Managed Instance for a mission-critical application. They need a readable secondary in a different region for disaster recovery and want to be able to fail over the entire instance if needed. What should you configure?

   • AActive geo-replication to a secondary Managed Instance in another region.
   • BLog shipping between two Managed Instances.
   • CAn Always On availability group on the Managed Instance, configured with a secondary replica in another region.
   • DA failover group with a secondary Managed Instance in the target region.
   Reveal Solution Discussion Select an answer first
4. 8application · medium

   Your company runs a multi-tenant SaaS application on Azure SQL Database in the West US region. You need to provide read-only access to reporting workloads in East US while keeping the primary database fully available. You also want to be able to fail over the entire logical server if the primary region becomes unavailable. What should you configure?

   • AConfigure log shipping from West US to a SQL Server VM in East US and use the VM as the failover target.
   • BConfigure a failover group with East US as the secondary region; the group automatically creates a readable secondary.
   • CConfigure an Always On availability group on Azure SQL Database and add a read-only replica in East US.
   • DConfigure active geo-replication with East US as the secondary, then add the secondary to a failover group.
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   You need to monitor the health of an Always On availability group. Which dynamic management view (DMV) provides information about the state of availability replicas?

   • Asys.dm_exec_requests
   • Bsys.dm_os_performance_counters
   • Csys.dm_hadr_availability_replica_states
   • Dsys.dm_db_log_stats
   Reveal Solution Discussion Select an answer first
6. 10application · medium

   You manage a SQL Managed Instance in the East US region. You need to configure a disaster recovery solution that provides automatic failover to a secondary region and allows read-only access to the secondary for reporting. You also need to monitor the replication health. What should you configure?

   • AConfigure log shipping to a SQL Server VM in the secondary region.
   • BConfigure an Always On availability group between the primary and secondary managed instances.
   • CConfigure active geo-replication between the managed instances.
   • DConfigure a failover group with the secondary managed instance in a paired region.
   Reveal Solution Discussion Select an answer first