You are creating a Windows application by using the .NET Framework 3.5.
The application has the following specifications:
It uses a centralized Microsoft SQL Server 2008 database instance.
It is deployed to several computers within the network.
It retrieves and updates the records of the Customer table.
A customer record can exist on multiple forms within the application. Users log on to the application by
using their unique user ID. You implement optimistic concurrency on the Customer table.
You need to design a strategy to detect conflicts by using minimum amount of network bandwidth.
What should you do?
A.
Detect conflicts by using all the columns of the Customer table.
B.
Detect conflicts by using the primary key column of the Customer table.
C.
Create a column to save a GUID to the Customer table. Then, detect conflicts by using the GUID.
D.
Create a new column to save the user ID in the Customer table. Then, detect conflicts by using the user ID.