BenchMark Quizzes by MDFT Pro

Implement Statistics Maintenance Using Azure Automation

You work for MDFT Pro, a well-known training agency that provides Microsoft certification courses to students worldwide. Mark, the Database Operations Manager, manages an Azure SQL Database named CourseEnrollmentDB that tracks student registrations and course completions. As the database grows, query performance has started to degrade due to outdated statistics.

You need to implement an automated statistics maintenance solution for the CourseEnrollmentDB database. Since Azure SQL Database doesn’t support SQL Server Agent, the solution must use Azure Automation to periodically update statistics and ensure optimal query performance. The maintenance must run automatically on a regular schedule without manual intervention.

Which four actions should you perform in sequence?

Choose all correct answers from the options below.

Explanations for each answer:

Create an Azure Automation account is correct. Creating an Azure Automation account is the first step, as it will host the runbook for statistics maintenance.
Create a SQL Server Agent job is incorrect. Azure SQL Database doesn't support SQL Server Agent jobs. Azure Automation must be used instead.
Run sp_add_jobserver is incorrect. sp_add_jobserver is used with SQL Server Agent, which is not available in Azure SQL Database.
Import the SqlServer module is incorrect. While the SqlServer module may be needed, creating and configuring the runbook comes before importing modules.
Create a runbook that runs a PowerShell script is correct. Creating a runbook with a PowerShell script is the second step, containing the logic to perform statistics maintenance tasks.
Publish the runbook is correct. Publishing the runbook is the third step, making it available for execution.
Create and configure a schedule is correct. Creating and configuring a schedule is the fourth step, ensuring the runbook runs automatically at regular intervals for statistics maintenance.

Learn more about Azure Automation runbooks:

Azure Automation Runbooks

Practice Exam

Implement Statistics Maintenance Using Azure Automation

Discuss this question on social media: