CS0005 - Data Warehouse

CS0005 - Data Warehouse (Review)

by Beau Gray Habal

Multiple Choice

What is an electronic storage of a large amount of information by a business or organization?

• DBMS

• Database

• Data Warehousing

• SQL

Multiple Choice

Which among the following statements defines a data warehouse?

• It is a transactional system that is set to monitor and update real-time data in order to have only the most recent data available.

• It is programmed to aggregate structured data over a period of time.

Multiple Choice

Which among the following is NOT an alternative name for data warehouse system?

• Analytic Application

• Business Intelligence Solution

• Decision Support System

• Transaction Processing System

Multiple Choice

In which year A Nielsen and IRI introduced the dimensional data marts for retail sales?

• 1971

• 1970

• 1950

• 1960

Multiple Choice

It is a benefit of a data warehouse that helps the analysts in increasing their work efficiency and providing more accurate business insights.

• Time efficient

• High Return on Investment

• Data Quality and Consistency

• Enhanced Performance

Multiple Choice

Which among the following is a data warehouse architecture wherein raw data are stored in a central repository of the warehouse?

• Simple with staging area

• Simple

• Hub and spoke

• Sandboxes

Multiple Choice

In which tier does OLAP belong in a data warehouse architecture?

• Bottom

• Top tier

• Middle

Multiple Choice

What is a component of Data warehouse that is called the front component?

• Warehouse Manager

• Query Manager

• Load Manager

• End user access tools

Multiple Choice

Which among the following applications does not use data warehouse?

• Financial services

• Controlled manufacturing

• Telecommunications

• Prototyping

​END OF GAME