70-465 Question #80: Real Exam Question with Answer & Explanation

Question

You need to configure a synchronization solution to copy data from the Current_Inventory database the DesABCopAppDB database. What should you configure?

Options

• ATransactional Replication.
• BDatabase Mirroring.
• CSnapshot Replication.
• DIncremental Backups

Explanation

To configure a synchronization solution that copies data changes from one database to another continuously, Transactional Replication is the appropriate choice. This method ensures that data modifications are propagated with transactional consistency between the source and destination databases.

Common mistakes.

• B. Database Mirroring is primarily a high-availability solution providing a hot standby server for disaster recovery, not a flexible data synchronization method for copying data between distinct application databases.
• C. Snapshot Replication copies an entire dataset at discrete intervals and is suitable for initial data loads or infrequent changes, but not for continuous, low-latency synchronization of ongoing data modifications.
• D. Incremental Backups are a data recovery mechanism used to restore data to a previous state by saving changes since the last backup, not a solution for real-time or continuous operational data synchronization between live databases.

Concept tested. SQL Server Transactional Replication for data synchronization

Reference. https://learn.microsoft.com/en-us/sql/relational-databases/replication/transactional/transactional-replication

No community discussion yet for this question.