DP-300 Certification Practice Question #201

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?

Accepted Answer

To schedule and execute Transact-SQL commands against multiple Azure SQL databases on a daily basis, Elastic Jobs are the designated native solution. Azure SQL Database (single database and elastic pool) does not support native SQL Server Agent jobs (option B). While Azure Automation (option D) and Azure Functions (option A) can run PowerShell/Python scripts that connect to SQL, they are not designed to schedule and manage job runs natively using T-SQL commands across target databases. Elastic Jobs provide native T-SQL-based scheduling and execution, which fits the requirements perfectly.

More DP-300 practice questions