You have an Azure subscription that contains 20 Azure SQL databases. You create a Transact-SQL statement to perform index maintenance on a database. You need to schedule the statement to run once…

The correct answer is C. an elastic job. With Azure Automation, you can manage databases in Azure SQL Database by using the latest Az PowerShell cmdlets that are available in Azure Az PowerShell. Elastic jobs would use T-SQL. https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic…

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

Question

You have an Azure subscription that contains 20 Azure SQL databases. You create a Transact-SQL statement to perform index maintenance on a database. You need to schedule the statement to run once daily against each database by using Transact- SQL commands. What should you use to schedule the statement?

Options

Aan Azure function
Ba SQL Server Agent Job
Can elastic job
DAzure Automation

How the community answered

(37 responses)

A
5% (2)
B
14% (5)
C
73% (27)
D
8% (3)

Explanation

With Azure Automation, you can manage databases in Azure SQL Database by using the latest Az PowerShell cmdlets that are available in Azure Az PowerShell. Elastic jobs would use T-SQL. https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic- jobs-tsql-create-manage?view=azuresql-db

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice