More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
You are looking to import a large amount of data from a remote OLEDB data source that is not a text file. Which of the following techniques can you use?
Answer
Use the select * from OPENROWSET(BULK...) command.
Explanation
SQL Server 2005 includes a new option with the OPENROWSET command for getting large amounts of data from an OLEDB data source. It is the BULK option and works similar to the BULK INSERT command.
(Continued on next question...)