When representing data in a data warehouse, using several dimension tables that are each connected only to a fact table means you are using which warehouse structure?
A) star schema
B) snowflake schema
C) relational schema
D) dimensional schema

Question

Quizplus · Accepted Answer

In a star schema, there is only one central fact table that is connected to multiple dimension tables. Each dimension table is directly connected to the fact table, resulting in a simple and efficient structure. Snowflake schema is similar but has dimension tables that are normalized, resulting in a more complex structure. Relational schema and dimensional schema are not specific warehouse structures.

When Representing Data in a Data Warehouse, Using Several Dimension