| 1 | What security considerations should be kept in mind when configuring the account that SQL Server Agent jobs run under? SQL Server › SQL Server Agent & Job Scheduling | SQL Server | SQL Server Agent & Job Scheduling | Intermediate |
| 2 | How do you monitor and troubleshoot SQL Server Agent job performance and failures across an entire server with many scheduled jobs? SQL Server › SQL Server Agent & Job Scheduling | SQL Server | SQL Server Agent & Job Scheduling | Advanced |
| 3 | How do you create a basic SQL Server Agent job that runs a T-SQL script on a defined schedule? SQL Server › SQL Server Agent & Job Scheduling | SQL Server | SQL Server Agent & Job Scheduling | Beginner |
| 4 | How do you configure a SQL Server Agent job to send an email alert if it fails? SQL Server › SQL Server Agent & Job Scheduling | SQL Server | SQL Server Agent & Job Scheduling | Intermediate |
| 5 | How would you design a complex SQL Server Agent job with multiple steps that need to run conditionally based on the success or failure of previous steps? SQL Server › SQL Server Agent & Job Scheduling | SQL Server | SQL Server Agent & Job Scheduling | Advanced |
| 6 | What is SQL Server Agent, and what kinds of tasks is it typically used to automate? SQL Server › SQL Server Agent & Job Scheduling | SQL Server | SQL Server Agent & Job Scheduling | Beginner |
| 7 | How do you configure a job step to automatically retry if it fails, rather than immediately marking the entire job as failed? SQL Server › SQL Server Agent & Job Scheduling | SQL Server | SQL Server Agent & Job Scheduling | Intermediate |
| 8 | What are the main components that make up the SQL Server architecture, and what role does each one play? SQL Server › SQL Server Architecture & Editions | SQL Server | SQL Server Architecture & Editions | Beginner |
| 9 | How do you properly stop and clean up an Extended Events session once it is no longer needed? SQL Server › SQL Server Profiler & Extended Events | SQL Server | SQL Server Profiler & Extended Events | Intermediate |
| 10 | What are alternatives to linked servers for integrating data from multiple different database systems, and when might they be a better choice? SQL Server › Linked Servers | SQL Server | Linked Servers | Advanced |