Home » Microsoft » 70-765 » Which order should you perform the actions?
DRAG DROP
You have an on-premises database that runs several maintenance jobs.
You move the database to a Microsoft Azure SQL database.
You need to ensure that the maintenance jobs on indexes continue to run after the move.
In which order should you perform the actions? To answer, move all actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:
Correct Answer:
Explanation/Reference:
Explanation:
General steps for a solution to automate the maintenance you Azure SQL DB statistics:
Create Azure automation account
Import SQLServer module
Add Credentials to access SQL DB
Add a runbook to run the maintenance
Schedule task
References: https://blogs.msdn.microsoft.com/azuresqldbsupport/2018/01/15/automating-azure-sql-db-index-and-statistic-maintenance-using-azure-automation/