Microsoft
70-354 · Question #39
You are developing a Universal Windows Platform (UWP) app that will retrieve data from a Microsoft Azure SQL Database. The app will be used by multiple users simultaneously. You need to ensure that…
The correct answer is A. Add a column named TimeStamp that contains the last date the row was modified. See the full explanation below for the reasoning.
Question
You are developing a Universal Windows Platform (UWP) app that will retrieve data from a Microsoft Azure SQL Database. The app will be used by multiple users simultaneously. You need to ensure that the app can use optimistic concurrency. What should you do?
Options
- AAdd a column named TimeStamp that contains the last date the row was modified.
- BWhen data is accessed, set the transaction isolation level to ReadCommitted.
- CWhen data is accessed, set the transaction isolation level to ReadUncommitted.
- DAdd a column of the Boolean type named Lock that will be set to true when a user reads the row.
How the community answered
(61 responses)- A79% (48)
- B3% (2)
- C7% (4)
- D11% (7)
Community Discussion
No community discussion yet for this question.