Multiple choice technology databases

How does Teradata handle data distribution when performing system configuration changes

  1. Creates an output map to aid in redistributing data

  2. Data distribution is automatic

  3. Creates a reconfig map to help the DBA repartition data

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

During system reconfiguration (adding/removing AMPs), Teradata creates a reconfiguration map that guides data redistribution. This map helps DBAs understand how data moves between AMPs.

AI explanation

When Teradata's system configuration changes (e.g., AMPs added or removed), data is not redistributed automatically. The DBA must run the Reconfiguration utility, which creates a reconfig map describing how rows should move to the new configuration, and then uses that map to physically repartition the data across the system.

Keep practicing — related questions