Teradata Random 4

Question 1

What is the role of the BYNET in a Teradata MPP system?

Accepted Answer

Provides high-speed interconnect for communication between nodes

Answer

The BYNET is Teradata's proprietary high-speed interconnect network that enables AMPs and PEs on different nodes to communicate and exchange data.

Question 2

In Teradata, what distinguishes a SET table from a MULTISET table?

Accepted Answer

SET tables reject exact duplicate rows; MULTISET tables allow them

Answer

A SET table automatically eliminates exact duplicate rows on insert, while a MULTISET table allows complete duplicate rows.

Question 3

Which Teradata utility supports concurrent DML operations (INSERT, UPDATE, DELETE) on populated tables with minimal locking?

Accepted Answer

TPump

Answer

TPump (Teradata Parallel Data Pump) is designed for continuous low-volume DML on active tables with fine-grained row-hash locking to minimize contention.

Question 4

What is a Teradata Volatile Table and when is it dropped?

Accepted Answer

A temporary table that exists only for the duration of the user session

Answer

A Volatile Table is a session-scoped temporary table automatically dropped when the user session ends.

Question 5

Which Teradata access right allows a user to SELECT from a table but not modify it?

Accepted Answer

SELECT

Answer

The SELECT privilege grants read-only access, allowing a user to query rows from a table without any ability to modify data.

Teradata Practice Test

Teradata Practice Test

Teradata Random 4