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

Questions 26–30

1. 26foundation · easy

   You need to configure active geo-replication for an Azure SQL Database so that a secondary database in a different region can be used for read-only reporting. What is the primary purpose of the secondary database in active geo-replication?

   • ATo provide a read-only copy of the primary database that can be used for reporting and can be manually promoted for failover
   • BTo automatically fail over without any manual intervention when the primary becomes unavailable
   • CTo serve as a backup that can be restored to any point in time
   • DTo provide a writable copy of the primary database for load balancing write operations
   Reveal Solution Discussion Select an answer first
2. 27foundation · easy

   You need to configure automatic failover for multiple Azure SQL databases in a single logical server. Which Azure SQL Database feature should you use?

   • AFailover groups
   • BActive geo-replication
   • CPoint-in-time restore
   • DAzure SQL Database elastic pools
   Reveal Solution Discussion Select an answer first
4. 28foundation · easy

   You need to set up log shipping between a primary SQL Server instance and a secondary instance. What is the core mechanism that log shipping uses to keep the secondary database synchronized?

   • AReplicating data changes at the row level using a change tracking mechanism
   • BPeriodically backing up the transaction log on the primary and restoring it on the secondary
   • CContinuously streaming transaction log records over the network
   • DUsing a failover cluster to share the same storage between primary and secondary
   Reveal Solution Discussion Select an answer first
5. 29foundation · easy

   What is the primary benefit of using a failover group in Azure SQL Database compared to configuring active geo-replication for each database individually?

   • AFailover groups provide automatic failover for multiple databases as a single unit.
   • BFailover groups allow you to write to the secondary database for load balancing.
   • CFailover groups eliminate the need for a secondary server in a different region.
   • DFailover groups provide point-in-time restore for all databases in the group.
   Reveal Solution Discussion Select an answer first
6. 30application · medium

   A company has three Azure SQL Databases that must fail over together to a secondary region with a single connection string. They also need to be able to manually fail back after a regional outage. What should you configure?

   • AA failover group containing all three databases, with the secondary server in the target region.
   • BActive geo-replication for each database, and update the application connection strings to point to the secondary.
   • CLog shipping from the primary to a secondary server, and a custom script to fail over all databases.
   • DA SQL Server Always On availability group on Azure VMs with three databases.
   Reveal Solution Discussion Select an answer first