70-473 · Question #116
Your environment contains several Microsoft Azure SQL databases. You need to execute Transact-SQL-based maintenance steps automatically against the databases. The execution must occur weekly. What…
The correct answer is B. an Azure Scheduler job. To automatically execute weekly Transact-SQL-based maintenance steps against multiple Azure SQL databases, you should leverage an Azure Scheduler job.
Question
Options
- Aa SQL Server Agent job
- Ban Azure Scheduler job
- Can Azure Data Factory pipeline
- Dan Elastic Database job
How the community answered
(40 responses)- A3% (1)
- B88% (35)
- C8% (3)
- D3% (1)
Why each option
To automatically execute weekly Transact-SQL-based maintenance steps against multiple Azure SQL databases, you should leverage an Azure Scheduler job.
SQL Server Agent jobs are available for SQL Server on Azure VMs and Azure SQL Managed Instance, but not directly for Azure SQL Database PaaS, which is typically implied by 'Azure SQL databases'.
An Azure Scheduler job can be configured with a recurring weekly schedule to trigger actions, which can include initiating Transact-SQL commands or custom processes against Azure SQL databases for maintenance purposes.
Azure Data Factory pipelines are primarily used for data integration, orchestration, and transformation tasks, not for scheduling routine T-SQL database maintenance.
Elastic Database jobs are the modern, recommended service for scheduling T-SQL across multiple Azure SQL databases, but Azure Scheduler (if active) could also serve as a generic scheduling mechanism.
Concept tested: Scheduling T-SQL maintenance for Azure SQL Database
Source: https://learn.microsoft.com/en-us/previous-versions/azure/scheduler/scheduler-overview
Topics
Community Discussion
No community discussion yet for this question.