Multiple choice technology

________is a type of join between 3 tables where two many-to-one join converges on a single table which returns more data than expected.

  1. Chasm Trap

  2. Fan Trap

  3. Loop

  4. Context
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A Chasm Trap occurs when two many-to-one joins converge on a single table, causing the query to return more rows than expected (a Cartesian multiplication effect). This happens because aggregations get lost or duplicated at the convergence point. A Fan Trap involves one-to-many joins diverging, while a Loop is a circular join path.

Keep practicing — related questions