Exam DP-300 topic 5 question 24 discussion

Note that Azure Automation can't run T-SQL commands directly. It can run PowerShell which in turn can run T-SQL in a database. So I go with C: Elastic Jobs which support running T-SQL directly.

The correct answer is C. Elastic Job allow to execute only T-SQL command scheduled for a set of target databases

C. Elastic jobs https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-jobs-overview?view=azuresql

The correct answer is (B). An SQL Server Agent job is the best option for these requirements. With an SQL Server Agent job, you can execute Transact-SQL statements regularly. An Azure Function is a good option if you want to create a custom solution. However, creating and managing an Azure Function can be more complex than an SQL Server Agent job. An Elastic Job is a good option if you need a solution for multiple Azure resources. However, creating and managing an Elastic Job can be more complex than an SQL Server Agent job. Azure Automation is a good option if you want to create a custom solution. However, creating and managing Azure Automation can be more complex than an SQL Server Agent job.

the sad part is both Elastic Job and Azure Automation are valid responses (both can run T-SQL commands). I will go with Elastic Job for the sole reason that is free (as of 2023) and Azure Automation seems overkill for the task at hand - not only that, but it seems that it cannot reindex multiple DBs at once, for example. Proof that Azure Automation can also run reindex jobs: https://learn.microsoft.com/en-us/azure/automation/overview: "Common scenarios Azure Automation supports management throughout the lifecycle of your infrastructure and applications. Common scenarios include: Periodic maintenance - to execute tasks that need to be performed at set timed intervals like purging stale or old data, or reindex a SQL database"

On Azure SQL Database elastic jobs is a replacement for SQL Server Agent. Elastic Jobs can do TSQL scheduled jobs. https://learn.microsoft.com/en-us/azure/azure-sql/database/job-automation-overview?view=azuresql

Answer is C

Azure Automation uses PowerShell. 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