Data Warehouse-II
Description: Computer Organisation & Arch. | |
Number of Questions: 16 | |
Created by: Sangita Pandit | |
Tags: Data warehouse Databases OOPs Computer Basics |
In which of the following are data warehouses 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.
_____________ 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?
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?
_______________ 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.
The technique of gathering data from various operational systems and from external sources is known as ___________.
____________ 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?
_____________ 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?
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?
___________ 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.
The perspective of ________________ in data warehouse building team is that of a bird flying over maze.