Teradata Certified Design Architect V2R5

When might the Fast Export and FastLoad utilities be used as a backup/recovery approach?
A - 300 large static tables
B - 20 small volatile tables
C - 20 small static tables
D - 300 large volatile tables

Correct: C


Which two statements are true about a dimensional data model? (Choose two)
A - It often implements fewer tables.
B - It is extremely flexible.
C - It requires significantly less ETL activity.
D - It reduces the need for summary tables.
E - It can be adopted to optimize performance.

Correct: A,E


When would you use identity columns? (Choose two)
A - when more even data distribution is needed
B - to reduce the need to generate keys outside of Teradata
C - when users need key values with hidden significance of intelligence
D - to facilitate moving applications from other systems to Teradata

Correct: A,B,D