Microsoft
70-355 · Question #36
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 readsthe row.
How the community answered
(35 responses)- A74% (26)
- B6% (2)
- C6% (2)
- D14% (5)
Community Discussion
No community discussion yet for this question.