Module reference
SSIS and Bulk Copy Quiz: Explanations
1. Which tool is run in an operating-system terminal?
Answer A. bcp is a command-line utility; the other choices are SQL statements.
2. Which bcp direction exports a query result?
Answer B. queryout writes the rows returned by a query.
3. Does bulk loading always bypass transaction logging?
Answer B. Logging depends on the operation and its prerequisites. Minimal logging is not zero logging.
4. Where does bcp access its data file?
Answer A. The bcp process reads or writes the file on its own machine.
5. What should you do before repeating a failed append?
Answer B. A partial load can leave rows that would be duplicated by an uncontrolled retry.