Exam DP-300 topic 10 question 1 discussion

I think you're wrong, because before creating and setting up a schedule, we have to publish the runbook. 1. Create an Azure Automation account; 2. Import the SqlServer module 3. Create a runbook that runs a PowerShell script; 4. Publish the runbook.

given answer looks OK - there seems to be some doubt over step 4 - my view is Create and configure a schedule: Finally, configure the runbook to execute automatically by setting up a schedule, ensuring that statistics are regularly maintained in the database.

Create an Azure Automation account. Import the SqlServer module. Create a runbook that runs a PowerShell script. Publish the runbook.

Walkthrough: https://tracyboggiano.com/archive/2023/06/using-azure-automation-and-runbooks-to-run-azure-sql-database-maintenance-tasks/

runbook needs to be published before you can run it: When you create or import a new runbook, you have to publish it before you can run it. Each runbook in Azure Automation has a Draft version and a Published version. Only the Published version is available to be run, and only the Draft version can be edited. The Published version is unaffected by any changes to the Draft version. When the Draft version should be made available, you publish it, overwriting the current Published version with the Draft version. https://learn.microsoft.com/en-us/azure/automation/manage-runbooks

Answer is correct Create Azure automation account Import SQLServer module Add Credentials to access SQL DB Add a runbook to run the maintenance Schedule task

Looks correct.

Is it correct?