Microsoft
70-518 · Question #188
You are analyzing a Windows client application that uses Microsoft Visual Studio 2010 and Microsoft SQL Server 2008. The application updates two database tables from the main user interface (UI)…
The correct answer is B. Move the database update logic to a BackgroundWorker thread. See the full explanation below for the reasoning.
Question
You are analyzing a Windows client application that uses Microsoft Visual Studio 2010 and Microsoft SQL Server 2008. The application updates two database tables from the main user interface (UI) thread. You need to ensure that the following requirements are met:
- The database tables are either updated simultaneously or not updated
at all.
- Users are notified of the success or failure of the updates.
- Users are able to perform other tasks during the update process.
What should you do?
Options
- AUse TransactionScope in a using block on the UI thread.
- BMove the database update logic to a BackgroundWorker thread.
- CUse TransactionScope in a using block on the main thread.
- DUse TransactionScope in a using block on the UI thread.
How the community answered
(13 responses)- B77% (10)
- C8% (1)
- D15% (2)
Community Discussion
No community discussion yet for this question.