You need to recommend a solution to synchronize Database2 to App1_Db1. What should you recommend?

Change Data Capture (CDC) is a SQL Server feature that tracks and records data changes in a change table for auditing or ETL purposes, but it does not natively replicate or synchronize those changes to another database on its own.

Snapshot replication copies and delivers a full snapshot of the entire database at scheduled intervals rather than continuously propagating incremental changes, making it inefficient and disruptive for ongoing synchronization scenarios.

Master Data Services (MDS) is a data governance and master data management tool used to manage authoritative master data entities and their hierarchies, not a replication or database synchronization technology.

Transactional replication continuously captures changes (inserts, updates, deletes) from a publisher database and delivers them to a subscriber database, making it ideal for keeping Database2 synchronized with App1_Db1. It uses the Log Reader Agent to read the transaction log and the Distribution Agent to apply changes to the subscriber, ensuring near real-time data consistency between the two databases.