Data Warehousing MCQ Questions

Data Warehousing MCQs help you to prepare for Data Warehouse certification exam. The practice test questions are designed by experts and verified to ensure your best result.

The data Warehouse is ...............

• Read-only system
• Write only system
• Both Read & Write System
• None of the above

The important aspect of the data warehouse environment is that data found within the data warehouse is .............

• Integrated
• Time-variant
• Subject-oriented
• All of the above

The time horizon in the Data warehouse is usually ............

• 3-4years
• 5-6 years
• ** 5-10 years**
• None of the above

1. ................ describes the data contained in the data warehouse.

• Metadata
• Relational data
• Informational data
• None of the above

Which of the following predicts future trends & behaviors, allowing business managers to make proactive, knowledge-driven decisions?

• Metadata
• Datamarts
• Data warehouse.
• Data mining

................ is the heart of the warehouse.

Data mart database servers
Relational database servers
Data warehouse database servers
All of the above

................ is the specialized data warehouse database.

• DBZ
• Oracle
• Informix
• ** Redbrick**

Which of the following defines the structure of the data held in operational databases and used by operational applications?

• User-level metadata.
• Operational metadata.
• Operational metadata.
• Data warehouse metadata.

Which of the following consists of information in the enterprise that is not in classical form?

• Data mining
• ** Mushy metadata.**
• Differential metadata.
• None of the above

Data can be updated in _____environment.

• Operational
• Data mining
• Informational
• None of the above

The source of all data warehouse data is the ....................

Formal environment
Informal environment
** Operational environment**
None of the above

Data warehouse contains ............. data that is never found in the operational environment.

• Summary
• Normalized
• Informational
• Denormalized

Bill Inmon has estimated___________of the time required to build a data warehouse, is consumed in the conversion process.

• 20 percent
• 40 percent
• 60 percent
• ** 80 percent**

The generic two-level data warehouse architecture includes ................

• At least one data mart.
• Far real-time updates.
• Near real-time updates.
• None of the above

The active data warehouse architecture includes ..................

• At least one data mart.
• Near real-time updates.
• Data that can extracted from numerous internal and external sources
• All of the above

Data scrubbing is .............

• A process to upgrade the quality of data after it is moved into a data warehouse
• A process to upgrade the quality of data before it is moved into a data warehouse
• A process to reject data from the data warehouse and to create the necessary indexes
• None of the above

The load and index is .............

• A process to upgrade the quality of data after it is moved into a data warehouse
• A process to upgrade the quality of data before it is moved into a data warehouse
• A process to load the data in the data warehouse and to create the necessary indexes
• None of the above

The most common source of change data in refreshing a data warehouse is ...............

• Logged change data
• Snapshot change data
• Queryable change data
• None of the above

.................... are responsible for running queries and reports against data warehouse tables.

• Software
• Hardware
• ** End users**
• Middleware

The main organizational justification for implementing a data warehouse is to provide ................

• Access to data
• Decision support
• Storing large volumes of data
• Cheaper ways of handling transportation.