Teradata Cheat Sheet 2026

The 30 highest-yield Teradata facts, distilled from real exam questions. Print it, save it as a PDF, or study it here — free, no sign-up.

1. What is a star schema in the context of Teradata data warehousing? → A design with a central fact table surrounded by denormalized dimension tables
2. Which Teradata feature enables rolling window partitioning by automatically deleting the oldest partition and adding a new one? → Rolling partition maintenance via ALTER TABLE MODIFY
3. Which Teradata component is responsible for storing and retrieving data on disk? → Access Module Processor (AMP)
4. What is the purpose of a Derived Table in a Teradata SQL query? → A temporary result set defined in a subquery within the FROM clause
5. What does the Teradata 'NORMALIZE' clause do when applied to a table of time periods? → Merges overlapping or adjacent time periods into a single contiguous row
6. In Teradata, what is a 'volatile table'? → A temporary table that exists only for the duration of a user session
7. In Teradata Workload Management, what does a Workload Definition (TDWM) primarily control? → Resource allocation and priority for queries based on classification criteria
8. In Teradata, what does a Derived Table refer to? → A subquery in the FROM clause used as a temporary result set
9. Which Teradata feature allows multiple range conditions on different columns to be combined for partition elimination? → Multi-Level Partitioning (MLPPI)
10. In Teradata, what is the purpose of the Viewpoint portal? → A web-based monitoring and management interface for Teradata systems
11. Which Teradata SQL window function assigns a unique sequential number to each row within a partition? → ROW_NUMBER()
12. Which Teradata load utility is best suited for initial bulk loading of an empty table? → FastLoad
13. What is a Multiset table in Teradata? → A table that allows duplicate rows
14. In Teradata, what is a spool space and what happens when it runs out? → Temporary disk space for intermediate query results; query fails with a spool space error
15. How many nodes can Teradata support in a single system at the most? → 100,000 nodes
16. What is the Teradata TDLOAD utility primarily used for? → A command-line interface for TPT that simplifies load job creation without scripting
17. Which Teradata component is employed for workload management and monitoring? → Teradata Workload Manager
18. What is a Primary Index in Teradata and why is it important? → It determines data distribution across AMPs and is critical for query performance
19. Which Teradata view provides real-time information about currently running queries and their AMPs usage? → DBC.SessionInfoV
20. What is the role of the Parsing Engine (PE) in Teradata? → It parses SQL, optimizes queries, and dispatches work to AMPs
21. What is the role of the BYNET in a Teradata MPP system? → Provides high-speed interconnect for communication between nodes
22. Which Teradata feature allows a table to be automatically replicated across multiple AMPs for small lookup tables? → Fallback Protection
23. What is the BYNET in Teradata architecture? → The high-speed interconnect network between nodes that carries all inter-AMP communication
24. In Teradata, what is row partitioning by date used for in a data warehouse? → Enables partition elimination so queries with date filters scan only relevant partitions
25. Because of _____, a uniqueness value is necessary to provide a unique Row ID. → Both Answers
26. Which SQL command in Teradata is used to remove all rows from a table without logging individual row deletions? → TRUNCATE TABLE
27. What is the maximum number of characters for a VARCHAR column in Teradata? → 32000
28. What is the function of the .SET TITLEDASHES command in BTEQ? → Controls whether dashes are printed under column headings in BTEQ output
29. Which Teradata feature allows a single query to be automatically routed to the best-performing node in a multi-system environment? → Unity Director
30. What does the Teradata Data Dictionary contain? → Metadata about all database objects such as tables, views, users, and indexes