Multiple choice technology databases

The rows of every table are distributed among all AMPs

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In Teradata, all table rows are distributed across every AMP in the system. The Primary Index hash determines which AMP gets each row, but the distribution is always across all available AMPs. This fundamental parallelism enables Teradata's scalability.

AI explanation

In Teradata's architecture, each table's rows are distributed across all AMPs (Access Module Processors) in the system based on a hash of the table's Primary Index. This parallel distribution is the core design principle enabling Teradata's parallelism, so under normal circumstances every table's rows are spread across all AMPs.

Keep practicing — related questions