Microsoft · DP-300
Elastic jobs and Azure automation
DP-300 · Lesson 18 of 22 · 2:38:19
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the DP-300 exam (Administering Microsoft Azure SQL Solutions). In this lesson: elastic jobs across many Azure SQL databases (job agent, job database, target groups, managed identity, schedules, and retries), Azure Automation runbooks and hybrid workers, Azure Monitor alerts and action groups, and troubleshooting job executions. Includes three original practice questions.
Preview the topics
- Contoso adds new partner databases to the same logical server every week, and its weekly elastic job must cover them all, without editing the job. How should the target group be defined?
- Contoso wants its loyalty database to scale up to eight vCores every month-end evening, and back down two days later, without anyone signing in. What should it use?
- A Contoso elastic job that targets a whole server never reaches any database, and its executions show a sign-in failure on the server’s master database. The identity has users in every partner database. What’s missing?