[Reference:, https://www.sqlshack.com/automate-azure-sql-database-indexes-and-statistics-maintenance/, , , , , , , , , Basic Concept: This question tests performance optimization for SQL workloads, including Query Store, automatic tuning, index/statistics maintenance, and engine-level resource behavior., Why A is Correct: Azure Automation runbooks execute PowerShell or Python tasks on a schedule, making them useful for Azure SQL maintenance workflows. The scenario asks for: You need to update the column and index statistics for the databases. That makes an Azure Automation runbook the option that satisfies the required Azure SQL layer and operational outcome., Why B is Wrong: a SQL Agent job can participate in administration workflows, but automation questions require the mechanism that can execute repeatable tasks with the correct scope and schedule. It belongs to a different step of operations; this question needs the mechanism that can run or deploy the task repeatedly., Why C is Wrong: Azure SQL Analytics can participate in administration workflows, but automation questions require the mechanism that can execute repeatable tasks with the correct scope and schedule. It would leave too much manual work or would operate at the wrong scope for the requested automation., Why D is Wrong: Automatic tuning uses built-in recommendations and verification to create/drop indexes or force last known good plans where supported. It does not provide the required repeatable execution, scheduling, or deployment automation requirement, so it would not complete the administrative workflow reliably., ]