Microsoft
70-518 · Question #193
You are modifying an existing Windows Presentation Foundation (WPF) application that uses .NET Framework 4. The WPF application uses a wizard to capture data and insert the data into a database. The…
The correct answer is D. Insert all captured data in a single transaction when the user completes the wizard. See the full explanation below for the reasoning.
Question
You are modifying an existing Windows Presentation Foundation (WPF) application that uses .NET Framework 4. The WPF application uses a wizard to capture data and insert the data into a database. The database includes one parent table and many child tables. Inserting captured data in the database locks many database tables and delays application access. You have the following requirements:
- Reduce delays when saving data.
- Ensure that other application users are not blocked from reading
data.
- Ensure that captured data is available only after all child tables
are updated. You need to recommend an approach for inserting captured data into the database. What should you recommend?
Options
- AInsert captured data by using optimistic concurrency as the user completes each wizard page.
- BInsert captured data by using a single transaction as the user completes each wizard page.
- CInsert captured data by using non-transactional operations when the user completes the
- DInsert all captured data in a single transaction when the user completes the wizard.
How the community answered
(47 responses)- A9% (4)
- B4% (2)
- C17% (8)
- D70% (33)
Community Discussion
No community discussion yet for this question.