Data Warehouse-II

Description: Computer Organisation & Arch.
Number of Questions: 16
Created by:
Tags: Data warehouse Databases OOPs Computer Basics
Attempted 0/16 Correct 0 Score 0

In which of the following are data warehouses updated every time an operational system performs a transaction?

  1. Real time data warehouse

  2. Federated data warehouse

  3. Distributed data warehouse

  4. None of these


Correct Option: A
Explanation:

This is one of the types of data warehouse. They are updated every time an operational system performs a transaction.

________________is a system to handle day-to-day business transactions. These systems handle tremendous amount of data daily.

  1. Infrastructure specialists

  2. OLAP (On-Line Analytical Processing)

  3. Data warehouse architect

  4. OLTP (On-Line Transaction Processing)


Correct Option: D
Explanation:

OLTP (On-Line Transaction Processing) is a system to handle day-to-day business transactions. These systems handle tremendous amount of data daily.

_____________ is a relational database, which is designed for query and analysis rather than for transaction processing.

  1. OLTP (On-Line Transaction Processing)

  2. OLAP (On-Line Analytical Processing)

  3. Data warehouse

  4. Real time data warehouse


Correct Option: C
Explanation:

A data warehouse is a relational database, which is designed for query and analysis rather than for transaction processing.

Which of the following servers supports multidimensional views of data through array-based multidimensional storage engines?

  1. ROLAP (Relational OLAP)

  2. MOLAP (Multidimensional OLAP)

  3. HOLAP (Hybrid OLAP)

  4. None of these


Correct Option: B
Explanation:

These servers support multidimensional views of data through array based multidimensional storage engines.

Which of the following data warehouses is the integration of heterogeneous business intelligence systems set to provide analytical capabilities across different functions of an organisation?

  1. Real time data warehouse

  2. Federated data warehouse

  3. Distributed data warehouse

  4. None of these


Correct Option: B
Explanation:

This type is the integration of heterogeneous business intelligence systems set to provide analytical capabilities across different functions of an organisation.

_______________ is known as the father of data warehouse.

  1. Charles Babbage

  2. Bill Inmon

  3. Dennis Ritchie

  4. Bjarme Strostrup


Correct Option: B
Explanation:

Bill Inmon is known as the father of data warehouse.

In data warehousing team, ______________should be aware and have a good working knowledge of the core third-party tools in the market place.

  1. data warehouse project manager

  2. tools specialist

  3. help disk functionality

  4. none of these


Correct Option: B
Explanation:

Tools specialist should be aware, and have a good working knowledge of the core third-party tools in the market place.

The technique of gathering data from various operational systems and from external sources is known as ___________.

  1. data extraction

  2. data staging component

  3. help disk functionality

  4. external data


Correct Option: A
Explanation:

The technique of gathering data from various operational systems and from external sources is known as data extraction.

 

____________ is the process of examining the data available in an existing data source, and collecting statistics and information about that data.

  1. Data profiling

  2. Data capture

  3. Data integration

  4. Data quality


Correct Option: A
Explanation:

Data profiling is the process of examining the data available in an existing data source, and collecting statistics and information about that data.

 
  

Which of the following characteristics of data warehouse described by Bill Inmon means that once entered into the data warehouse, data should not change?

  1. Non-volatile

  2. Subject-oriented

  3. Integrated

  4. None of these


Correct Option: A
Explanation:

Non-volaitle means that once entered into the data warehouse, data should not change. 

_____________ is the act of detecting and correcting corrupt or inaccurate records from a record set, table or database.

  1. Data scrubbing

  2. Data management

  3. Data enrichment

  4. None of these


Correct Option: A
Explanation:

Data scrubbing is the act of detecting and correcting corrupt or inaccurate records from a record set, table or database.

 
  

Which of the following data in data warehouse architecture comes from the various operational systems of the enterprise based on the information requirements in the data warehouse?

  1. Internal data

  2. Power user

  3. Production data

  4. External data


Correct Option: C
Explanation:

This category of data comes from the various operational systems of the enterprise based on the information requirements in the data warehouse.

Which component of data warehouse architecture sits on top of all the other components, and co-ordinates the services and activities within the data warehouse?

  1. Technical architecture

  2. Management and control component

  3. Production data

  4. None of these


Correct Option: B
Explanation:

This component of data warehouse architecture sits on top of all the other components. This co-ordinates the services and activities within the data warehouse.

___________ in a data warehouse is similar to the data dictionary or data catalog in a data management system.

  1. Data mart

  2. Meta data

  3. Management and control components

  4. None of these


Correct Option: B
Explanation:

Meta data in a data warehouse is similar to the data dictionary or data catalog in a data management system.

___________ data mining capabilities help to detect fraud, to segment the customers and to simplify market basket analysis.

  1. Intelligent Miner

  2. MineSet

  3. Enterprise Miner

  4. None of these


Correct Option: A
Explanation:

These data mining capabilities help to detect fraud, to segment the customers, and to simplify market basket analysis.

 

The perspective of ________________ in data warehouse building team is that of a bird flying over maze.

  1. public relations person

  2. database administrator

  3. data warehouse project director

  4. none of these


Correct Option: C
Explanation:

The perspective of data warehouse project director is that of a bird flying over maze.

- Hide questions