DP-300 Certification Practice Question #283

Question

You need to implement statistics maintenance for SalesSQLDb1. The solution must meet the technical requirements.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:

Accepted Answer

The question asks for four actions in sequence to implement statistics maintenance for an Azure SQL Database using Azure Automation. The authoritative MS Learn article on managing runbooks states that a runbook must be published before it can run, which makes the separate "Publish the runbook" step mandatory. The community majority (phmartins 👍 9, amazonalex 👍 4, ae8a90c 👍 1, voodoo_sh) converge on: 1) Create an Azure Automation account, 2) Import the SqlServer module (so PowerShell cmdlets are available), 3) Create a runbook that runs a PowerShell script, 4) Publish the runbook. "Create and configure a schedule" would logically be a 5th step after publishing, not one of the four required. Options like "Create a SQL Server Agent job" and "Run sp_add_jobserver" belong to on-premises SQL Server Agent and are eliminated. Confidence is 82% because there is no explicit "Suggested Answer" text in the file and community discussion has some dissent over step 4 (publish vs. schedule).

More DP-300 practice questions