Teradata Teradata MCQ 2 — Questions and Answers
Question 1: Which Teradata utility is used to load large volumes of data into an empty table with maximum performance?
- FastLoad (Correct answer)
- MultiLoad
- BTEQ
- FastExport
Correct answer: FastLoad
FastLoad is optimized for bulk loading into empty tables by bypassing the transient journal for maximum throughput.
Question 2: What does the EXPLAIN plan in Teradata primarily show?
- The execution strategy chosen by the optimizer (Correct answer)
- The number of rows affected by a DML
- The index definitions on a table
- The session-level settings for a query
Correct answer: The execution strategy chosen by the optimizer
EXPLAIN displays the step-by-step execution plan that the Teradata Query Optimizer has chosen for a SQL statement.
Question 3: In Teradata, what is a 'fallback' table?
- A table with a duplicate copy of each row on a different AMP (Correct answer)
- A backup table stored on a secondary disk array
- A temporary table used during query processing
- A table with a secondary index defined
Correct answer: A table with a duplicate copy of each row on a different AMP
Fallback protection stores a duplicate of every row on a different AMP so data remains accessible if one AMP fails.
Question 4: Which SQL command in Teradata is used to remove all rows from a table without logging individual row deletions?
- DELETE ALL
- TRUNCATE TABLE (Correct answer)
- DROP TABLE
- DELETE FROM without WHERE
Correct answer: TRUNCATE TABLE
TRUNCATE TABLE removes all rows quickly without logging each deletion, making it faster than a full DELETE.
Question 5: What is the purpose of the Teradata 'COLLECT STATISTICS' command?
- To gather demographic data about column values for the optimizer (Correct answer)
- To archive query history to disk
- To update the WAL log with table statistics
- To compress table blocks for storage efficiency
Correct answer: To gather demographic data about column values for the optimizer
COLLECT STATISTICS gathers demographic information about column data distributions so the optimizer can build more efficient query plans.
Question 6: In Teradata, what is a 'volatile table'?
- A temporary table that exists only for the duration of a user session (Correct answer)
- A table stored in RAM instead of disk
- A table with automatic row expiration
- A table that cannot be backed up
Correct answer: A temporary table that exists only for the duration of a user session
Volatile tables are session-scoped temporary tables automatically dropped when the session ends.
Question 7: Which Teradata feature allows a single query to be automatically routed to the best-performing node in a multi-system environment?
- Teradata QueryGrid
- Active System Management (TASM)
- Teradata Parallel Transporter (TPT)
- Unity Director (Correct answer)
Correct answer: Unity Director
Unity Director provides transparent workload routing across multiple Teradata systems, directing queries to the optimal system automatically.
Teradata Teradata MCQ 2
Which Teradata utility is used to load large volumes of data into an empty table with maximum performance?