Teradata Teradata Utilities

Question 1

What is the primary purpose of the BTEQ (Basic Teradata Query) utility?

Accepted Answer

Submits SQL and procedural commands to Teradata and formats output for reports

Answer

Loads large flat files in parallel using multi-session inserts

Answer

Exports data to binary flat files

Answer

Checks Teradata system health

Question 2

Which Teradata load utility is best suited for initial bulk loading of an empty table?

Accepted Answer

FastLoad

Answer

MultiLoad

Answer

TPT (Teradata Parallel Transporter)

Answer

BTEQ INSERT

Question 3

What is the key advantage of MultiLoad over FastLoad in Teradata?

Accepted Answer

MultiLoad supports DML operations (INSERT, UPDATE, DELETE, UPSERT) on non-empty tables

Answer

MultiLoad is faster than FastLoad for initial loads

Answer

MultiLoad works without requiring a Primary Index

Answer

MultiLoad supports loading directly into views

Question 4

What does TPT (Teradata Parallel Transporter) provide that individual utilities like FastLoad and MultiLoad do not?

Accepted Answer

A unified, scriptable framework combining load, export, and transformation operators in one job

Answer

A GUI-based drag-and-drop interface for data loading

Answer

Faster single-session row insert performance

Answer

Native integration with Hadoop HDFS

Question 5

In Teradata's FastLoad process, what must be true about the target table before loading begins?

Accepted Answer

The table must be empty and have no secondary indexes or join indexes

Answer

The table must have fallback enabled

Answer

The table must be defined as a volatile table

Answer

The table must have at least one partition defined

Question 6

What is the purpose of the TDMS (Teradata Data Mover) utility?

Accepted Answer

Copies objects and data between Teradata systems with high performance

Answer

Monitors active queries on a Teradata node

Answer

Migrates users and roles between databases

Answer

Generates CREATE TABLE scripts from existing tables