You have 50 Azure SQL databases. You need to automate Transact-SQL queries to run periodically against each database. The solution must minimize administrative effort. What should you configure?

The correct answer is B. SQL Server Agent jobs. The SQL Server Agent is a Microsoft Windows service that executes scheduled administrative tasks (called jobs) in SQL Server and Azure SQL Managed Instance. https://learn.microsoft.com/en-us/ssms/agent/sql-server-agent

Submitted by helene.fr· Mar 6, 2026Configure and manage automation of tasks

Question

You have 50 Azure SQL databases. You need to automate Transact-SQL queries to run periodically against each database. The solution must minimize administrative effort. What should you configure?

Options

Aelastic jobs
BSQL Server Agent jobs
CPower Automate
DTask Scheduler in Windows

How the community answered

(28 responses)

A
7% (2)
B
71% (20)
C
4% (1)
D
18% (5)

Explanation

The SQL Server Agent is a Microsoft Windows service that executes scheduled administrative tasks (called jobs) in SQL Server and Azure SQL Managed Instance. https://learn.microsoft.com/en-us/ssms/agent/sql-server-agent

Topics

#elastic jobs#multi-database automation#Azure SQL Database#job scheduling

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice