Data Warehousing - Quiz 2 BITS WILP - Mtec Software Systems - 2017

Data Warehousing - Quiz 2

BITS WILP - Mtec Software Systems - 2017

1.Dimension table is related to fact-table in which kind of relationship?
Select one:
a. one-to-one.
b. many-to-many.
c. one-to-many.
d. many-to-one.

Ans: b. many-to-many.

2.Snowflake schema is more normalized compared to star schema.
Select one:
a. True
b. False

Ans: a. True

3.In case of Retail Store Database, Customer Dimension is which kind of dimension?
Select one:
a. Junk Dimension
b. Slowly Changing Dimension
c. Rapidly Changing Dimension
d. Miscellaneous Dimension

Ans: b. Slowly Changing Dimension



4.Which of the following is/are not data transformation task(s)?
Select one:
a. Conversion
b. Selection
c. Rearrangement
d. Reduction

Ans: d. Reduction

5.Data loading requires data warehouse to be in offline mode.
Select one:
a. False
b. True

Ans: a. False

6.Which of the following is not one of the principles pertaining to Type-2 change?
Select one:
a. There is a need to preserve history in Data Warehouse.
b. They ae used to compare performance across the transitions.
c. This type of change partitions the history in the Data Warehouse.
d. Every change for the same attribute must be preserved.

Ans: b. They ae used to compare performance across the transitions.

7.In this technique of Data Loading, if primary key of incoming record matches with that of some already existing record, matching target record is updated
Select one:
a. Destructive Merge
b. Load
c. Constructive Merge
d. Append

Ans: a. Destructive Merge

8.Immediate extraction of data using special stored procedures that are fired when certain pre-defined events occur is called _____________
Select one:
a. Capture through Transaction Logs
b. Capture through Database Triggers
c. Capture based on date and timestamp
d. Capture in Source Application

Ans: b. Capture through Database Triggers

9.The type of key that does not have any built-in meaning and is simply system generated sequence numbers is ________________
Select one:
a. Surrogate Key
b. Concatenated Primary Key
c. Primary Key
d. Foreign Key

Ans: a. Surrogate Key

10.Which of the following is NOT a fully additive measure?
Select one:
a. Products returned
b. Percentage of profit
c. Revenue generated in rupees
d. Products ordered

Ans: b. Percentage of profit