Multiple choice technology databases

When utilizing a unique secondary index, how may AMP (s) is usually accessed?

  1. All-AMP

  2. One-AMP

  3. Multi-AMP

  4. Two-AMP
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

A Unique Secondary Index (USI) requires accessing exactly two AMPs to verify uniqueness - one AMP to check if the value exists, and a second AMP to ensure the value isn't duplicated elsewhere in the system. This differs from a Non-Unique Secondary Index (NUSI) which typically accesses all AMPs or a subset. The two-AMP access is part of the uniqueness guarantee mechanism.

Keep practicing — related questions