Teradata Teradata Architecture 1 — Questions and Answers
Question 1: What is the primary component in Teradata architecture that manages parsing and optimizing SQL queries?
- Parsing Engine (PE) (Correct answer)
- Access Module Processor (AMP)
- BYNET
- Vproc
Correct answer: Parsing Engine (PE)
The Parsing Engine receives SQL requests, parses them, optimizes the query plan, and dispatches tasks to the AMPs.
Question 2: What is the role of the BYNET in a Teradata system?
- Provides high-speed communication between nodes (Correct answer)
- Stores metadata about tables
- Manages disk I/O for AMPs
- Controls user authentication
Correct answer: Provides high-speed communication between nodes
BYNET is Teradata's high-speed interconnect that enables communication between Parsing Engines and AMPs across nodes.
Question 3: Which Teradata component is responsible for storing and retrieving data on disk?
- Access Module Processor (AMP) (Correct answer)
- Parsing Engine (PE)
- BYNET
- Gateway
Correct answer: Access Module Processor (AMP)
AMPs manage the physical storage of data on disk and perform all data retrieval, sorting, and aggregation operations.
Question 4: In Teradata, what determines which AMP stores a particular row of data?
- The hash value of the Primary Index (Correct answer)
- The row creation timestamp
- The table name length
- The user session ID
Correct answer: The hash value of the Primary Index
Teradata applies a hashing algorithm to the Primary Index value of each row to determine which AMP will store that row.
Question 5: What is a Vproc in Teradata architecture?
- A virtual processor that maps to either a PE or AMP (Correct answer)
- A physical CPU core
- A network interface card
- A disk partition
Correct answer: A virtual processor that maps to either a PE or AMP
A Vproc (virtual processor) is a software process in Teradata that functions as either a Parsing Engine or an AMP, mapped to physical hardware.
Question 6: Which Teradata feature allows multiple hardware nodes to work together as a single logical system?
- Massively Parallel Processing (MPP) (Correct answer)
- Symmetric Multi-Processing (SMP)
- RAID striping
- Federation
Correct answer: Massively Parallel Processing (MPP)
Teradata's MPP architecture links multiple nodes together so they operate as one unified system with shared workloads.
Teradata Teradata Architecture 1
What is the primary component in Teradata architecture that manages parsing and optimizing SQL queries?