Q&A: Datawarehousing Concepts (BW 3.5)

Questions:

1. Datawarehouse provides a subject oriented view of the business through current and historical data.

a) True              b) False

2.    Datwarehouse design is optimized for performance of data retrieval

a) True              b) False

3.    Fact can be defined as:

a) How the data needs to be viewed, like sales organization, distribution channel etc.

b) Relationship between performance measure of the business and by which dimension

they are needed to be viewed

c) Performance measure of the business, like numbers, percentages

4.    Extraction, transformation and loading is not a part of datawarehouse architecture

a) True              b) False

5.    Enterprise data warehouse can have different layers like staging layer, data warehouse layer and the reporting layer

a) True              b) False

6.    End users have read/write access to datawarehouse, meaning data can be read as well as updated

a) True              b) False

7.    Characteristic of OLAP system is:

a) Read

b) Add, change, delete

8.    Typical OLTP systems have multidimensional data structure

a) True              b) False

9.    In a Entity-Relationship Diagram, entities can be defined as:

a) The objects about which we want to store information

b) The data we collect

c) The structure provided to draw information from multiple objects

10. A classical star schema contains only one central fact table

a) True              b) False

11. The dimension attribute values determine the coordinates via which a cube cell can be accessed uniquely

a) True              b) False

12. Snowflake schema consists of large denormalized dimension tables

a) True              b) False