nerdexam
Microsoft

DP-300 · Question #362

You have an Azure subscription. The subscription contains an instance of SQL Server on Azure Virtual Machines named SQL1 and an Azure Automation account named account1. You need to configure account1

The correct answer is D. State configuration (DSC). Explanation Azure Automation State Configuration (DSC) allows you to define and enforce a desired state for your resources - in this case, ensuring the SQL Server Agent service is always running. DSC continuously monitors the configured node (SQL1) and can automatically remediate

Submitted by hans_de· Mar 6, 2026Configure and manage automation of tasks

Question

You have an Azure subscription. The subscription contains an instance of SQL Server on Azure Virtual Machines named SQL1 and an Azure Automation account named account1. You need to configure account1 to restart the SQL Server Agent service if the service stops. Which setting should you configure?

Options

  • AStart/Stop VM
  • BChange tracking
  • CUpdate management
  • DState configuration (DSC)

How the community answered

(66 responses)
  • A
    18% (12)
  • B
    9% (6)
  • C
    3% (2)
  • D
    70% (46)

Explanation

Explanation

Azure Automation State Configuration (DSC) allows you to define and enforce a desired state for your resources - in this case, ensuring the SQL Server Agent service is always running. DSC continuously monitors the configured node (SQL1) and can automatically remediate drift, such as restarting a stopped service, making it the perfect tool for this requirement.

Why the distractors are wrong:

  • A. Start/Stop VM is a feature for scheduling virtual machine power states (starting/stopping the entire VM), not for managing services within a VM.
  • B. Change tracking monitors and logs changes to software, files, and services for auditing purposes - it detects changes but does not take corrective action.
  • C. Update management is focused on OS and software patch management, not service state enforcement.

Memory Tip

Think of DSC = "Don't Stop Caring" - it continuously checks that your system is in the desired state and fixes it if it drifts. Whenever a question involves automatically enforcing or remediating a configuration (like keeping a service running), DSC is almost always the answer. The keyword to watch for is "if the service stops" - this implies automatic remediation, which is DSC's core strength.

Topics

#Azure Automation#Desired State Configuration (DSC)#SQL Server Agent#Service management

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice