exam questions

Exam 70-487 All Questions

View all questions & answers for the 70-487 exam

Exam 70-487 topic 1 question 18 discussion

Actual exam question from Microsoft's 70-487
Question #: 18
Topic #: 1
[All 70-487 Questions]

You are developing an ASP.NET MVC application that reads and writes data from a SQL Server database.
You need to maintain data integrity in all situations that use transactions.

  • A. ReadUncommitted
  • B. Repeatable
  • C. Serializable
  • D. ReadCommitted
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
The highest isolation level, serializable, guarantees that a transaction will retrieve exactly the same data every time it repeats a read operation.
References:
https://technet.microsoft.com/en-us/library/ms189122(v=sql.105)

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
swagrid1556
4 years, 5 months ago
You are developing an ASP.NET MVC application that reads and writes data from a SQL Server database. You need to maintain data integrity including retrieving identical sets across reads in all situations that use transactions. Which isolation level should you use? Answer B apparently That's on briefmenow
upvoted 1 times
swagrid1556
4 years, 5 months ago
Apologies, C serializable
upvoted 2 times
...
...
LErno
4 years, 5 months ago
What is the question here?
upvoted 2 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
Loading ...