nerdexam
Microsoft

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.

Monitor and manage an Azure data platform solution

Question

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 should you use?

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)
  • A
    3% (1)
  • B
    88% (35)
  • C
    8% (3)
  • D
    3% (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.

Aa SQL Server Agent 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'.

Ban Azure Scheduler jobCorrect

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.

Can Azure Data Factory pipeline

Azure Data Factory pipelines are primarily used for data integration, orchestration, and transformation tasks, not for scheduling routine T-SQL database maintenance.

Dan Elastic Database job

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

#Azure SQL Database#scheduled tasks#T-SQL automation#Azure Scheduler

Community Discussion

No community discussion yet for this question.

Full 70-473 Practice