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 62

Question 610

An Azure SQL operations team investigates: A disaster-recovery plan includes the database connection string but omits job owners, notifications and schedules. Select TWO complementary answers: the targeted corrective action AND the evidence that verifies it.

  1. Use Azure Automation runbooks with managed identity and appropriate module support for approved SQL administrative tasks.
  2. A repeatable deployment produces the approved Azure SQL resource configuration and its change is reviewable.
  3. Create SQL Server Agent jobs and schedules on supported SQL Server or Azure SQL Managed Instance targets for repeatable maintenance.
  4. A documented failover rehearsal shows required jobs exist, are correctly enabled and do not run twice on both nodes.
  5. Include supported SQL Agent jobs, credentials and notifications in HA/DR runbooks and validate execution after failover.

Explanation

Correct Answers

D:

The acceptance evidence for this incident (A disaster-recovery plan includes the database connection string but omits job owners, notifications and schedules.) is: A documented failover rehearsal shows required jobs exist, are correctly enabled and do not run twice on both nodes. It directly tests whether the remediation (Include supported SQL Agent jobs, credentials and notifications in HA/DR runbooks and validate execution after failover.) solves the specified issue, instead of proving an unrelated database control works.

E:

The reported Azure SQL or SQL Server condition is: A disaster-recovery plan includes the database connection string but omits job owners, notifications and schedules. The specific supported administrative response is: Include supported SQL Agent jobs, credentials and notifications in HA/DR runbooks and validate execution after failover. The technical risk is: A database can fail over successfully while instance-level jobs on the new primary remain absent or disabled. Confirm the correction with: A documented failover rehearsal shows required jobs exist, are correctly enabled and do not run twice on both nodes.

Incorrect Answers

A:

Azure automation SQL runbooks and managed identities (4.3) addresses another technical failure: Automation code containing embedded secrets or unsupported legacy Run As account patterns creates security and maintenance risk. The case states: the targeted corrective action AND the evidence that verifies it. The most direct paired action and test is: A documented failover rehearsal shows required jobs exist, are correctly enabled and do not run twice on both nodes.

B:

Azure SQL resource deployment using bicep (4.2) would demonstrate or implement: A repeatable deployment produces the approved Azure SQL resource configuration and its change is reviewable. This choice can be useful for that problem, but it does not establish the Maintaining job schedules across failover (4.1) control being assessed here.

C:

SQL server agent maintenance job schedules (4.1) addresses another technical failure: Unscheduled manual tasks or unsupported agent assumptions can leave maintenance undone or jobs never executed. This case instead tests Maintaining job schedules across failover (4.1); the choice measures or changes another part of the system.

Question 611

An Azure database administrator observes: A database team creates production servers through portal clicks and repeatedly forgets audit settings. Which action best addresses the specific technical requirement?

  1. Compare deployed Azure SQL resources with approved IaC definitions and reconcile changes through controlled pipeline updates.
  2. Include supported SQL Agent jobs, credentials and notifications in HA/DR runbooks and validate execution after failover.
  3. Provision Azure SQL database resources with version-controlled Bicep definitions and environment parameters through approved deployment pipelines.
  4. Use Azure Automation runbooks with managed identity and appropriate module support for approved SQL administrative tasks.

Explanation

Correct Answer

C:

The reported Azure SQL or SQL Server condition is: A database team creates production servers through portal clicks and repeatedly forgets audit settings. The specific supported administrative response is: Provision Azure SQL database resources with version-controlled Bicep definitions and environment parameters through approved deployment pipelines. The technical risk is: Manual production configuration can drift from tested resource sizing, networking and backup settings. Confirm the correction with: A repeatable deployment produces the approved Azure SQL resource configuration and its change is reviewable.

Incorrect Answers

A:

Infrastructure drift and declarative reconciliation (4.2) addresses another technical failure: Untracked manual overrides can break reproducibility and cause security configuration drift between environments. The case states: A database team creates production servers through portal clicks and repeatedly forgets audit settings. The most direct corrective action is: Provision Azure SQL database resources with version-controlled Bicep definitions and environment parameters through approved deployment pipelines.

B:

Maintaining job schedules across failover (4.1) addresses another technical failure: A database can fail over successfully while instance-level jobs on the new primary remain absent or disabled. This choice can be useful for that problem, but it does not establish the Azure SQL resource deployment using bicep (4.2) control being assessed here.

D:

Azure automation SQL runbooks and managed identities (4.3) addresses another technical failure: Automation code containing embedded secrets or unsupported legacy Run As account patterns creates security and maintenance risk. The required corrective action concerns Azure SQL resource deployment using bicep (4.2); a passing result for this alternative could leave that requirement unresolved.

Question 612

During post-change validation, the team reports: A database team creates production servers through portal clicks and repeatedly forgets audit settings. Which observation best demonstrates that the appropriate correction worked?

  1. A repeatable deployment produces the approved Azure SQL resource configuration and its change is reviewable.
  2. A drift check identifies a test manual change and a reviewed pipeline restores the approved state.
  3. A documented failover rehearsal shows required jobs exist, are correctly enabled and do not run twice on both nodes.
  4. A scheduled runbook uses its managed identity, writes an auditable outcome and changes only authorized SQL resources.

Explanation

Correct Answer

A:

The acceptance evidence for this incident (A database team creates production servers through portal clicks and repeatedly forgets audit settings.) is: A repeatable deployment produces the approved Azure SQL resource configuration and its change is reviewable. It directly tests whether the remediation (Provision Azure SQL database resources with version-controlled Bicep definitions and environment parameters through approved deployment pipelines.) solves the specified issue, instead of proving an unrelated database control works.

Incorrect Answers

B:

Infrastructure drift and declarative reconciliation (4.2) would demonstrate or implement: A drift check identifies a test manual change and a reviewed pipeline restores the approved state. This choice can be useful for that problem, but it does not establish the Azure SQL resource deployment using bicep (4.2) control being assessed here.

C:

Maintaining job schedules across failover (4.1) would demonstrate or implement: A documented failover rehearsal shows required jobs exist, are correctly enabled and do not run twice on both nodes. This case instead tests Azure SQL resource deployment using bicep (4.2); the choice measures or changes another part of the system.

D:

Azure automation SQL runbooks and managed identities (4.3) would demonstrate or implement: A scheduled runbook uses its managed identity, writes an auditable outcome and changes only authorized SQL resources. The required evidence concerns Azure SQL resource deployment using bicep (4.2); a passing result for this alternative could leave that requirement unresolved.

Question 613

An Azure database administrator observes: A platform group wants one parameterized Bicep file for development, staging and production. Which action best addresses the specific technical requirement?

  1. Provision Azure SQL database resources with version-controlled Bicep definitions and environment parameters through approved deployment pipelines.
  2. Include supported SQL Agent jobs, credentials and notifications in HA/DR runbooks and validate execution after failover.
  3. Compare deployed Azure SQL resources with approved IaC definitions and reconcile changes through controlled pipeline updates.
  4. Use Azure Automation runbooks with managed identity and appropriate module support for approved SQL administrative tasks.

Explanation

Correct Answer

A:

The reported Azure SQL or SQL Server condition is: A platform group wants one parameterized Bicep file for development, staging and production. The specific supported administrative response is: Provision Azure SQL database resources with version-controlled Bicep definitions and environment parameters through approved deployment pipelines. The technical risk is: Manual production configuration can drift from tested resource sizing, networking and backup settings. Confirm the correction with: A repeatable deployment produces the approved Azure SQL resource configuration and its change is reviewable.

Incorrect Answers

B:

Maintaining job schedules across failover (4.1) addresses another technical failure: A database can fail over successfully while instance-level jobs on the new primary remain absent or disabled. This choice can be useful for that problem, but it does not establish the Azure SQL resource deployment using bicep (4.2) control being assessed here.

C:

Infrastructure drift and declarative reconciliation (4.2) addresses another technical failure: Untracked manual overrides can break reproducibility and cause security configuration drift between environments. This case instead tests Azure SQL resource deployment using bicep (4.2); the choice measures or changes another part of the system.

D:

Azure automation SQL runbooks and managed identities (4.3) addresses another technical failure: Automation code containing embedded secrets or unsupported legacy Run As account patterns creates security and maintenance risk. The required corrective action concerns Azure SQL resource deployment using bicep (4.2); a passing result for this alternative could leave that requirement unresolved.

Question 614

In a database operations review, a team encounters: A platform group wants one parameterized Bicep file for development, staging and production. Which failure or exposure is most directly relevant?

  1. Manual production configuration can drift from tested resource sizing, networking and backup settings.
  2. Untracked manual overrides can break reproducibility and cause security configuration drift between environments.
  3. A database can fail over successfully while instance-level jobs on the new primary remain absent or disabled.
  4. Automation code containing embedded secrets or unsupported legacy Run As account patterns creates security and maintenance risk.

Explanation

Correct Answer

A:

The incident (A platform group wants one parameterized Bicep file for development, staging and production.) most directly exposes: Manual production configuration can drift from tested resource sizing, networking and backup settings. The resulting safe technical response is: Provision Azure SQL database resources with version-controlled Bicep definitions and environment parameters through approved deployment pipelines. Its verification is: A repeatable deployment produces the approved Azure SQL resource configuration and its change is reviewable.

Incorrect Answers

B:

Infrastructure drift and declarative reconciliation (4.2) would demonstrate or implement: Untracked manual overrides can break reproducibility and cause security configuration drift between environments. This choice can be useful for that problem, but it does not establish the Azure SQL resource deployment using bicep (4.2) control being assessed here.

C:

Maintaining job schedules across failover (4.1) would demonstrate or implement: A database can fail over successfully while instance-level jobs on the new primary remain absent or disabled. This case instead tests Azure SQL resource deployment using bicep (4.2); the choice measures or changes another part of the system.

D:

Azure automation SQL runbooks and managed identities (4.3) would demonstrate or implement: Automation code containing embedded secrets or unsupported legacy Run As account patterns creates security and maintenance risk. The required risk concerns Azure SQL resource deployment using bicep (4.2); a passing result for this alternative could leave that requirement unresolved.

Question 615

An Azure database administrator observes: An infrastructure rollout changes a SQL database service tier with no reviewed deployment diff. Which action best addresses the specific technical requirement?

  1. Include supported SQL Agent jobs, credentials and notifications in HA/DR runbooks and validate execution after failover.
  2. Provision Azure SQL database resources with version-controlled Bicep definitions and environment parameters through approved deployment pipelines.
  3. Compare deployed Azure SQL resources with approved IaC definitions and reconcile changes through controlled pipeline updates.
  4. Use Azure Automation runbooks with managed identity and appropriate module support for approved SQL administrative tasks.

Explanation

Correct Answer

B:

The reported Azure SQL or SQL Server condition is: An infrastructure rollout changes a SQL database service tier with no reviewed deployment diff. The specific supported administrative response is: Provision Azure SQL database resources with version-controlled Bicep definitions and environment parameters through approved deployment pipelines. The technical risk is: Manual production configuration can drift from tested resource sizing, networking and backup settings. Confirm the correction with: A repeatable deployment produces the approved Azure SQL resource configuration and its change is reviewable.

Incorrect Answers

A:

Maintaining job schedules across failover (4.1) addresses another technical failure: A database can fail over successfully while instance-level jobs on the new primary remain absent or disabled. The case states: An infrastructure rollout changes a SQL database service tier with no reviewed deployment diff. The most direct corrective action is: Provision Azure SQL database resources with version-controlled Bicep definitions and environment parameters through approved deployment pipelines.

C:

Infrastructure drift and declarative reconciliation (4.2) addresses another technical failure: Untracked manual overrides can break reproducibility and cause security configuration drift between environments. This case instead tests Azure SQL resource deployment using bicep (4.2); the choice measures or changes another part of the system.

D:

Azure automation SQL runbooks and managed identities (4.3) addresses another technical failure: Automation code containing embedded secrets or unsupported legacy Run As account patterns creates security and maintenance risk. The required corrective action concerns Azure SQL resource deployment using bicep (4.2); a passing result for this alternative could leave that requirement unresolved.

Question 616

During post-change validation, the team reports: An infrastructure rollout changes a SQL database service tier with no reviewed deployment diff. Which observation best demonstrates that the appropriate correction worked?

  1. A drift check identifies a test manual change and a reviewed pipeline restores the approved state.
  2. A repeatable deployment produces the approved Azure SQL resource configuration and its change is reviewable.
  3. A documented failover rehearsal shows required jobs exist, are correctly enabled and do not run twice on both nodes.
  4. A scheduled runbook uses its managed identity, writes an auditable outcome and changes only authorized SQL resources.

Explanation

Correct Answer

B:

The acceptance evidence for this incident (An infrastructure rollout changes a SQL database service tier with no reviewed deployment diff.) is: A repeatable deployment produces the approved Azure SQL resource configuration and its change is reviewable. It directly tests whether the remediation (Provision Azure SQL database resources with version-controlled Bicep definitions and environment parameters through approved deployment pipelines.) solves the specified issue, instead of proving an unrelated database control works.

Incorrect Answers

A:

Infrastructure drift and declarative reconciliation (4.2) would demonstrate or implement: A drift check identifies a test manual change and a reviewed pipeline restores the approved state. The case states: An infrastructure rollout changes a SQL database service tier with no reviewed deployment diff. The most direct evidence is: A repeatable deployment produces the approved Azure SQL resource configuration and its change is reviewable.

C:

Maintaining job schedules across failover (4.1) would demonstrate or implement: A documented failover rehearsal shows required jobs exist, are correctly enabled and do not run twice on both nodes. This case instead tests Azure SQL resource deployment using bicep (4.2); the choice measures or changes another part of the system.

D:

Azure automation SQL runbooks and managed identities (4.3) would demonstrate or implement: A scheduled runbook uses its managed identity, writes an auditable outcome and changes only authorized SQL resources. The required evidence concerns Azure SQL resource deployment using bicep (4.2); a passing result for this alternative could leave that requirement unresolved.

Question 617

An Azure database administrator observes: A resource manager template expects a parameter that the pipeline does not supply. Which action best addresses the specific technical requirement?

  1. Provision Azure SQL database resources with version-controlled Bicep definitions and environment parameters through approved deployment pipelines.
  2. Compare deployed Azure SQL resources with approved IaC definitions and reconcile changes through controlled pipeline updates.
  3. Include supported SQL Agent jobs, credentials and notifications in HA/DR runbooks and validate execution after failover.
  4. Use Azure Automation runbooks with managed identity and appropriate module support for approved SQL administrative tasks.

Explanation

Correct Answer

A:

The reported Azure SQL or SQL Server condition is: A resource manager template expects a parameter that the pipeline does not supply. The specific supported administrative response is: Provision Azure SQL database resources with version-controlled Bicep definitions and environment parameters through approved deployment pipelines. The technical risk is: Manual production configuration can drift from tested resource sizing, networking and backup settings. Confirm the correction with: A repeatable deployment produces the approved Azure SQL resource configuration and its change is reviewable.

Incorrect Answers

B:

Infrastructure drift and declarative reconciliation (4.2) addresses another technical failure: Untracked manual overrides can break reproducibility and cause security configuration drift between environments. This choice can be useful for that problem, but it does not establish the Azure SQL resource deployment using bicep (4.2) control being assessed here.

C:

Maintaining job schedules across failover (4.1) addresses another technical failure: A database can fail over successfully while instance-level jobs on the new primary remain absent or disabled. This case instead tests Azure SQL resource deployment using bicep (4.2); the choice measures or changes another part of the system.

D:

Azure automation SQL runbooks and managed identities (4.3) addresses another technical failure: Automation code containing embedded secrets or unsupported legacy Run As account patterns creates security and maintenance risk. The required corrective action concerns Azure SQL resource deployment using bicep (4.2); a passing result for this alternative could leave that requirement unresolved.

Question 618

In a database operations review, a team encounters: A resource manager template expects a parameter that the pipeline does not supply. Which failure or exposure is most directly relevant?

  1. Automation code containing embedded secrets or unsupported legacy Run As account patterns creates security and maintenance risk.
  2. A database can fail over successfully while instance-level jobs on the new primary remain absent or disabled.
  3. Untracked manual overrides can break reproducibility and cause security configuration drift between environments.
  4. Manual production configuration can drift from tested resource sizing, networking and backup settings.

Explanation

Correct Answer

D:

The incident (A resource manager template expects a parameter that the pipeline does not supply.) most directly exposes: Manual production configuration can drift from tested resource sizing, networking and backup settings. The resulting safe technical response is: Provision Azure SQL database resources with version-controlled Bicep definitions and environment parameters through approved deployment pipelines. Its verification is: A repeatable deployment produces the approved Azure SQL resource configuration and its change is reviewable.

Incorrect Answers

A:

Azure automation SQL runbooks and managed identities (4.3) would demonstrate or implement: Automation code containing embedded secrets or unsupported legacy Run As account patterns creates security and maintenance risk. The case states: A resource manager template expects a parameter that the pipeline does not supply. The most direct risk is: Manual production configuration can drift from tested resource sizing, networking and backup settings.

B:

Maintaining job schedules across failover (4.1) would demonstrate or implement: A database can fail over successfully while instance-level jobs on the new primary remain absent or disabled. This choice can be useful for that problem, but it does not establish the Azure SQL resource deployment using bicep (4.2) control being assessed here.

C:

Infrastructure drift and declarative reconciliation (4.2) would demonstrate or implement: Untracked manual overrides can break reproducibility and cause security configuration drift between environments. This case instead tests Azure SQL resource deployment using bicep (4.2); the choice measures or changes another part of the system.

Question 619

An Azure database administrator observes: An Azure SQL server is created successfully but the associated private endpoint deployment is absent. Which action best addresses the specific technical requirement?

  1. Provision Azure SQL database resources with version-controlled Bicep definitions and environment parameters through approved deployment pipelines.
  2. Include supported SQL Agent jobs, credentials and notifications in HA/DR runbooks and validate execution after failover.
  3. Compare deployed Azure SQL resources with approved IaC definitions and reconcile changes through controlled pipeline updates.
  4. Use Azure Automation runbooks with managed identity and appropriate module support for approved SQL administrative tasks.

Explanation

Correct Answer

A:

The reported Azure SQL or SQL Server condition is: An Azure SQL server is created successfully but the associated private endpoint deployment is absent. The specific supported administrative response is: Provision Azure SQL database resources with version-controlled Bicep definitions and environment parameters through approved deployment pipelines. The technical risk is: Manual production configuration can drift from tested resource sizing, networking and backup settings. Confirm the correction with: A repeatable deployment produces the approved Azure SQL resource configuration and its change is reviewable.

Incorrect Answers

B:

Maintaining job schedules across failover (4.1) addresses another technical failure: A database can fail over successfully while instance-level jobs on the new primary remain absent or disabled. This choice can be useful for that problem, but it does not establish the Azure SQL resource deployment using bicep (4.2) control being assessed here.

C:

Infrastructure drift and declarative reconciliation (4.2) addresses another technical failure: Untracked manual overrides can break reproducibility and cause security configuration drift between environments. This case instead tests Azure SQL resource deployment using bicep (4.2); the choice measures or changes another part of the system.

D:

Azure automation SQL runbooks and managed identities (4.3) addresses another technical failure: Automation code containing embedded secrets or unsupported legacy Run As account patterns creates security and maintenance risk. The required corrective action concerns Azure SQL resource deployment using bicep (4.2); a passing result for this alternative could leave that requirement unresolved.

Question 620

An Azure SQL operations team investigates: An Azure SQL server is created successfully but the associated private endpoint deployment is absent. Select TWO complementary answers: the targeted corrective action AND the evidence that verifies it.

  1. Provision Azure SQL database resources with version-controlled Bicep definitions and environment parameters through approved deployment pipelines.
  2. A repeatable deployment produces the approved Azure SQL resource configuration and its change is reviewable.
  3. Use Azure Automation runbooks with managed identity and appropriate module support for approved SQL administrative tasks.
  4. Compare deployed Azure SQL resources with approved IaC definitions and reconcile changes through controlled pipeline updates.
  5. A documented failover rehearsal shows required jobs exist, are correctly enabled and do not run twice on both nodes.

Explanation

Correct Answers

A:

The reported Azure SQL or SQL Server condition is: An Azure SQL server is created successfully but the associated private endpoint deployment is absent. The specific supported administrative response is: Provision Azure SQL database resources with version-controlled Bicep definitions and environment parameters through approved deployment pipelines. The technical risk is: Manual production configuration can drift from tested resource sizing, networking and backup settings. Confirm the correction with: A repeatable deployment produces the approved Azure SQL resource configuration and its change is reviewable.

B:

The acceptance evidence for this incident (An Azure SQL server is created successfully but the associated private endpoint deployment is absent.) is: A repeatable deployment produces the approved Azure SQL resource configuration and its change is reviewable. It directly tests whether the remediation (Provision Azure SQL database resources with version-controlled Bicep definitions and environment parameters through approved deployment pipelines.) solves the specified issue, instead of proving an unrelated database control works.

Incorrect Answers

C:

Azure automation SQL runbooks and managed identities (4.3) addresses another technical failure: Automation code containing embedded secrets or unsupported legacy Run As account patterns creates security and maintenance risk. This case instead tests Azure SQL resource deployment using bicep (4.2); the choice measures or changes another part of the system.

D:

Infrastructure drift and declarative reconciliation (4.2) addresses another technical failure: Untracked manual overrides can break reproducibility and cause security configuration drift between environments. The required paired action and test concerns Azure SQL resource deployment using bicep (4.2); a passing result for this alternative could leave that requirement unresolved.

E:

Maintaining job schedules across failover (4.1) would demonstrate or implement: A documented failover rehearsal shows required jobs exist, are correctly enabled and do not run twice on both nodes. The paired-answer requirement concerns Azure SQL resource deployment using bicep (4.2); this alternative does not provide the matching intervention and separate acceptance evidence.