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?
A.
Insert captured data by using optimistic concurrency as the user completes each wizard
page.
B.
Insert captured data by using a single transaction as the user completes each wizard
page.
C.
Insert captured data by using non-transactional operations when the user completes the
wizard.
D.
Insert all captured data in a single transaction when the user completes the wizard.