| 1 | How do you enable Change Data Capture on a specific table, and what does that process actually create? SQL Server › Change Data Capture (CDC) | SQL Server | Change Data Capture (CDC) | Intermediate |
| 2 | How do you query the change data captured for a table to find out exactly what changed within a specific time range? SQL Server › Change Data Capture (CDC) | SQL Server | Change Data Capture (CDC) | Intermediate |
| 3 | What is Change Data Capture in SQL Server, and what problem does it solve? SQL Server › Change Data Capture (CDC) | SQL Server | Change Data Capture (CDC) | Beginner |
| 4 | How is Change Data Capture different from using triggers to track changes to a table? SQL Server › Change Data Capture (CDC) | SQL Server | Change Data Capture (CDC) | Intermediate |
| 5 | How do you disable Change Data Capture on a table or an entire database once it is no longer needed? SQL Server › Change Data Capture (CDC) | SQL Server | Change Data Capture (CDC) | Intermediate |
| 6 | 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 |
| 7 | What are the performance and storage considerations to keep in mind before enabling Change Data Capture on a very high volume table? SQL Server › Change Data Capture (CDC) | SQL Server | Change Data Capture (CDC) | Advanced |
| 8 | How do you use the OUTPUT clause together with a MERGE statement to capture which rows were inserted, updated, or deleted? SQL Server › Merge Statement (Upsert) | SQL Server | Merge Statement (Upsert) | Intermediate |
| 9 | What are the three main types of replication in SQL Server, and how do they differ? SQL Server › Replication | SQL Server | Replication | Beginner |
| 10 | What is a trigger in SQL Server, and what kinds of events can cause one to run automatically? SQL Server › Triggers | SQL Server | Triggers | Beginner |
| 11 | How do you access the old and new values of a row that was just updated from inside a trigger? SQL Server › Triggers | SQL Server | Triggers | Intermediate |
| 12 | What are some alternatives to using a trigger for tasks like auditing or enforcing business rules, and when might those alternatives be preferable? SQL Server › Triggers | SQL Server | Triggers | Intermediate |
| 13 | What are the performance implications of using triggers heavily on a busy, high transaction volume table? SQL Server › Triggers | SQL Server | Triggers | Advanced |