I have encountered the following scenario in a practice test:
- DB1 data is periodically accessed by an external application.
- Data from DB1 will be sent to another database, DB2, as soon as changes are made to the database.
data in DB1.
- All DB1 data is recreated every day and does not change before the next data creation process.
To synchronize DB1 with DB2, should you use snapshot replication or transactional replication?
Transactional replication seems fine, but snapshot replication is not appropriate, and you take a snapshot daily because the DB1 data changes only once a day.