A ____ schema is a type of star schema in which the dimension tables can have their own dimension tables.
A) snowflake
B) starflake
C) mesh
D) matrix

Question

Quizplus · Accepted Answer

In a snowflake schema, the dimension tables are normalized, which means that they are broken down into smaller tables with their own dimensions. This results in a structure that resembles the branching out of snowflakes, hence the name. This makes the snowflake schema more complex than the traditional star schema but can provide better query optimization and more flexibility in data analysis.

A ____ Schema Is a Type of Star Schema in Which