You create Web-based client applications. You are creating a component that sends the data that is generated by regional offices to a remote server that is located at the central office. Each regional office generates thousands of orders every week. This data is stored on several tables in an instance of Microsoft SQL Server that is located at the regional office. The manager at the regional office reviews all orders and modifies them, if necessary, before inserting them into the database at the central office.
You need to ensure that the component meets the following requirements:
The manager has the option of reviewing and modifying the orders offline. The data from a regional office is copied to the server that is located at the central office in as short a time as possible.
Which option should you use?
A.
a DataSet object and a SqlBulkCopy object
B.
an SqlCommand object that uses a T-SQL statement
C.
a DataSet object that uses a T-SQL statement
D.
a DataTableReader object and a SqlBulkCopy object