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 75

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.

Question 741

An Azure database administrator observes: A company has geo-replication enabled but no operator has performed a failover rehearsal. Which action best addresses the specific technical requirement?

  1. Document and regularly test supported failover, failback, application validation, ownership and communication procedures.
  2. Plan hybrid SQL Server availability and disaster recovery with supported replication, network, identity and failover mechanisms for both sites.
  3. Use a supported SQL Server failover cluster instance design with compatible shared storage and cluster/network configuration when instance-level high availability is required.
  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 company has geo-replication enabled but no operator has performed a failover rehearsal. The specific supported administrative response is: Document and regularly test supported failover, failback, application validation, ownership and communication procedures. The technical risk is: An untested disaster recovery plan may fail due to stale credentials, missing DNS or unfamiliar operational steps. Confirm the correction with: A tabletop and controlled technical recovery test record achieved RTO/RPO and remediate every discovered gap.

Incorrect Answers

B:

Hybrid SQL server dr topology planning (5.1) addresses another technical failure: Database replication alone does not ensure client routing, SQL Agent jobs, logins or DNS work after hybrid failover. This choice can be useful for that problem, but it does not establish the Disaster recovery runbook and rehearsal (5.1) control being assessed here.

C:

SQL server failover cluster instances on azure vms (5.3) addresses another technical failure: An availability group and a failover cluster instance protect different scopes; a cluster instance requires supported shared-storage and cluster prerequisites. This case instead tests Disaster recovery runbook and rehearsal (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 Disaster recovery runbook and rehearsal (5.1); a passing result for this alternative could leave that requirement unresolved.

Question 742

During post-change validation, the team reports: A company has geo-replication enabled but no operator has performed a failover rehearsal. Which observation best demonstrates that the appropriate correction worked?

  1. A full end-to-end exercise brings up application clients, required principals and operational jobs on the secondary site.
  2. A tabletop and controlled technical recovery test record achieved RTO/RPO and remediate every discovered gap.
  3. A node failure transfers the clustered SQL instance role to the healthy node and the virtual client name remains available.
  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

B:

The acceptance evidence for this incident (A company has geo-replication enabled but no operator has performed a failover rehearsal.) is: A tabletop and controlled technical recovery test record achieved RTO/RPO and remediate every discovered gap. It directly tests whether the remediation (Document and regularly test supported failover, failback, application validation, ownership and communication procedures.) solves the specified issue, instead of proving an unrelated database control works.

Incorrect Answers

A:

Hybrid SQL server dr topology planning (5.1) would demonstrate or implement: A full end-to-end exercise brings up application clients, required principals and operational jobs on the secondary site. The case states: A company has geo-replication enabled but no operator has performed a failover rehearsal. The most direct evidence is: A tabletop and controlled technical recovery test record achieved RTO/RPO and remediate every discovered gap.

C:

SQL server failover cluster instances on azure vms (5.3) would demonstrate or implement: A node failure transfers the clustered SQL instance role to the healthy node and the virtual client name remains available. This case instead tests Disaster recovery runbook and rehearsal (5.1); the choice measures or changes another part of the system.

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 Disaster recovery runbook and rehearsal (5.1); a passing result for this alternative could leave that requirement unresolved.

Question 743

An Azure database administrator observes: An emergency runbook lists an obsolete administrator account and the recovery process stalls. 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. Use a supported SQL Server failover cluster instance design with compatible shared storage and cluster/network configuration when instance-level high availability is required.
  4. Plan hybrid SQL Server availability and disaster recovery with supported replication, network, identity and failover mechanisms for both sites.

Explanation

Correct Answer

B:

The reported Azure SQL or SQL Server condition is: An emergency runbook lists an obsolete administrator account and the recovery process stalls. The specific supported administrative response is: Document and regularly test supported failover, failback, application validation, ownership and communication procedures. The technical risk is: An untested disaster recovery plan may fail due to stale credentials, missing DNS or unfamiliar operational steps. Confirm the correction with: A tabletop and controlled technical recovery test record achieved RTO/RPO and remediate every discovered gap.

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: An emergency runbook lists an obsolete administrator account and the recovery process stalls. The most direct corrective action is: Document and regularly test supported failover, failback, application validation, ownership and communication procedures.

C:

SQL server failover cluster instances on azure vms (5.3) addresses another technical failure: An availability group and a failover cluster instance protect different scopes; a cluster instance requires supported shared-storage and cluster prerequisites. This case instead tests Disaster recovery runbook and rehearsal (5.1); the choice measures or changes another part of the system.

D:

Hybrid SQL server dr topology planning (5.1) addresses another technical failure: Database replication alone does not ensure client routing, SQL Agent jobs, logins or DNS work after hybrid failover. The required corrective action concerns Disaster recovery runbook and rehearsal (5.1); a passing result for this alternative could leave that requirement unresolved.

Question 744

In a database operations review, a team encounters: An emergency runbook lists an obsolete administrator account and the recovery process stalls. Which failure or exposure is most directly relevant?

  1. An asynchronous geo-secondary may lag behind the primary and individual database failover does not automatically coordinate a multi-database application.
  2. An availability group and a failover cluster instance protect different scopes; a cluster instance requires supported shared-storage and cluster prerequisites.
  3. Database replication alone does not ensure client routing, SQL Agent jobs, logins or DNS work after hybrid failover.
  4. An untested disaster recovery plan may fail due to stale credentials, missing DNS or unfamiliar operational steps.

Explanation

Correct Answer

D:

The incident (An emergency runbook lists an obsolete administrator account and the recovery process stalls.) most directly exposes: An untested disaster recovery plan may fail due to stale credentials, missing DNS or unfamiliar operational steps. The resulting safe technical response is: Document and regularly test supported failover, failback, application validation, ownership and communication procedures. Its verification is: A tabletop and controlled technical recovery test record achieved RTO/RPO and remediate every discovered gap.

Incorrect Answers

A:

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. The case states: An emergency runbook lists an obsolete administrator account and the recovery process stalls. The most direct risk is: An untested disaster recovery plan may fail due to stale credentials, missing DNS or unfamiliar operational steps.

B:

SQL server failover cluster instances on azure vms (5.3) would demonstrate or implement: An availability group and a failover cluster instance protect different scopes; a cluster instance requires supported shared-storage and cluster prerequisites. This choice can be useful for that problem, but it does not establish the Disaster recovery runbook and rehearsal (5.1) control being assessed here.

C:

Hybrid SQL server dr topology planning (5.1) would demonstrate or implement: Database replication alone does not ensure client routing, SQL Agent jobs, logins or DNS work after hybrid failover. This case instead tests Disaster recovery runbook and rehearsal (5.1); the choice measures or changes another part of the system.

Question 745

An Azure database administrator observes: A recovery exercise succeeds at SQL login but dependent application services still cannot write. 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. Use a supported SQL Server failover cluster instance design with compatible shared storage and cluster/network configuration when instance-level high availability is required.

Explanation

Correct Answer

B:

The reported Azure SQL or SQL Server condition is: A recovery exercise succeeds at SQL login but dependent application services still cannot write. The specific supported administrative response is: Document and regularly test supported failover, failback, application validation, ownership and communication procedures. The technical risk is: An untested disaster recovery plan may fail due to stale credentials, missing DNS or unfamiliar operational steps. Confirm the correction with: A tabletop and controlled technical recovery test record achieved RTO/RPO and remediate every discovered gap.

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 recovery exercise succeeds at SQL login but dependent application services still cannot write. The most direct corrective action is: Document and regularly test supported failover, failback, application validation, ownership and communication procedures.

C:

Hybrid SQL server dr topology planning (5.1) addresses another technical failure: Database replication alone does not ensure client routing, SQL Agent jobs, logins or DNS work after hybrid failover. This case instead tests Disaster recovery runbook and rehearsal (5.1); the choice measures or changes another part of the system.

D:

SQL server failover cluster instances on azure vms (5.3) addresses another technical failure: An availability group and a failover cluster instance protect different scopes; a cluster instance requires supported shared-storage and cluster prerequisites. The required corrective action concerns Disaster recovery runbook and rehearsal (5.1); a passing result for this alternative could leave that requirement unresolved.

Question 746

During post-change validation, the team reports: A recovery exercise succeeds at SQL login but dependent application services still cannot write. 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. A full end-to-end exercise brings up application clients, required principals and operational jobs on the secondary site.
  3. A node failure transfers the clustered SQL instance role to the healthy node and the virtual client name remains available.
  4. A tabletop and controlled technical recovery test record achieved RTO/RPO and remediate every discovered gap.

Explanation

Correct Answer

D:

The acceptance evidence for this incident (A recovery exercise succeeds at SQL login but dependent application services still cannot write.) is: A tabletop and controlled technical recovery test record achieved RTO/RPO and remediate every discovered gap. It directly tests whether the remediation (Document and regularly test supported failover, failback, application validation, ownership and communication procedures.) 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 recovery exercise succeeds at SQL login but dependent application services still cannot write. The most direct evidence is: A tabletop and controlled technical recovery test record achieved RTO/RPO and remediate every discovered gap.

B:

Hybrid SQL server dr topology planning (5.1) would demonstrate or implement: A full end-to-end exercise brings up application clients, required principals and operational jobs on the secondary site. This choice can be useful for that problem, but it does not establish the Disaster recovery runbook and rehearsal (5.1) control being assessed here.

C:

SQL server failover cluster instances on azure vms (5.3) would demonstrate or implement: A node failure transfers the clustered SQL instance role to the healthy node and the virtual client name remains available. This case instead tests Disaster recovery runbook and rehearsal (5.1); the choice measures or changes another part of the system.

Question 747

An Azure database administrator observes: A team tests planned failover but not what happens during a forced regional unavailability scenario. 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. Use a supported SQL Server failover cluster instance design with compatible shared storage and cluster/network configuration when instance-level high availability is required.
  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

C:

The reported Azure SQL or SQL Server condition is: A team tests planned failover but not what happens during a forced regional unavailability scenario. The specific supported administrative response is: Document and regularly test supported failover, failback, application validation, ownership and communication procedures. The technical risk is: An untested disaster recovery plan may fail due to stale credentials, missing DNS or unfamiliar operational steps. Confirm the correction with: A tabletop and controlled technical recovery test record achieved RTO/RPO and remediate every discovered gap.

Incorrect Answers

A:

Hybrid SQL server dr topology planning (5.1) addresses another technical failure: Database replication alone does not ensure client routing, SQL Agent jobs, logins or DNS work after hybrid failover. The case states: A team tests planned failover but not what happens during a forced regional unavailability scenario. The most direct corrective action is: Document and regularly test supported failover, failback, application validation, ownership and communication procedures.

B:

SQL server failover cluster instances on azure vms (5.3) addresses another technical failure: An availability group and a failover cluster instance protect different scopes; a cluster instance requires supported shared-storage and cluster prerequisites. This choice can be useful for that problem, but it does not establish the Disaster recovery runbook and rehearsal (5.1) control being assessed here.

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 Disaster recovery runbook and rehearsal (5.1); a passing result for this alternative could leave that requirement unresolved.

Question 748

In a database operations review, a team encounters: A team tests planned failover but not what happens during a forced regional unavailability scenario. 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 availability group and a failover cluster instance protect different scopes; a cluster instance requires supported shared-storage and cluster prerequisites.
  3. An asynchronous geo-secondary may lag behind the primary and individual database failover does not automatically coordinate a multi-database application.
  4. Database replication alone does not ensure client routing, SQL Agent jobs, logins or DNS work after hybrid failover.

Explanation

Correct Answer

A:

The incident (A team tests planned failover but not what happens during a forced regional unavailability scenario.) most directly exposes: An untested disaster recovery plan may fail due to stale credentials, missing DNS or unfamiliar operational steps. The resulting safe technical response is: Document and regularly test supported failover, failback, application validation, ownership and communication procedures. Its verification is: A tabletop and controlled technical recovery test record achieved RTO/RPO and remediate every discovered gap.

Incorrect Answers

B:

SQL server failover cluster instances on azure vms (5.3) would demonstrate or implement: An availability group and a failover cluster instance protect different scopes; a cluster instance requires supported shared-storage and cluster prerequisites. This choice can be useful for that problem, but it does not establish the Disaster recovery runbook and rehearsal (5.1) control being assessed here.

C:

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 case instead tests Disaster recovery runbook and rehearsal (5.1); the choice measures or changes another part of the system.

D:

Hybrid SQL server dr topology planning (5.1) would demonstrate or implement: Database replication alone does not ensure client routing, SQL Agent jobs, logins or DNS work after hybrid failover. The required risk concerns Disaster recovery runbook and rehearsal (5.1); a passing result for this alternative could leave that requirement unresolved.

Question 749

An Azure database administrator observes: An auditor requests evidence that recovery procedures are executable within the stated business time limit. 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. Document and regularly test supported failover, failback, application validation, ownership and communication procedures.
  3. Configure active geo-replication for supported Azure SQL Database individual databases to create readable secondaries and initiate supported failover.
  4. Use a supported SQL Server failover cluster instance design with compatible shared storage and cluster/network configuration when instance-level high availability is required.

Explanation

Correct Answer

B:

The reported Azure SQL or SQL Server condition is: An auditor requests evidence that recovery procedures are executable within the stated business time limit. The specific supported administrative response is: Document and regularly test supported failover, failback, application validation, ownership and communication procedures. The technical risk is: An untested disaster recovery plan may fail due to stale credentials, missing DNS or unfamiliar operational steps. Confirm the correction with: A tabletop and controlled technical recovery test record achieved RTO/RPO and remediate every discovered gap.

Incorrect Answers

A:

Hybrid SQL server dr topology planning (5.1) addresses another technical failure: Database replication alone does not ensure client routing, SQL Agent jobs, logins or DNS work after hybrid failover. The case states: An auditor requests evidence that recovery procedures are executable within the stated business time limit. The most direct corrective action is: Document and regularly test supported failover, failback, application validation, ownership and communication procedures.

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 Disaster recovery runbook and rehearsal (5.1); the choice measures or changes another part of the system.

D:

SQL server failover cluster instances on azure vms (5.3) addresses another technical failure: An availability group and a failover cluster instance protect different scopes; a cluster instance requires supported shared-storage and cluster prerequisites. The required corrective action concerns Disaster recovery runbook and rehearsal (5.1); a passing result for this alternative could leave that requirement unresolved.

Question 750

An Azure SQL operations team investigates: An auditor requests evidence that recovery procedures are executable within the stated business time limit. Select TWO complementary answers: the targeted corrective action AND the evidence that verifies it.

  1. Document and regularly test supported failover, failback, application validation, ownership and communication procedures.
  2. Plan hybrid SQL Server availability and disaster recovery with supported replication, network, identity and failover mechanisms for both sites.
  3. A tabletop and controlled technical recovery test record achieved RTO/RPO and remediate every discovered gap.
  4. Replication status and controlled failover tests show the chosen database can be read on the secondary and promoted with documented data-loss expectations.
  5. Use a supported SQL Server failover cluster instance design with compatible shared storage and cluster/network configuration when instance-level high availability is required.

Explanation

Correct Answers

A:

The reported Azure SQL or SQL Server condition is: An auditor requests evidence that recovery procedures are executable within the stated business time limit. The specific supported administrative response is: Document and regularly test supported failover, failback, application validation, ownership and communication procedures. The technical risk is: An untested disaster recovery plan may fail due to stale credentials, missing DNS or unfamiliar operational steps. Confirm the correction with: A tabletop and controlled technical recovery test record achieved RTO/RPO and remediate every discovered gap.

C:

The acceptance evidence for this incident (An auditor requests evidence that recovery procedures are executable within the stated business time limit.) is: A tabletop and controlled technical recovery test record achieved RTO/RPO and remediate every discovered gap. It directly tests whether the remediation (Document and regularly test supported failover, failback, application validation, ownership and communication procedures.) solves the specified issue, instead of proving an unrelated database control works.

Incorrect Answers

B:

Hybrid SQL server dr topology planning (5.1) addresses another technical failure: Database replication alone does not ensure client routing, SQL Agent jobs, logins or DNS work after hybrid failover. This choice can be useful for that problem, but it does not establish the Disaster recovery runbook and rehearsal (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 paired action and test concerns Disaster recovery runbook and rehearsal (5.1); a passing result for this alternative could leave that requirement unresolved.

E:

SQL server failover cluster instances on azure vms (5.3) addresses another technical failure: An availability group and a failover cluster instance protect different scopes; a cluster instance requires supported shared-storage and cluster prerequisites. The paired-answer requirement concerns Disaster recovery runbook and rehearsal (5.1); this alternative does not provide the matching intervention and separate acceptance evidence.