Database Fundamentals — Question 161

Adam works as a Database Designer for DataOne Inc.
The company has a SQL Server database. Adam has to ensure that either all the databases are updated or none of them are updated, so that the databases remain synchronized.
Which of the following will he use to accomplish the task?

Answer options

• A. Native auditing
• B. Two-phase commit
• C. Encryption
• D. Concurrency control

Correct answer: B

Explanation

The correct answer is B, Two-phase commit, as it is specifically designed to ensure that all transactions across distributed databases either complete successfully or fail entirely, maintaining synchronization. Options A (Native auditing) and C (Encryption) do not address transaction consistency, while D (Concurrency control) deals with managing simultaneous operations rather than ensuring all-or-nothing updates.