nerdexam
IBM

P2090-027 · Question #13

Which of the following data warehouse schemas cannot be modeled into a Cube Model object?

The correct answer is A. A non-star schema. See the full explanation below for the reasoning.

Question

Which of the following data warehouse schemas cannot be modeled into a Cube Model object?

Options

  • AA non-star schema.
  • BA star schema that contains a set of fact tables and a set of dimension tables that join the fact
  • CA star schema in which all attributes of a dimension are stored in a single dimension table.
  • DA star schema in which some of the dimension attributes are stored in the same table where fact

How the community answered

(47 responses)
  • A
    74% (35)
  • B
    15% (7)
  • C
    4% (2)
  • D
    6% (3)

Community Discussion

No community discussion yet for this question.

Full P2090-027 Practice