DP-300 Certification Practice Question #194

Question

You have four Azure subscriptions. Each subscription contains multiple Azure SQL databases.
You need to update the column and index statistics for the databases.
What should you use?

Accepted Answer

Azure SQL Database does not have SQL Server Agent, so option B is immediately eliminated. Azure SQL Analytics (C) is a monitoring/alerting solution with no capability to run maintenance jobs. Automatic tuning (D) manages query plans and indexes, not column/index statistics updates. **Azure Automation runbooks** (A) can run T-SQL scripts across multiple subscriptions, making them the correct tool to update statistics on databases across four subscriptions. The mention of "four subscriptions" hints at the need for a cross-subscription automation tool, which Azure Automation runbooks support natively.

More DP-300 practice questions