DRAG DROP -
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:
Automating Azure SQL DB index and statistics maintenance using Azure Automation:
1. Create Azure automation account (Step 1)
2. Import SQLServer module (Step 2)
3. Add Credentials to access SQL DB
This will use secure way to hold login name and password that will be used to access Azure SQL DB
4. Add a runbook to run the maintenance (Step 3)
Steps:
1. Click on "runbooks" at the left panel and then click "add a runbook"
2. Choose "create a new runbook" and then give it a name and choose "Powershell" as the type of the runbook and then click on "create"
5. Schedule task (Step 4)
Steps:
1. Click on Schedules
2. Click on "Add a schedule" and follow the instructions to choose existing schedule or create a new schedule.
Reference:
https://techcommunity.microsoft.com/t5/azure-database-support-blog/automating-azure-sql-db-index-and-statistics-maintenance-using/ba-p/368974
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.
https://docs.microsoft.com/en-us/azure/automation/manage-runbooks
Before Schedule, we need to Save and Publish it. Then its good to give it a test. Then only we need to Schedule it. Very good question, I will say.
You are wrong. Create runbook includes publish.
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
Walkthrough: https://tracyboggiano.com/archive/2023/06/using-azure-automation-and-runbooks-to-run-azure-sql-database-maintenance-tasks/
Looks correct.
Create an Azure Automation account. Import the SqlServer module. Create a runbook that runs a PowerShell script. Publish the runbook.
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
Is it correct?