You create a Windows application by using the .NET Framework 3.5.
The application connects to a Microsoft SQL Server 2008 database table named Customer to retrieve and
display customer information.
Users of the application view and modify data from the Customers table. You plan to use a DataAdapter
object and a DataSet object to retrieve data.
You need to select an appropriate concurrency strategy that maintains data integrity and scalability.
What should you do?
A.
During updates, examine only the primary key column to update the customer details.
B.
Add a time stamp column to the Customer table. During updates, examine the time stamp column to
see whether data is changed.
C.
Create a SQL transaction object that has the isolation level set to Serializable. During updates, set the
transaction object to the UpdateCommand command of the DataAdapter object.
D.
Create a SQL transaction object that has the isolation level set to RepeatableRead. Set the transaction
object to the SelectCommand command of the DataAdpater object, and then retrieve data. During
updates, set the same transaction object to the UpdateCommand command of the DataAdapter object.