When designing a Star Schema, which option does not apply?

The correct answer is D. Dimensional tables are normalized. In a Star Schema the dimensional tables does not need to be normalized. A Snowflake Schema is a modified Star Schema that has normalized the dimensional tables.

Developing the Physical Layer of a Repository

Question

Options

AThe facts are quantifiable.
BThe fact has several foreign keys that are primary keys in the dimensional table
CFact table is joined to the related dimensional tables.
DDimensional tables are normalized.
EDimensional tables have one attribute primary key as Product_ID for products.

How the community answered

(39 responses)

A
3% (1)
B
13% (5)
C
3% (1)
D
74% (29)
E
8% (3)

Explanation

In a Star Schema the dimensional tables does not need to be normalized. A Snowflake Schema is a modified Star Schema that has normalized the dimensional tables.

Topics

#star schema#dimensional modeling#fact table#normalization

Community Discussion

No community discussion yet for this question.

Full 1Z0-591 Practice