Teradata Random 2

Question 1

Which Teradata feature allows a table to be automatically replicated across multiple AMPs for small lookup tables?

Accepted Answer

Fallback Protection

Answer

Fallback Protection replicates each row on a second AMP, ensuring availability if one AMP fails.

Question 2

What does the Teradata EXPLAIN command return?

Accepted Answer

The execution plan the optimizer intends to use

Answer

EXPLAIN returns the optimizer's step-by-step plan for executing a query, without actually running it.

Question 3

In Teradata, what is the purpose of the COLLECT STATISTICS statement?

Accepted Answer

To gather demographic data about columns for the optimizer

Answer

COLLECT STATISTICS gathers column and index demographics stored in the data dictionary to help the optimizer build efficient query plans.

Question 4

Which locking level in Teradata is the most granular?

Accepted Answer

Row Hash

Answer

Row Hash locking is the most granular level, locking only rows with the same hash value rather than the entire table.

Question 5

What happens when Teradata encounters a skewed PI column during data loading?

Accepted Answer

Some AMPs receive disproportionately more rows, causing performance issues

Answer

A skewed PI results in uneven AMP workload distribution, where some AMPs have far more data than others, degrading query performance.

Teradata Practice Test