nerdexam
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)
  • A
    2% (1)
  • B
    5% (2)
  • C
    9% (4)
  • D
    84% (36)

Community Discussion

No community discussion yet for this question.

Full C2090-558 Practice