nerdexam
Microsoft

98-364 · Question #66

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…

The correct answer is B. Two-phase commit. See the full explanation below for the reasoning.

Question

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?

Options

  • ANative auditing
  • BTwo-phase commit
  • CEncryption
  • DConcurrency control

How the community answered

(23 responses)
  • A
    4% (1)
  • B
    74% (17)
  • C
    17% (4)
  • D
    4% (1)

Community Discussion

No community discussion yet for this question.

Full 98-364 Practice