Data Warehousing Questions - Part1

1. Date warehousing refers to
a. Storing data offline at a separate site.
b. Backing up data regularly
c. Data mining
d. Uses tapes as opposed to disk

2. When you ___________ the data, you are aggregating the data to higher level.
a. Drill down
b. Drill up
c. Wrap up
d. Roll up

3. State whether true or false: The entity relationship modeling technique is not suitable for data warehouses, the dimensional modeling technique is appropriate
a. True
b. False

4. A single database couldn’t server both operational high performance transaction processing and DSS, analytical processing, all at the same time
a. True
b. False

5. Which is not feature of fact table?
a. Few attributes
b. Large number of records
c. Dense data
d. Concatenated fact table key

6. In operational system numbers of users are large
a. True
b. False

7. Which one is not the component of data warehouse?
a. Source data
b. External data
c. Data storage
d. Data staging

8. Which of the following operation differentiates HOLAP architecture from ROLAP and MOLAP architectures.
a. Drill across
b. Drill through
c. Drill down
d. Roll up

9. Which one is the key component of data warehouse architecture?
a. Data retrieval
b. Information retrieval
c. Read only data
d. Information delivery

10. Which is not the feature of dimension table?
a. Dimension table key
b. Attributes
c. Ability to drill down
d. Normalized data

11. Data warehouse is a
a. Computing environment
b. A software tool
c. A hardware product
d. All the above

12. Cube is a ________ entity containing values of a certain fact at a certain aggregation level at an intersection of a combination of dimensions.
a. Logical
b. Physical
c. Analytical
d. None of these

13. During the data ______ phase of data mining, the main data sets to be used by the data mining operation are identified and cleansed of any data impurities
a. Analysis
b. Preparation
c. Classification
d. Acquisition

14. Snow flaking means
a. Normalizing the data
b. De normalizing data
c. Stabilizing data
d. None of the above

15. Which is not the nature of data in data warehouse?
a. Subject oriented data
b. Integrated data
c. Volatile data
d. Time variant data

16. Data mart is a subset of data warehouse statement is
a. True
b. False

17. The goal of star schema design is to simply __________________
a. Logical data model
b. Physical data model
c. Conceptual data model
d. None of these

18. State whether true or false: The STAR schema used for data design is a relational model consisting of fact and dimension tables.
a. True
b. False

19. Data warehouse is about taking/collecting data from different __________ sources.
a. Harmonized
b. Identical
c. Homogeneous
d. Heterogeneous

20. The dimension that is not available in the operational systems
a. Product
b. Store
c. Customer
d. Time

21. The input to the data warehouse can come from OLTP or transactional system but not from other third party database.
a. True
b. False

22. Which of the following is not a characteristic of strategic information?
a. Integrated
b. Raw data
c. Timely
d. Credible

23. Grain is the _______ level of data stored in the warehouse.
a. Atomic
b. Summarized
c. Aggregated
d. Cube

24. RDMS is a
a. Remote DBMS
b. Relative DBMS
c. Relational DBMS
d. Reliable DBMS

25. A snowflake is which of the following types of tables
a. Fact
b. Dimension
c. Helper
d. All the above