mcAfee Secure Website
23

Microsoft DP-300 Bundle

Exam Code: DP-300

Exam Name Administering Microsoft Azure SQL Solutions

Certification Provider: Microsoft

Corresponding Certification: Microsoft Certified: Azure Database Administrator Associate

DP-300 Training Materials $44.99

Reliable & Actual Study Materials for DP-300 Exam Success

The Latest DP-300 Exam Questions as Experienced in the Actual Test!

  • 24
    Questions & Answers

    DP-300 Questions & Answers

    470 Questions & Answers

    Includes questions types found on actual exam such as drag and drop, simulation, type in, and fill in the blank.

  • 25
    DP-300 Video Course

    DP-300 Training Course

    130 Video Lectures

    Based on Real Life Scenarios which you will encounter in exam and learn by working with real equipment.

  • exam =30
    Study Guide

    DP-300 Study Guide

    672 PDF Pages

    Study Guide developed by industry experts who have written exams in the past. They are technology-specific IT certification researchers with at least a decade of experience at Fortune 500 companies.

exam =32

Administering Microsoft Azure SQL Solutions (DP-300) Practice Tests

Guarantee

Satisfaction Guaranteed

Pass4sure has a remarkable Microsoft Candidate Success record. We're confident of our products and provide no hassle product exchange. That's how confident we are!

99.3% Pass Rate
Total Cost: $194.97
Bundle Price: $149.98

Purchase Individually

  • exam =34
    Questions & Answers

    Questions & Answers

    470 Questions

    $124.99
    exam =35
  • exam =37
    DP-300 Video Course

    Training Course

    130 Video Lectures

    $39.99
  • exam =36
    Study Guide

    Study Guide

    672 PDF Pages

    $29.99

Microsoft DP-300 Practice Test 74

Question 730

An Azure SQL operations team investigates: A compliance auditor asks whether the documented RPO/RTO applies to a zone loss or a full regional loss. Select TWO complementary answers: the targeted corrective action AND the evidence that verifies it.

  1. Apply SQL Server backup restoration in the correct full, optional differential and transaction-log order, using NORECOVERY until final recovery.
  2. Document and regularly test supported failover, failback, application validation, ownership and communication procedures.
  3. Differentiate availability-zone failure protection from cross-region disaster recovery and choose appropriate supported redundancy options.
  4. Controlled failure-domain tests show zonal continuity and separately documented regional recovery capability.
  5. Replication status and controlled failover tests show the chosen database can be read on the secondary and promoted with documented data-loss expectations.

Explanation

Correct Answers

C:

The reported Azure SQL or SQL Server condition is: A compliance auditor asks whether the documented RPO/RTO applies to a zone loss or a full regional loss. The specific supported administrative response is: Differentiate availability-zone failure protection from cross-region disaster recovery and choose appropriate supported redundancy options. The technical risk is: A zone-redundant primary inside one region may not protect against a complete regional outage. Confirm the correction with: Controlled failure-domain tests show zonal continuity and separately documented regional recovery capability.

D:

The acceptance evidence for this incident (A compliance auditor asks whether the documented RPO/RTO applies to a zone loss or a full regional loss.) is: Controlled failure-domain tests show zonal continuity and separately documented regional recovery capability. It directly tests whether the remediation (Differentiate availability-zone failure protection from cross-region disaster recovery and choose appropriate supported redundancy options.) solves the specified issue, instead of proving an unrelated database control works.

Incorrect Answers

A:

Native restore sequence with norecovery and recovery (5.2) addresses another technical failure: Recovering the database too early or restoring an incompatible log backup can prevent remaining backup application. The case states: A compliance auditor asks whether the documented RPO/RTO applies to a zone loss or a full regional loss. The most direct paired action and test is: Differentiate availability-zone failure protection from cross-region disaster recovery and choose appropriate supported redundancy options.

B:

Disaster recovery runbook and rehearsal (5.1) addresses another technical failure: An untested disaster recovery plan may fail due to stale credentials, missing DNS or unfamiliar operational steps. This choice can be useful for that problem, but it does not establish the Zone redundancy versus geo disaster recovery (5.1) control being assessed here.

E:

Azure SQL database active geo-replication (5.3) would demonstrate or implement: Replication status and controlled failover tests show the chosen database can be read on the secondary and promoted with documented data-loss expectations. The paired-answer requirement concerns Zone redundancy versus geo disaster recovery (5.1); this alternative does not provide the matching intervention and separate acceptance evidence.

Question 731

An Azure database administrator observes: An enterprise runs SQL Server on-premises with a warm disaster-recovery instance in Azure. Which action best addresses the specific technical requirement?

  1. Monitor SQL HA/DR replica synchronization, redo or log-send queues, failover readiness and user connection validation at the relevant platform layer.
  2. Configure active geo-replication for supported Azure SQL Database individual databases to create readable secondaries and initiate supported failover.
  3. Document and regularly test supported failover, failback, application validation, ownership and communication procedures.
  4. Plan hybrid SQL Server availability and disaster recovery with supported replication, network, identity and failover mechanisms for both sites.

Explanation

Correct Answer

D:

The reported Azure SQL or SQL Server condition is: An enterprise runs SQL Server on-premises with a warm disaster-recovery instance in Azure. The specific supported administrative response is: Plan hybrid SQL Server availability and disaster recovery with supported replication, network, identity and failover mechanisms for both sites. The technical risk is: Database replication alone does not ensure client routing, SQL Agent jobs, logins or DNS work after hybrid failover. Confirm the correction with: A full end-to-end exercise brings up application clients, required principals and operational jobs on the secondary site.

Incorrect Answers

A:

Monitoring replica health and lag across ha dr (5.3) addresses another technical failure: A replica shown as connected can still be too far behind or unhealthy to satisfy recovery objectives. The case states: An enterprise runs SQL Server on-premises with a warm disaster-recovery instance in Azure. The most direct corrective action is: Plan hybrid SQL Server availability and disaster recovery with supported replication, network, identity and failover mechanisms for both sites.

B:

Azure SQL database active geo-replication (5.3) addresses another technical failure: An asynchronous geo-secondary may lag behind the primary and individual database failover does not automatically coordinate a multi-database application. This choice can be useful for that problem, but it does not establish the Hybrid SQL server dr topology planning (5.1) control being assessed here.

C:

Disaster recovery runbook and rehearsal (5.1) addresses another technical failure: An untested disaster recovery plan may fail due to stale credentials, missing DNS or unfamiliar operational steps. This case instead tests Hybrid SQL server dr topology planning (5.1); the choice measures or changes another part of the system.

Question 732

During post-change validation, the team reports: An enterprise runs SQL Server on-premises with a warm disaster-recovery instance in Azure. Which observation best demonstrates that the appropriate correction worked?

  1. Telemetry and a safe failover exercise demonstrate acceptable replication delay, data consistency and application routing.
  2. A tabletop and controlled technical recovery test record achieved RTO/RPO and remediate every discovered gap.
  3. A full end-to-end exercise brings up application clients, required principals and operational jobs on the secondary site.
  4. Replication status and controlled failover tests show the chosen database can be read on the secondary and promoted with documented data-loss expectations.

Explanation

Correct Answer

C:

The acceptance evidence for this incident (An enterprise runs SQL Server on-premises with a warm disaster-recovery instance in Azure.) is: A full end-to-end exercise brings up application clients, required principals and operational jobs on the secondary site. It directly tests whether the remediation (Plan hybrid SQL Server availability and disaster recovery with supported replication, network, identity and failover mechanisms for both sites.) solves the specified issue, instead of proving an unrelated database control works.

Incorrect Answers

A:

Monitoring replica health and lag across ha dr (5.3) would demonstrate or implement: Telemetry and a safe failover exercise demonstrate acceptable replication delay, data consistency and application routing. The case states: An enterprise runs SQL Server on-premises with a warm disaster-recovery instance in Azure. The most direct evidence is: A full end-to-end exercise brings up application clients, required principals and operational jobs on the secondary site.

B:

Disaster recovery runbook and rehearsal (5.1) would demonstrate or implement: A tabletop and controlled technical recovery test record achieved RTO/RPO and remediate every discovered gap. This choice can be useful for that problem, but it does not establish the Hybrid SQL server dr topology planning (5.1) control being assessed here.

D:

Azure SQL database active geo-replication (5.3) would demonstrate or implement: Replication status and controlled failover tests show the chosen database can be read on the secondary and promoted with documented data-loss expectations. The required evidence concerns Hybrid SQL server dr topology planning (5.1); a passing result for this alternative could leave that requirement unresolved.

Question 733

An Azure database administrator observes: A DBA replicates database pages to a secondary VM but forgets application listener DNS. Which action best addresses the specific technical requirement?

  1. Plan hybrid SQL Server availability and disaster recovery with supported replication, network, identity and failover mechanisms for both sites.
  2. Monitor SQL HA/DR replica synchronization, redo or log-send queues, failover readiness and user connection validation at the relevant platform layer.
  3. Document and regularly test supported failover, failback, application validation, ownership and communication procedures.
  4. Configure active geo-replication for supported Azure SQL Database individual databases to create readable secondaries and initiate supported failover.

Explanation

Correct Answer

A:

The reported Azure SQL or SQL Server condition is: A DBA replicates database pages to a secondary VM but forgets application listener DNS. The specific supported administrative response is: Plan hybrid SQL Server availability and disaster recovery with supported replication, network, identity and failover mechanisms for both sites. The technical risk is: Database replication alone does not ensure client routing, SQL Agent jobs, logins or DNS work after hybrid failover. Confirm the correction with: A full end-to-end exercise brings up application clients, required principals and operational jobs on the secondary site.

Incorrect Answers

B:

Monitoring replica health and lag across ha dr (5.3) addresses another technical failure: A replica shown as connected can still be too far behind or unhealthy to satisfy recovery objectives. This choice can be useful for that problem, but it does not establish the Hybrid SQL server dr topology planning (5.1) control being assessed here.

C:

Disaster recovery runbook and rehearsal (5.1) addresses another technical failure: An untested disaster recovery plan may fail due to stale credentials, missing DNS or unfamiliar operational steps. This case instead tests Hybrid SQL server dr topology planning (5.1); the choice measures or changes another part of the system.

D:

Azure SQL database active geo-replication (5.3) addresses another technical failure: An asynchronous geo-secondary may lag behind the primary and individual database failover does not automatically coordinate a multi-database application. The required corrective action concerns Hybrid SQL server dr topology planning (5.1); a passing result for this alternative could leave that requirement unresolved.

Question 734

In a database operations review, a team encounters: A DBA replicates database pages to a secondary VM but forgets application listener DNS. Which failure or exposure is most directly relevant?

  1. An untested disaster recovery plan may fail due to stale credentials, missing DNS or unfamiliar operational steps.
  2. An asynchronous geo-secondary may lag behind the primary and individual database failover does not automatically coordinate a multi-database application.
  3. Database replication alone does not ensure client routing, SQL Agent jobs, logins or DNS work after hybrid failover.
  4. A replica shown as connected can still be too far behind or unhealthy to satisfy recovery objectives.

Explanation

Correct Answer

C:

The incident (A DBA replicates database pages to a secondary VM but forgets application listener DNS.) most directly exposes: Database replication alone does not ensure client routing, SQL Agent jobs, logins or DNS work after hybrid failover. The resulting safe technical response is: Plan hybrid SQL Server availability and disaster recovery with supported replication, network, identity and failover mechanisms for both sites. Its verification is: A full end-to-end exercise brings up application clients, required principals and operational jobs on the secondary site.

Incorrect Answers

A:

Disaster recovery runbook and rehearsal (5.1) would demonstrate or implement: An untested disaster recovery plan may fail due to stale credentials, missing DNS or unfamiliar operational steps. The case states: A DBA replicates database pages to a secondary VM but forgets application listener DNS. The most direct risk is: Database replication alone does not ensure client routing, SQL Agent jobs, logins or DNS work after hybrid failover.

B:

Azure SQL database active geo-replication (5.3) would demonstrate or implement: An asynchronous geo-secondary may lag behind the primary and individual database failover does not automatically coordinate a multi-database application. This choice can be useful for that problem, but it does not establish the Hybrid SQL server dr topology planning (5.1) control being assessed here.

D:

Monitoring replica health and lag across ha dr (5.3) would demonstrate or implement: A replica shown as connected can still be too far behind or unhealthy to satisfy recovery objectives. The required risk concerns Hybrid SQL server dr topology planning (5.1); a passing result for this alternative could leave that requirement unresolved.

Question 735

An Azure database administrator observes: A hybrid SQL system needs a failover path while the on-premises data center is unavailable. Which action best addresses the specific technical requirement?

  1. Document and regularly test supported failover, failback, application validation, ownership and communication procedures.
  2. Monitor SQL HA/DR replica synchronization, redo or log-send queues, failover readiness and user connection validation at the relevant platform layer.
  3. Configure active geo-replication for supported Azure SQL Database individual databases to create readable secondaries and initiate supported failover.
  4. Plan hybrid SQL Server availability and disaster recovery with supported replication, network, identity and failover mechanisms for both sites.

Explanation

Correct Answer

D:

The reported Azure SQL or SQL Server condition is: A hybrid SQL system needs a failover path while the on-premises data center is unavailable. The specific supported administrative response is: Plan hybrid SQL Server availability and disaster recovery with supported replication, network, identity and failover mechanisms for both sites. The technical risk is: Database replication alone does not ensure client routing, SQL Agent jobs, logins or DNS work after hybrid failover. Confirm the correction with: A full end-to-end exercise brings up application clients, required principals and operational jobs on the secondary site.

Incorrect Answers

A:

Disaster recovery runbook and rehearsal (5.1) addresses another technical failure: An untested disaster recovery plan may fail due to stale credentials, missing DNS or unfamiliar operational steps. The case states: A hybrid SQL system needs a failover path while the on-premises data center is unavailable. The most direct corrective action is: Plan hybrid SQL Server availability and disaster recovery with supported replication, network, identity and failover mechanisms for both sites.

B:

Monitoring replica health and lag across ha dr (5.3) addresses another technical failure: A replica shown as connected can still be too far behind or unhealthy to satisfy recovery objectives. This choice can be useful for that problem, but it does not establish the Hybrid SQL server dr topology planning (5.1) control being assessed here.

C:

Azure SQL database active geo-replication (5.3) addresses another technical failure: An asynchronous geo-secondary may lag behind the primary and individual database failover does not automatically coordinate a multi-database application. This case instead tests Hybrid SQL server dr topology planning (5.1); the choice measures or changes another part of the system.

Question 736

During post-change validation, the team reports: A hybrid SQL system needs a failover path while the on-premises data center is unavailable. Which observation best demonstrates that the appropriate correction worked?

  1. Replication status and controlled failover tests show the chosen database can be read on the secondary and promoted with documented data-loss expectations.
  2. Telemetry and a safe failover exercise demonstrate acceptable replication delay, data consistency and application routing.
  3. A tabletop and controlled technical recovery test record achieved RTO/RPO and remediate every discovered gap.
  4. A full end-to-end exercise brings up application clients, required principals and operational jobs on the secondary site.

Explanation

Correct Answer

D:

The acceptance evidence for this incident (A hybrid SQL system needs a failover path while the on-premises data center is unavailable.) is: A full end-to-end exercise brings up application clients, required principals and operational jobs on the secondary site. It directly tests whether the remediation (Plan hybrid SQL Server availability and disaster recovery with supported replication, network, identity and failover mechanisms for both sites.) solves the specified issue, instead of proving an unrelated database control works.

Incorrect Answers

A:

Azure SQL database active geo-replication (5.3) would demonstrate or implement: Replication status and controlled failover tests show the chosen database can be read on the secondary and promoted with documented data-loss expectations. The case states: A hybrid SQL system needs a failover path while the on-premises data center is unavailable. The most direct evidence is: A full end-to-end exercise brings up application clients, required principals and operational jobs on the secondary site.

B:

Monitoring replica health and lag across ha dr (5.3) would demonstrate or implement: Telemetry and a safe failover exercise demonstrate acceptable replication delay, data consistency and application routing. This choice can be useful for that problem, but it does not establish the Hybrid SQL server dr topology planning (5.1) control being assessed here.

C:

Disaster recovery runbook and rehearsal (5.1) would demonstrate or implement: A tabletop and controlled technical recovery test record achieved RTO/RPO and remediate every discovered gap. This case instead tests Hybrid SQL server dr topology planning (5.1); the choice measures or changes another part of the system.

Question 737

An Azure database administrator observes: A database recovery test passes but server-level linked logins and scheduled jobs are missing after promotion. Which action best addresses the specific technical requirement?

  1. Configure active geo-replication for supported Azure SQL Database individual databases to create readable secondaries and initiate supported failover.
  2. Document and regularly test supported failover, failback, application validation, ownership and communication procedures.
  3. Plan hybrid SQL Server availability and disaster recovery with supported replication, network, identity and failover mechanisms for both sites.
  4. Monitor SQL HA/DR replica synchronization, redo or log-send queues, failover readiness and user connection validation at the relevant platform layer.

Explanation

Correct Answer

C:

The reported Azure SQL or SQL Server condition is: A database recovery test passes but server-level linked logins and scheduled jobs are missing after promotion. The specific supported administrative response is: Plan hybrid SQL Server availability and disaster recovery with supported replication, network, identity and failover mechanisms for both sites. The technical risk is: Database replication alone does not ensure client routing, SQL Agent jobs, logins or DNS work after hybrid failover. Confirm the correction with: A full end-to-end exercise brings up application clients, required principals and operational jobs on the secondary site.

Incorrect Answers

A:

Azure SQL database active geo-replication (5.3) addresses another technical failure: An asynchronous geo-secondary may lag behind the primary and individual database failover does not automatically coordinate a multi-database application. The case states: A database recovery test passes but server-level linked logins and scheduled jobs are missing after promotion. The most direct corrective action is: Plan hybrid SQL Server availability and disaster recovery with supported replication, network, identity and failover mechanisms for both sites.

B:

Disaster recovery runbook and rehearsal (5.1) addresses another technical failure: An untested disaster recovery plan may fail due to stale credentials, missing DNS or unfamiliar operational steps. This choice can be useful for that problem, but it does not establish the Hybrid SQL server dr topology planning (5.1) control being assessed here.

D:

Monitoring replica health and lag across ha dr (5.3) addresses another technical failure: A replica shown as connected can still be too far behind or unhealthy to satisfy recovery objectives. The required corrective action concerns Hybrid SQL server dr topology planning (5.1); a passing result for this alternative could leave that requirement unresolved.

Question 738

In a database operations review, a team encounters: A database recovery test passes but server-level linked logins and scheduled jobs are missing after promotion. Which failure or exposure is most directly relevant?

  1. An untested disaster recovery plan may fail due to stale credentials, missing DNS or unfamiliar operational steps.
  2. An asynchronous geo-secondary may lag behind the primary and individual database failover does not automatically coordinate a multi-database application.
  3. Database replication alone does not ensure client routing, SQL Agent jobs, logins or DNS work after hybrid failover.
  4. A replica shown as connected can still be too far behind or unhealthy to satisfy recovery objectives.

Explanation

Correct Answer

C:

The incident (A database recovery test passes but server-level linked logins and scheduled jobs are missing after promotion.) most directly exposes: Database replication alone does not ensure client routing, SQL Agent jobs, logins or DNS work after hybrid failover. The resulting safe technical response is: Plan hybrid SQL Server availability and disaster recovery with supported replication, network, identity and failover mechanisms for both sites. Its verification is: A full end-to-end exercise brings up application clients, required principals and operational jobs on the secondary site.

Incorrect Answers

A:

Disaster recovery runbook and rehearsal (5.1) would demonstrate or implement: An untested disaster recovery plan may fail due to stale credentials, missing DNS or unfamiliar operational steps. The case states: A database recovery test passes but server-level linked logins and scheduled jobs are missing after promotion. The most direct risk is: Database replication alone does not ensure client routing, SQL Agent jobs, logins or DNS work after hybrid failover.

B:

Azure SQL database active geo-replication (5.3) would demonstrate or implement: An asynchronous geo-secondary may lag behind the primary and individual database failover does not automatically coordinate a multi-database application. This choice can be useful for that problem, but it does not establish the Hybrid SQL server dr topology planning (5.1) control being assessed here.

D:

Monitoring replica health and lag across ha dr (5.3) would demonstrate or implement: A replica shown as connected can still be too far behind or unhealthy to satisfy recovery objectives. The required risk concerns Hybrid SQL server dr topology planning (5.1); a passing result for this alternative could leave that requirement unresolved.

Question 739

An Azure database administrator observes: A new cloud DR host has database files yet inbound firewall rules do not permit the dependent application. Which action best addresses the specific technical requirement?

  1. Configure active geo-replication for supported Azure SQL Database individual databases to create readable secondaries and initiate supported failover.
  2. Monitor SQL HA/DR replica synchronization, redo or log-send queues, failover readiness and user connection validation at the relevant platform layer.
  3. Document and regularly test supported failover, failback, application validation, ownership and communication procedures.
  4. Plan hybrid SQL Server availability and disaster recovery with supported replication, network, identity and failover mechanisms for both sites.

Explanation

Correct Answer

D:

The reported Azure SQL or SQL Server condition is: A new cloud DR host has database files yet inbound firewall rules do not permit the dependent application. The specific supported administrative response is: Plan hybrid SQL Server availability and disaster recovery with supported replication, network, identity and failover mechanisms for both sites. The technical risk is: Database replication alone does not ensure client routing, SQL Agent jobs, logins or DNS work after hybrid failover. Confirm the correction with: A full end-to-end exercise brings up application clients, required principals and operational jobs on the secondary site.

Incorrect Answers

A:

Azure SQL database active geo-replication (5.3) addresses another technical failure: An asynchronous geo-secondary may lag behind the primary and individual database failover does not automatically coordinate a multi-database application. The case states: A new cloud DR host has database files yet inbound firewall rules do not permit the dependent application. The most direct corrective action is: Plan hybrid SQL Server availability and disaster recovery with supported replication, network, identity and failover mechanisms for both sites.

B:

Monitoring replica health and lag across ha dr (5.3) addresses another technical failure: A replica shown as connected can still be too far behind or unhealthy to satisfy recovery objectives. This choice can be useful for that problem, but it does not establish the Hybrid SQL server dr topology planning (5.1) control being assessed here.

C:

Disaster recovery runbook and rehearsal (5.1) addresses another technical failure: An untested disaster recovery plan may fail due to stale credentials, missing DNS or unfamiliar operational steps. This case instead tests Hybrid SQL server dr topology planning (5.1); the choice measures or changes another part of the system.

Question 740

An Azure SQL operations team investigates: A new cloud DR host has database files yet inbound firewall rules do not permit the dependent application. Select TWO complementary answers: the targeted corrective action AND the evidence that verifies it.

  1. Replication status and controlled failover tests show the chosen database can be read on the secondary and promoted with documented data-loss expectations.
  2. Monitor SQL HA/DR replica synchronization, redo or log-send queues, failover readiness and user connection validation at the relevant platform layer.
  3. Document and regularly test supported failover, failback, application validation, ownership and communication procedures.
  4. Plan hybrid SQL Server availability and disaster recovery with supported replication, network, identity and failover mechanisms for both sites.
  5. A full end-to-end exercise brings up application clients, required principals and operational jobs on the secondary site.

Explanation

Correct Answers

D:

The reported Azure SQL or SQL Server condition is: A new cloud DR host has database files yet inbound firewall rules do not permit the dependent application. The specific supported administrative response is: Plan hybrid SQL Server availability and disaster recovery with supported replication, network, identity and failover mechanisms for both sites. The technical risk is: Database replication alone does not ensure client routing, SQL Agent jobs, logins or DNS work after hybrid failover. Confirm the correction with: A full end-to-end exercise brings up application clients, required principals and operational jobs on the secondary site.

E:

The acceptance evidence for this incident (A new cloud DR host has database files yet inbound firewall rules do not permit the dependent application.) is: A full end-to-end exercise brings up application clients, required principals and operational jobs on the secondary site. It directly tests whether the remediation (Plan hybrid SQL Server availability and disaster recovery with supported replication, network, identity and failover mechanisms for both sites.) solves the specified issue, instead of proving an unrelated database control works.

Incorrect Answers

A:

Azure SQL database active geo-replication (5.3) would demonstrate or implement: Replication status and controlled failover tests show the chosen database can be read on the secondary and promoted with documented data-loss expectations. The case states: A new cloud DR host has database files yet inbound firewall rules do not permit the dependent application. The most direct paired action and test is: Plan hybrid SQL Server availability and disaster recovery with supported replication, network, identity and failover mechanisms for both sites.

B:

Monitoring replica health and lag across ha dr (5.3) addresses another technical failure: A replica shown as connected can still be too far behind or unhealthy to satisfy recovery objectives. This choice can be useful for that problem, but it does not establish the Hybrid SQL server dr topology planning (5.1) control being assessed here.

C:

Disaster recovery runbook and rehearsal (5.1) addresses another technical failure: An untested disaster recovery plan may fail due to stale credentials, missing DNS or unfamiliar operational steps. This case instead tests Hybrid SQL server dr topology planning (5.1); the choice measures or changes another part of the system.