Developing Microsoft SQL Server Databases — Question 42

You need to recommend a solution to ensure that SQL1 supports the auditing requirements of usp_UpdateSpeakerName.
What should you include in the recommendation?

Answer options

• A. The Distributed Transaction Coordinator (DTC)
• B. Transactional replication
• C. Change data capture
• D. Change tracking

Correct answer: A

Explanation

The Distributed Transaction Coordinator (DTC) is essential for managing transactions that span multiple resources, ensuring that auditing requirements are met during updates. Transactional replication, Change data capture, and Change tracking do not specifically address the need for coordinated transaction management across different systems, which is why they are not the correct solutions in this scenario.