Multiple choice technology databases

Teradata components handle data distribution by

  1. AMP bucket number

  2. Primary Index

  3. Primary Key

  4. None of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Teradata uses the Primary Index (PI) to distribute data across AMPs. The PI value is hashed to determine which AMP will store each row. The Primary Key is a logical concept for uniqueness, while the PI is the physical distribution mechanism.

Keep practicing — related questions