You are creating a Windows application that processes sales orders by using the .NET Framework 3.5.
The application has the following specifications:
It connects to a Microsoft SQL Server 2008 database.
It retrieves data from a table named Products.
The product table has three columns named Name, Description, and Quantity. The application uses the
Name and Description columns as lookup fields. It updates the Quantity column when orders are placed.
You need to design a concurrency management strategy that meets the following requirements:
Data integrity is maintained during the update process.
Database locking for the lookup data is minimal.
What should you do?
A.
Implement optimistic concurrency on the Products table.
B.
Implement pessimistic concurrency on the Products table.
C.
Split the Products table into two different tables named Product_Data and Product_Quantity. Ensure
that the Product_Data table contains the name and description of the product. Ensure that the
Product_Quantity table contains the quantity details of the product. Implement pessimistic concurrency on
the Product_Data table.
D.
Split the Products table into two different tables named Product_Data and Product_Quantity. Ensure
that the Product_Data table contains the name and description of the product. Ensure that the
Product_Quantity table contains the quantity details of the product. Implement pessimistic concurrency on
the Product_Quantity table.