Multiple choice technology

In a bottom up data warehouse architecture

  1. The data warehouse is created first and then the data marts

  2. The data marts are created first and then data marts

  3. A set of independent data marts are created

  4. An enterprise data warehouse is created without creating data marts
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In bottom-up architecture (Ralph Kimball's approach), data marts are created first to address specific business needs. These data marts can then be integrated to form an enterprise data warehouse. This is faster to implement initially but can lead to consistency challenges. Option A describes top-down, not bottom-up. Option C suggests independent marts with no integration, which isn't a complete architecture. Option D contradicts the bottom-up approach.

Keep practicing — related questions