ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 98-364 All Questions

View all questions & answers for the 98-364 exam
Go to Exam

Exam 98-364 topic 1 question 231 discussion

Actual exam question from Microsoft's 98-364
Question #: 231
Topic #: 1
[All 98-364 Questions]

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?

  • A. Native auditing
  • B. Two-phase commit
  • C. Encryption
  • D. Concurrency control
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by rogeriosolano at June 29, 2022, 12:30 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
rogeriosolano
2 years, 11 months ago
Selected Answer: B
A two-phase commit is a feature of transaction processing systems, enabling databases to be returned to the pre-transaction state if some error condition occurs. A single transaction can update many different databases. A two-phase commit strategy is designed to ensure that either all the databases are updated or none of them, so that the databases remain synchronized.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel