How would you use Change Data Capture to build a near real time data synchronization pipeline between an operational database and a data warehouse?

You would schedule a job that periodically queries the CDC change functions for each tracked table since the last successful run, apply those specific inserted, updated, and deleted rows to your data warehouse tables, and keep track of the last processed log sequence number so each run only picks up genuinely new changes.

-- Store the last processed LSN and use it as the starting point
-- for the next scheduled synchronization run
SELECT * FROM cdc.fn_cdc_get_net_changes_dbo_Orders(@last_lsn, @current_lsn, 'all');