Multiple choice technology

In a top down 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
A Correct answer
Explanation

In top-down data warehouse architecture (Bill Inmon's approach), the enterprise data warehouse is created first as a single, integrated repository. Then, departmental data marts are derived from the warehouse. This ensures consistency across the organization and avoids data silos. Option B is incorrect because it contradicts the top-down principle. Option C describes independent data marts (bottom-up). Option D is wrong because data marts ARE created in top-down architecture.

Keep practicing — related questions