Teradata Teradata Utilities 1 — Questions and Answers
Question 1: What is the primary purpose of the BTEQ (Basic Teradata Query) utility?
- Submits SQL and procedural commands to Teradata and formats output for reports (Correct answer)
- Loads large flat files in parallel using multi-session inserts
- Exports data to binary flat files
- Checks Teradata system health
Correct answer: Submits SQL and procedural commands to Teradata and formats output for reports
BTEQ is a general-purpose command-line utility for submitting SQL, DDL, and DCL statements to Teradata and formatting query results for scripts and reports.
Question 2: Which Teradata load utility is best suited for initial bulk loading of an empty table?
- FastLoad (Correct answer)
- MultiLoad
- TPT (Teradata Parallel Transporter)
- BTEQ INSERT
Correct answer: FastLoad
FastLoad uses multiple parallel sessions to load data into an empty table at very high speed by bypassing the transient journal.
Question 3: What is the key advantage of MultiLoad over FastLoad in Teradata?
- MultiLoad supports DML operations (INSERT, UPDATE, DELETE, UPSERT) on non-empty tables (Correct answer)
- MultiLoad is faster than FastLoad for initial loads
- MultiLoad works without requiring a Primary Index
- MultiLoad supports loading directly into views
Correct answer: MultiLoad supports DML operations (INSERT, UPDATE, DELETE, UPSERT) on non-empty tables
MultiLoad can perform multiple DML operations (INSERT, UPDATE, DELETE, UPSERT) on up to five tables simultaneously, making it suitable for maintaining large non-empty tables.
Question 4: What does TPT (Teradata Parallel Transporter) provide that individual utilities like FastLoad and MultiLoad do not?
- A unified, scriptable framework combining load, export, and transformation operators in one job (Correct answer)
- A GUI-based drag-and-drop interface for data loading
- Faster single-session row insert performance
- Native integration with Hadoop HDFS
Correct answer: A unified, scriptable framework combining load, export, and transformation operators in one job
TPT is a unified framework that encapsulates the functionality of FastLoad, MultiLoad, FastExport, and other utilities into composable operators within a single portable job script.
Question 5: In Teradata's FastLoad process, what must be true about the target table before loading begins?
- The table must be empty and have no secondary indexes or join indexes (Correct answer)
- The table must have fallback enabled
- The table must be defined as a volatile table
- The table must have at least one partition defined
Correct answer: The table must be empty and have no secondary indexes or join indexes
FastLoad requires the target table to be completely empty and have no secondary indexes or join indexes, which are dropped before the load and rebuilt afterward.
Question 6: What is the purpose of the TDMS (Teradata Data Mover) utility?
- Copies objects and data between Teradata systems with high performance (Correct answer)
- Monitors active queries on a Teradata node
- Migrates users and roles between databases
- Generates CREATE TABLE scripts from existing tables
Correct answer: Copies objects and data between Teradata systems with high performance
Teradata Data Mover copies database objects (tables, views, macros) and their data between Teradata systems, supporting migration and replication scenarios.
Teradata Teradata Utilities 1
What is the primary purpose of the BTEQ (Basic Teradata Query) utility?