Quiz

1.OLTP can be used in data warehousingenvoirnment.

TRUE

FALSE

2.Finer grained fact tables are more expressive and have feverrows.

TRUE

FALSE

3.Single value attributes during recording of a transaction are…………. .

Dimentions

Facts

Aggeregates

4.A fact table without numerical facts coulmns is called……………… .

Facts-less fact table

Missing- data fact table

No-coulmn fact table

5.The goal of star schema design is to silmplify………………

Logical data model

Physical data model

Conceptual data model

6.Dimentional modeling techniques focus on the concept of………. and …………

Facts, Dimension

Facts, hierarchy

A cetral table, Dimension table

7.The star schema structure is a structure that can……………. unerstood by user andwithwhich they can……………….. work.

Not easily, not comfortable

Easily, Comfortable

More, less

8.Snowflaking is a method of……………….. the dimentiontables in a star schema.

Normalization

De-normalization

Both

9.In snowflaking, query performance takes the……………………significance in datawarehousing.

Lowest

Highest

No

10. ……………………are pre- calculated summaries derived from the most granular facttable.

Normalized data

Physical data

Aggregates