Multiple choice technology databases

Error capturing is done by these utilities:

  1. BTEQ

  2. FASTLOAD

  3. MULTILOAD

  4. FASTEXPORT

  5. TPUMP
Reveal answer Fill a bubble to check yourself
B,C,E Correct answer
Explanation

FASTLOAD, MULTILOAD, and TPUMP are Teradata utilities with error capture mechanisms. FASTLOAD captures errors in error tables, MULTILOAD has error tables for each phase, and TPUMP logs errors. BTEQ and FASTEXPORT don't have structured error capture.

AI explanation

Teradata's FastLoad, MultiLoad, and TPump utilities all support error capturing: rows that fail to load (due to constraint violations, data type mismatches, duplicate rows, etc.) are diverted into error tables (e.g., the UV/ET error tables) rather than aborting the whole load. BTEQ is a general-purpose query/batch tool without this dedicated error-table mechanism, and FastExport only extracts data from Teradata (it doesn't load, so there's nothing to capture load errors for). Hence FastLoad, MultiLoad, and TPump are correctly marked, while BTEQ and FastExport are not.

Keep practicing — related questions