You have 25 Azure SQL databases. You need to implement a centralized database management solution that uses Transact-SQL. What should you include in the solution?

The correct answer is A. elastic jobs. Elastic jobs provide the ability to run one or more T-SQL scripts in parallel, across a large number of databases, on a schedule or on-demand. The target can be any tier of Azure SQL Database. https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-jobs-overview

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

Question

You have 25 Azure SQL databases. You need to implement a centralized database management solution that uses Transact-SQL. What should you include in the solution?

Options

Aelastic jobs
Ban Azure Automation runbook
CAzure Functions
DAzure Logic Apps

How the community answered

(41 responses)

A
76% (31)
B
7% (3)
C
5% (2)
D
12% (5)

Explanation

Elastic jobs provide the ability to run one or more T-SQL scripts in parallel, across a large number of databases, on a schedule or on-demand. The target can be any tier of Azure SQL Database. https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-jobs-overview

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice