IBM
C2090-558 · Question #14
Which of the following is true about star schemas?
The correct answer is D. A star schema is not necessarily a snowflake schema, but a snowflake schema is always a star. See the full explanation below for the reasoning.
Question
Which of the following is true about star schemas?
Options
- AA star schema is optimal for OLTP systems.
- BA star schema is also known as a 3rd Normal Form schema.
- CA star schema is associated with master-detail relationships between tables.
- DA star schema is not necessarily a snowflake schema, but a snowflake schema is always a star
How the community answered
(43 responses)- A2% (1)
- B5% (2)
- C9% (4)
- D84% (36)
Community Discussion
No community discussion yet for this question.