70-473 · Question #63
What should you use to schedule the nightly jobs to meet the technical requirements?
The correct answer is A. Migrate the SQL Server Agent jobs.. To schedule nightly jobs in a SQL Server environment, especially during migration, the most direct approach is to migrate or replicate the existing SQL Server Agent jobs.
Question
Options
- AMigrate the SQL Server Agent jobs.
- BCreate an Azure Scheduler task.
- CCreate an Azure runbook.
- DImplement an Elastic Database jobs.
How the community answered
(21 responses)- A81% (17)
- B10% (2)
- C5% (1)
- D5% (1)
Why each option
To schedule nightly jobs in a SQL Server environment, especially during migration, the most direct approach is to migrate or replicate the existing SQL Server Agent jobs.
SQL Server Agent is the built-in job scheduler for SQL Server, and its jobs are the standard method for scheduling nightly tasks and maintenance; migrating them ensures continuity with existing SQL Server processes.
Azure Scheduler is a deprecated service and not the primary tool for scheduling SQL Server-specific jobs.
Azure runbooks are used for automating tasks and processes, but they are a general automation tool and not specifically designed for migrating or hosting SQL Server Agent jobs directly.
Elastic Database jobs are designed for executing T-SQL scripts across a group of Azure SQL databases, not for managing or migrating single-instance SQL Server Agent jobs.
Concept tested: SQL Server Agent job migration
Source: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/sql-server-agent-managed-instance
Topics
Community Discussion
No community discussion yet for this question.