PrepAway - Latest Free Exam Questions & Answers

Which method should you use ?

You create an application by using Microsoft Visual Studio .NET 2008 and the .NET Framework 3.5. The application includes a server component that receives DataTable objects from client components. Each DataTable object contains approximately 2,500,000 rows. The server component must load new and updated records from the DataTable objects into a table in a Microsoft SQL Server 2005 database. The schemas of the database table and the DataTable objects are identical. The database is located on a different server than the application server component. You need to identify a method that provides the best performance to load the data into the database table. Which method should you use ?

PrepAway - Latest Free Exam Questions & Answers

A.
Use the bcp utility.

B.
Use a SqlBulkCopy object.

C.
Use the BULK INSERT statement.

D.
Use a parameterized stored procedure.


Leave a Reply