Teradata Teradata Architecture

Question 1

What is the primary component in Teradata architecture that manages parsing and optimizing SQL queries?

Accepted Answer

Parsing Engine (PE)

Answer

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?

Accepted Answer

Provides high-speed communication between nodes

Answer

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?

Accepted Answer

Access Module Processor (AMP)

Answer

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?

Accepted Answer

The hash value of the Primary Index

Answer

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?

Accepted Answer

A virtual processor that maps to either a PE or AMP

Answer

A Vproc (virtual processor) is a software process in Teradata that functions as either a Parsing Engine or an AMP, mapped to physical hardware.

Teradata Practice Test