| 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 |
| 11 | How would you write a T-SQL script that combines variables, control flow, and error handling together to perform a robust, multi step administrative task? SQL Server › T-SQL Fundamentals & Syntax | SQL Server | T-SQL Fundamentals & Syntax | Advanced |
| 12 | How do you automate regular backups in SQL Server so they run consistently without manual effort? SQL Server › Backup & Recovery | SQL Server | Backup & Recovery | Intermediate |
| 13 | How often does a full text index need to be updated to reflect changes made to the underlying table's data? SQL Server › Full Text Search | SQL Server | Full Text Search | Intermediate |
| 14 | How do you monitor the health and latency of a transactional replication setup to ensure subscribers are staying reasonably up to date? SQL Server › Replication | SQL Server | Replication | Intermediate |
| 15 | How do you verify that a backup file is not corrupted and can actually be restored successfully? SQL Server › Backup & Recovery | SQL Server | Backup & Recovery | Advanced |
| 16 | How would you use Change Data Capture to build a near real time data synchronization pipeline between an operational database and a data warehouse? SQL Server › Change Data Capture (CDC) | SQL Server | Change Data Capture (CDC) | Advanced |
| 17 | In what rare situations might using a cursor still be a reasonable choice despite the general recommendation to avoid them? SQL Server › Cursors | SQL Server | Cursors | Advanced |
| 18 | How does index fragmentation happen over time, and how do you address it? SQL Server › Indexes | SQL Server | Indexes | Advanced |
| 19 | How would you troubleshoot a transactional replication setup where a subscriber has stopped receiving new changes entirely? SQL Server › Replication | SQL Server | Replication | Advanced |