You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties at Domain.com include importing data into SQL Server 2005 databases. A Domain.com user named Amy Wilson is a member of the Sales department. You have received numerous text files that contain the sales transactions from various stores across the country. The data are separated by semicolons in columns. You instruct Amy Wilson to import the files into the sales database.
What should she do?
A.
In order to import the files into the sales database Amy Wilson needs to use the BULK INSERT statement with the default arguments.
B.
Amy Wilson needs to create a custom format file.
She also needs to specify a semicolon as the row terminator.
C.
The bcp command needs to be used and Amy Wilson should specify a semicolon as the field terminator.
D.
In order to import the files into the sales database Amy Wilson needs to use the bcp command with the default arguments.
Explanation:
The bcp utility bulk copies data between an instance of Microsoft SQL Server 2005 and a data file in a user-specified format. The bcp utility can be used to import large numbers of new rows into SQL Server tables or to export data out of tables into data files. To import data into a table, you must either use a format file created for that table or understand the structure of the table and the types of data that are valid for its columns.