70-465 Question #87: 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 continuously synchronize and copy data changes from one operational database to another, Transactional Replication is the correct configuration.

Common mistakes.

• B. Database Mirroring is primarily a high-availability and disaster recovery solution, providing a hot standby database for failover rather than an independent, accessible synchronized copy for another application.
• C. Snapshot Replication is suitable for data that changes infrequently, as it transfers a complete copy of the data at regular intervals, which is inefficient and has higher latency for continuous synchronization of frequently changing data.
• D. Incremental Backups are used for disaster recovery and restoring a database to a specific point in time, not for providing ongoing, real-time data synchronization between two active operational databases for an application.

Concept tested. SQL Server Replication Types and Use Cases

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

No community discussion yet for this question.