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
Question
Options
- AStart/Stop VM
- BChange tracking
- CUpdate management
- DState configuration (DSC)
How the community answered
(66 responses)- A18% (12)
- B9% (6)
- C3% (2)
- D70% (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
Community Discussion
No community discussion yet for this question.