Microsoft
70-518 · Question #141
70-518 Question #141: Real Exam Question with Answer & Explanation
Sign in or unlock 70-518 to reveal the answer and full explanation for question #141. The question stem and answer options stay visible for context.
Question
You are designing the data access layer (DAL) for an application that uses Microsoft SQL Server 2008, Microsoft ADO.NET, and Microsoft Visual Studio 2010. Conflicts are occurring in the SQL Server database due to concurrent updates. You need to design a database locking strategy that meets the following requirements: - Resolves concurrent update conflicts without loss of data - Ensures that data conflicts can be resolved by users - Locks only the data necessary for updates What should you do?
Options
- AUse optimistic locking.
- BUse pessimistic locking.
- CUse pessimistic locking.
- DUse optimistic locking.
Unlock 70-518 to see the answer
You've previewed enough free 70-518 questions. Unlock 70-518 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.