Data Warehousing MCQ Questions
Tags: datawarehousing, mcq, datawarehousingmcq, pdf
Published: 2022-12-11 06:05:21

[Data Warehousing MCQs](https://www.onlineinterviewquestions.com/data-warehouse-mcq/) help you to prepare for Data Warehouse certification exam. The practice test questions are designed by experts and verified to ensure your best result.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/sfzz95nrd7bl0q3bomau.jpg)


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

4. ................ 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.