nerdexam
Microsoft

DP-300 · Question #192

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?

The correct answer is A. an Azure Automation runbook. You can create a runbook for index maintenance in an Azure SQL database.

Submitted by brentm· Mar 6, 2026Configure and manage automation of tasks

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?

Options

  • Aan Azure Automation runbook
  • Ba SQL Agent job
  • CAzure SQL Analytics
  • Dautomatic tuning in Azure SQL Database

How the community answered

(15 responses)
  • A
    73% (11)
  • B
    7% (1)
  • C
    20% (3)

Explanation

You can create a runbook for index maintenance in an Azure SQL database.

Topics

#Azure Automation runbook#index statistics#cross-subscription management#maintenance automation

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice