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 60

Question 590

An Azure SQL operations team investigates: A compliance team wants to prove automated SQL tasks do not inherit unnecessary server-wide permissions. Select TWO complementary answers: the targeted corrective action AND the evidence that verifies it.

  1. Use Azure SQL Database elastic jobs with an agent, job database, target groups and schedule for T-SQL tasks across one or many databases.
  2. Create SQL Server Agent jobs and schedules on supported SQL Server or Azure SQL Managed Instance targets for repeatable maintenance.
  3. The job completes using a least-privilege execution principal while attempts to access unapproved paths fail.
  4. A controlled job connects only to intended target databases, completes allowed statements and is denied unapproved objects.
  5. Run SQL Server Agent job steps under appropriately scoped credentials or supported proxies and review permissions to external resources.

Explanation

Correct Answers

C:

The acceptance evidence for this incident (A compliance team wants to prove automated SQL tasks do not inherit unnecessary server-wide permissions.) is: The job completes using a least-privilege execution principal while attempts to access unapproved paths fail. It directly tests whether the remediation (Run SQL Server Agent job steps under appropriately scoped credentials or supported proxies and review permissions to external resources.) solves the specified issue, instead of proving an unrelated database control works.

E:

The reported Azure SQL or SQL Server condition is: A compliance team wants to prove automated SQL tasks do not inherit unnecessary server-wide permissions. The specific supported administrative response is: Run SQL Server Agent job steps under appropriately scoped credentials or supported proxies and review permissions to external resources. The technical risk is: Using sysadmin for every automation step or leaving network shares inaccessible can create security and reliability failures. Confirm the correction with: The job completes using a least-privilege execution principal while attempts to access unapproved paths fail.

Incorrect Answers

A:

Elastic jobs across azure SQL databases (4.3) addresses another technical failure: SQL Server Agent is not a feature of Azure SQL Database, and per-database ad hoc scripts can be hard to govern at scale. The case states: the targeted corrective action AND the evidence that verifies it. The most direct paired action and test is: The job completes using a least-privilege execution principal while attempts to access unapproved paths fail.

B:

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 choice can be useful for that problem, but it does not establish the SQL agent execution context and proxy permissions (4.1) control being assessed here.

D:

Elastic job credential and target security (4.3) would demonstrate or implement: A controlled job connects only to intended target databases, completes allowed statements and is denied unapproved objects. The required paired action and test concerns SQL agent execution context and proxy permissions (4.1); a passing result for this alternative could leave that requirement unresolved.

Question 591

An Azure database administrator observes: A multi-step nightly job reports failure but its first two steps succeeded and the third timed out. Which action best addresses the specific technical requirement?

  1. Inspect SQL Server Agent job and step histories, failure output, schedules and retry settings before modifying dependent systems.
  2. Use supported Az PowerShell cmdlets or Azure Resource Manager calls with secured identities for repeated SQL resource configuration operations.
  3. Create SQL Server Agent jobs and schedules on supported SQL Server or Azure SQL Managed Instance targets for repeatable maintenance.
  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 multi-step nightly job reports failure but its first two steps succeeded and the third timed out. The specific supported administrative response is: Inspect SQL Server Agent job and step histories, failure output, schedules and retry settings before modifying dependent systems. The technical risk is: A top-level job failure can conceal the precise failing step or a flawed retry sequence that repeats non-idempotent work. Confirm the correction with: A controlled rerun identifies the previous failing step and completes after the specific cause is corrected.

Incorrect Answers

B:

Azure powershell database automation (4.2) addresses another technical failure: Scripts that depend on a person's interactive credentials or omit subscription context can change the wrong environment. This choice can be useful for that problem, but it does not establish the Troubleshooting job steps and retry behavior (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 Troubleshooting job steps and retry behavior (4.1); 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 Troubleshooting job steps and retry behavior (4.1); a passing result for this alternative could leave that requirement unresolved.

Question 592

During post-change validation, the team reports: A multi-step nightly job reports failure but its first two steps succeeded and the third timed out. Which observation best demonstrates that the appropriate correction worked?

  1. A controlled rerun identifies the previous failing step and completes after the specific cause is corrected.
  2. Job history records successful scheduled execution and its effect on the intended target database.
  3. A scheduled or reviewed PowerShell run targets the intended subscription and SQL resources with expected change logs.
  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 multi-step nightly job reports failure but its first two steps succeeded and the third timed out.) is: A controlled rerun identifies the previous failing step and completes after the specific cause is corrected. It directly tests whether the remediation (Inspect SQL Server Agent job and step histories, failure output, schedules and retry settings before modifying dependent systems.) solves the specified issue, instead of proving an unrelated database control works.

Incorrect Answers

B:

SQL server agent maintenance job schedules (4.1) would demonstrate or implement: Job history records successful scheduled execution and its effect on the intended target database. This choice can be useful for that problem, but it does not establish the Troubleshooting job steps and retry behavior (4.1) control being assessed here.

C:

Azure powershell database automation (4.2) would demonstrate or implement: A scheduled or reviewed PowerShell run targets the intended subscription and SQL resources with expected change logs. This case instead tests Troubleshooting job steps and retry behavior (4.1); 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 Troubleshooting job steps and retry behavior (4.1); a passing result for this alternative could leave that requirement unresolved.

Question 593

An Azure database administrator observes: An SQL Agent task retries an INSERT operation and duplicates rows after partial completion. Which action best addresses the specific technical requirement?

  1. Create SQL Server Agent jobs and schedules on supported SQL Server or Azure SQL Managed Instance targets for repeatable maintenance.
  2. Use supported Az PowerShell cmdlets or Azure Resource Manager calls with secured identities for repeated SQL resource configuration operations.
  3. Inspect SQL Server Agent job and step histories, failure output, schedules and retry settings before modifying dependent systems.
  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: An SQL Agent task retries an INSERT operation and duplicates rows after partial completion. The specific supported administrative response is: Inspect SQL Server Agent job and step histories, failure output, schedules and retry settings before modifying dependent systems. The technical risk is: A top-level job failure can conceal the precise failing step or a flawed retry sequence that repeats non-idempotent work. Confirm the correction with: A controlled rerun identifies the previous failing step and completes after the specific cause is corrected.

Incorrect Answers

A:

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. The case states: An SQL Agent task retries an INSERT operation and duplicates rows after partial completion. The most direct corrective action is: Inspect SQL Server Agent job and step histories, failure output, schedules and retry settings before modifying dependent systems.

B:

Azure powershell database automation (4.2) addresses another technical failure: Scripts that depend on a person's interactive credentials or omit subscription context can change the wrong environment. This choice can be useful for that problem, but it does not establish the Troubleshooting job steps and retry behavior (4.1) 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 Troubleshooting job steps and retry behavior (4.1); a passing result for this alternative could leave that requirement unresolved.

Question 594

In a database operations review, a team encounters: An SQL Agent task retries an INSERT operation and duplicates rows after partial completion. Which failure or exposure is most directly relevant?

  1. A top-level job failure can conceal the precise failing step or a flawed retry sequence that repeats non-idempotent work.
  2. Unscheduled manual tasks or unsupported agent assumptions can leave maintenance undone or jobs never executed.
  3. Scripts that depend on a person's interactive credentials or omit subscription context can change the wrong environment.
  4. Automation code containing embedded secrets or unsupported legacy Run As account patterns creates security and maintenance risk.

Explanation

Correct Answer

A:

The incident (An SQL Agent task retries an INSERT operation and duplicates rows after partial completion.) most directly exposes: A top-level job failure can conceal the precise failing step or a flawed retry sequence that repeats non-idempotent work. The resulting safe technical response is: Inspect SQL Server Agent job and step histories, failure output, schedules and retry settings before modifying dependent systems. Its verification is: A controlled rerun identifies the previous failing step and completes after the specific cause is corrected.

Incorrect Answers

B:

SQL server agent maintenance job schedules (4.1) would demonstrate or implement: Unscheduled manual tasks or unsupported agent assumptions can leave maintenance undone or jobs never executed. This choice can be useful for that problem, but it does not establish the Troubleshooting job steps and retry behavior (4.1) control being assessed here.

C:

Azure powershell database automation (4.2) would demonstrate or implement: Scripts that depend on a person's interactive credentials or omit subscription context can change the wrong environment. This case instead tests Troubleshooting job steps and retry behavior (4.1); 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 Troubleshooting job steps and retry behavior (4.1); a passing result for this alternative could leave that requirement unresolved.

Question 595

An Azure database administrator observes: An operations engineer restarts the entire database server before viewing failed job step output. Which action best addresses the specific technical requirement?

  1. Use supported Az PowerShell cmdlets or Azure Resource Manager calls with secured identities for repeated SQL resource configuration operations.
  2. Create SQL Server Agent jobs and schedules on supported SQL Server or Azure SQL Managed Instance targets for repeatable maintenance.
  3. Use Azure Automation runbooks with managed identity and appropriate module support for approved SQL administrative tasks.
  4. Inspect SQL Server Agent job and step histories, failure output, schedules and retry settings before modifying dependent systems.

Explanation

Correct Answer

D:

The reported Azure SQL or SQL Server condition is: An operations engineer restarts the entire database server before viewing failed job step output. The specific supported administrative response is: Inspect SQL Server Agent job and step histories, failure output, schedules and retry settings before modifying dependent systems. The technical risk is: A top-level job failure can conceal the precise failing step or a flawed retry sequence that repeats non-idempotent work. Confirm the correction with: A controlled rerun identifies the previous failing step and completes after the specific cause is corrected.

Incorrect Answers

A:

Azure powershell database automation (4.2) addresses another technical failure: Scripts that depend on a person's interactive credentials or omit subscription context can change the wrong environment. The case states: An operations engineer restarts the entire database server before viewing failed job step output. The most direct corrective action is: Inspect SQL Server Agent job and step histories, failure output, schedules and retry settings before modifying dependent systems.

B:

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 choice can be useful for that problem, but it does not establish the Troubleshooting job steps and retry behavior (4.1) control being assessed here.

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 Troubleshooting job steps and retry behavior (4.1); the choice measures or changes another part of the system.

Question 596

During post-change validation, the team reports: An operations engineer restarts the entire database server before viewing failed job step output. Which observation best demonstrates that the appropriate correction worked?

  1. A controlled rerun identifies the previous failing step and completes after the specific cause is corrected.
  2. A scheduled or reviewed PowerShell run targets the intended subscription and SQL resources with expected change logs.
  3. A scheduled runbook uses its managed identity, writes an auditable outcome and changes only authorized SQL resources.
  4. Job history records successful scheduled execution and its effect on the intended target database.

Explanation

Correct Answer

A:

The acceptance evidence for this incident (An operations engineer restarts the entire database server before viewing failed job step output.) is: A controlled rerun identifies the previous failing step and completes after the specific cause is corrected. It directly tests whether the remediation (Inspect SQL Server Agent job and step histories, failure output, schedules and retry settings before modifying dependent systems.) solves the specified issue, instead of proving an unrelated database control works.

Incorrect Answers

B:

Azure powershell database automation (4.2) would demonstrate or implement: A scheduled or reviewed PowerShell run targets the intended subscription and SQL resources with expected change logs. This choice can be useful for that problem, but it does not establish the Troubleshooting job steps and retry behavior (4.1) control being assessed here.

C:

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. This case instead tests Troubleshooting job steps and retry behavior (4.1); the choice measures or changes another part of the system.

D:

SQL server agent maintenance job schedules (4.1) would demonstrate or implement: Job history records successful scheduled execution and its effect on the intended target database. The required evidence concerns Troubleshooting job steps and retry behavior (4.1); a passing result for this alternative could leave that requirement unresolved.

Question 597

An Azure database administrator observes: A scheduled procedure fails only when its connection database is set differently than a manual session. Which action best addresses the specific technical requirement?

  1. Use Azure Automation runbooks with managed identity and appropriate module support for approved SQL administrative tasks.
  2. Create SQL Server Agent jobs and schedules on supported SQL Server or Azure SQL Managed Instance targets for repeatable maintenance.
  3. Use supported Az PowerShell cmdlets or Azure Resource Manager calls with secured identities for repeated SQL resource configuration operations.
  4. Inspect SQL Server Agent job and step histories, failure output, schedules and retry settings before modifying dependent systems.

Explanation

Correct Answer

D:

The reported Azure SQL or SQL Server condition is: A scheduled procedure fails only when its connection database is set differently than a manual session. The specific supported administrative response is: Inspect SQL Server Agent job and step histories, failure output, schedules and retry settings before modifying dependent systems. The technical risk is: A top-level job failure can conceal the precise failing step or a flawed retry sequence that repeats non-idempotent work. Confirm the correction with: A controlled rerun identifies the previous failing step and completes after the specific cause is corrected.

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: A scheduled procedure fails only when its connection database is set differently than a manual session. The most direct corrective action is: Inspect SQL Server Agent job and step histories, failure output, schedules and retry settings before modifying dependent systems.

B:

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 choice can be useful for that problem, but it does not establish the Troubleshooting job steps and retry behavior (4.1) control being assessed here.

C:

Azure powershell database automation (4.2) addresses another technical failure: Scripts that depend on a person's interactive credentials or omit subscription context can change the wrong environment. This case instead tests Troubleshooting job steps and retry behavior (4.1); the choice measures or changes another part of the system.

Question 598

In a database operations review, a team encounters: A scheduled procedure fails only when its connection database is set differently than a manual session. Which failure or exposure is most directly relevant?

  1. Scripts that depend on a person's interactive credentials or omit subscription context can change the wrong environment.
  2. A top-level job failure can conceal the precise failing step or a flawed retry sequence that repeats non-idempotent work.
  3. Automation code containing embedded secrets or unsupported legacy Run As account patterns creates security and maintenance risk.
  4. Unscheduled manual tasks or unsupported agent assumptions can leave maintenance undone or jobs never executed.

Explanation

Correct Answer

B:

The incident (A scheduled procedure fails only when its connection database is set differently than a manual session.) most directly exposes: A top-level job failure can conceal the precise failing step or a flawed retry sequence that repeats non-idempotent work. The resulting safe technical response is: Inspect SQL Server Agent job and step histories, failure output, schedules and retry settings before modifying dependent systems. Its verification is: A controlled rerun identifies the previous failing step and completes after the specific cause is corrected.

Incorrect Answers

A:

Azure powershell database automation (4.2) would demonstrate or implement: Scripts that depend on a person's interactive credentials or omit subscription context can change the wrong environment. The case states: A scheduled procedure fails only when its connection database is set differently than a manual session. The most direct risk is: A top-level job failure can conceal the precise failing step or a flawed retry sequence that repeats non-idempotent work.

C:

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. This case instead tests Troubleshooting job steps and retry behavior (4.1); the choice measures or changes another part of the system.

D:

SQL server agent maintenance job schedules (4.1) would demonstrate or implement: Unscheduled manual tasks or unsupported agent assumptions can leave maintenance undone or jobs never executed. The required risk concerns Troubleshooting job steps and retry behavior (4.1); a passing result for this alternative could leave that requirement unresolved.

Question 599

An Azure database administrator observes: A database mail alert says a job failed but the DBA needs the exact SQL error and step time to investigate. Which action best addresses the specific technical requirement?

  1. Inspect SQL Server Agent job and step histories, failure output, schedules and retry settings before modifying dependent systems.
  2. Create SQL Server Agent jobs and schedules on supported SQL Server or Azure SQL Managed Instance targets for repeatable maintenance.
  3. Use supported Az PowerShell cmdlets or Azure Resource Manager calls with secured identities for repeated SQL resource configuration operations.
  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 database mail alert says a job failed but the DBA needs the exact SQL error and step time to investigate. The specific supported administrative response is: Inspect SQL Server Agent job and step histories, failure output, schedules and retry settings before modifying dependent systems. The technical risk is: A top-level job failure can conceal the precise failing step or a flawed retry sequence that repeats non-idempotent work. Confirm the correction with: A controlled rerun identifies the previous failing step and completes after the specific cause is corrected.

Incorrect Answers

B:

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 choice can be useful for that problem, but it does not establish the Troubleshooting job steps and retry behavior (4.1) control being assessed here.

C:

Azure powershell database automation (4.2) addresses another technical failure: Scripts that depend on a person's interactive credentials or omit subscription context can change the wrong environment. This case instead tests Troubleshooting job steps and retry behavior (4.1); 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 diagnosis concerns Troubleshooting job steps and retry behavior (4.1); a passing result for this alternative could leave that requirement unresolved.

Question 600

An Azure SQL operations team investigates: A database mail alert says a job failed but the DBA needs the exact SQL error and step time to investigate. Select TWO complementary answers: the targeted corrective action AND the evidence that verifies it.

  1. A controlled rerun identifies the previous failing step and completes after the specific cause is corrected.
  2. Use Azure Automation runbooks with managed identity and appropriate module support for approved SQL administrative tasks.
  3. Create SQL Server Agent jobs and schedules on supported SQL Server or Azure SQL Managed Instance targets for repeatable maintenance.
  4. Inspect SQL Server Agent job and step histories, failure output, schedules and retry settings before modifying dependent systems.
  5. A scheduled or reviewed PowerShell run targets the intended subscription and SQL resources with expected change logs.

Explanation

Correct Answers

A:

The acceptance evidence for this incident (A database mail alert says a job failed but the DBA needs the exact SQL error and step time to investigate.) is: A controlled rerun identifies the previous failing step and completes after the specific cause is corrected. It directly tests whether the remediation (Inspect SQL Server Agent job and step histories, failure output, schedules and retry settings before modifying dependent systems.) solves the specified issue, instead of proving an unrelated database control works.

D:

The reported Azure SQL or SQL Server condition is: A database mail alert says a job failed but the DBA needs the exact SQL error and step time to investigate. The specific supported administrative response is: Inspect SQL Server Agent job and step histories, failure output, schedules and retry settings before modifying dependent systems. The technical risk is: A top-level job failure can conceal the precise failing step or a flawed retry sequence that repeats non-idempotent work. Confirm the correction with: A controlled rerun identifies the previous failing step and completes after the specific cause is corrected.

Incorrect Answers

B:

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 choice can be useful for that problem, but it does not establish the Troubleshooting job steps and retry behavior (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 Troubleshooting job steps and retry behavior (4.1); the choice measures or changes another part of the system.

E:

Azure powershell database automation (4.2) would demonstrate or implement: A scheduled or reviewed PowerShell run targets the intended subscription and SQL resources with expected change logs. The paired-answer requirement concerns Troubleshooting job steps and retry behavior (4.1); this alternative does not provide the matching intervention and separate acceptance evidence.