SSIS and Bulk Copy Quiz

Self-assessment: one point per question, five points total. Answers are not submitted, saved, or automatically graded. Compare your choices with the explanation page.

1. Which tool is run in an operating-system terminal?

A. bcp

B. BULK INSERT

C. CREATE TABLE

2. Which bcp direction exports a query result?

A. in

B. queryout

C. format

3. Does bulk loading always bypass transaction logging?

A. Yes

B. No

4. Where does bcp access its data file?

A. On the machine running bcp

B. Always on the database server

5. What should you do before repeating a failed append?

A. Run it again immediately

B. Reconcile committed and rejected rows

Review answers and explanations.