Query-Based CDC and Its Limitations

Query-based CDC is the naive approach that most candidates propose first. It works by querying for rows where updated_at > last_run_time. It is simple to implement but has fundamental limitations that the interviewer will probe. The Three Failures of Query-Based CDC When Query-Based CDC Is Acceptable