Multidimensional Schemas

A multidimensional model views data in the form of

• Cube

• Cuboid

• Sphere

• Cylindrical

How many schema used by data warehouse

• 5

• 4

• 3

• 2

What are the types of schemas

• Star schema

• Snow flake schema

• Constellation schema

• All of the above

There are 2 types of table in star schema

• True

• False

What are the types of table in star schema

• Fact table

• Dimension table

• Both a and b

• None of these

Dimension table are not connected with fact table

• True

• False

A snow flake schema is equivalent to ___

• Constellation schema

• Both a and d

• None of these

• Star schema

In which schema all dimension table are not connected to fact table

• Snow flake schema

• Star schema

• Constellation schema

• All of the above

In snow flake schema one fact table which is linked to many dimensions table

• True

• False

Constellation schema is also called as

• Star schema

• Galaxy schema

• Snow flake schema

• All of the above