Multiple choice technology platforms and products

All joins in the physical layer should be complex joins.

  1. True

  2. False

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The physical layer should use simple joins based on primary-foreign key relationships. Complex joins (those using SQL expressions with OR, CASE, etc.) belong in the BMM layer where they can be reused and optimized. Physical joins should mirror actual database relationships.