A ____ design in a data warehouse data structure refers to the situation in which one dimension table leads to another dimension table.
A) network
B) hierarchical
C) snowflake
D) raindrop
E) solar

Question

Quizplus · Accepted Answer

In a snowflake design, a dimension table is connected with multiple other dimension tables in a hierarchical manner, forming a snowflake-like structure. This is the opposite of a hierarchical design, in which one dimension table leads to another in a strict parent-child relationship. A network design is a more complex structure in which dimension tables are connected in multiple ways, forming a network-like structure. A raindrop and solar design are not commonly used terms in data warehousing.

A ____ Design in a Data Warehouse Data Structure Refers