Teradata Vantage Certified Associate — Question 36

Which type of index defined the data distribution?

Answer options

• A. Unique Secondary Index (USI)
• B. No Primary Index (NOPI)
• C. Non-unique Secondary Index (NUSI)
• D. Non-unique Primary Index (NUPI)

Correct answer: D

Explanation

The correct answer is D, as a Non-unique Primary Index (NUPI) allows for data distribution over multiple records, which directly affects how data is stored and accessed. In contrast, a Unique Secondary Index (USI) and Non-unique Secondary Index (NUSI) do not directly dictate the primary data distribution, and No Primary Index (NOPI) implies the absence of an index, which does not define data distribution.