Data Warehouse-II
Data warehousing concepts, architecture, ETL processes, OLAP systems, and management
Questions
In which of the following are data warehouses updated every time an operational system performs a transaction?
- Real time data warehouse
- Federated data warehouse
- Distributed data warehouse
- None of these
________________is a system to handle day-to-day business transactions. These systems handle tremendous amount of data daily.
- Infrastructure specialists
- OLAP (On-Line Analytical Processing)
- Data warehouse architect
- OLTP (On-Line Transaction Processing)
_____________ is a relational database, which is designed for query and analysis rather than for transaction processing.
- OLTP (On-Line Transaction Processing)
- OLAP (On-Line Analytical Processing)
- Data warehouse
- Real time data warehouse
Which of the following servers supports multidimensional views of data through array-based multidimensional storage engines?
- ROLAP (Relational OLAP)
- MOLAP (Multidimensional OLAP)
- HOLAP (Hybrid OLAP)
- None of these
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?
- Real time data warehouse
- Federated data warehouse
- Distributed data warehouse
- None of these
_______________ is known as the father of data warehouse.
- Charles Babbage
- Bill Inmon
- Dennis Ritchie
- Bjarme Strostrup
In data warehousing team, ______________should be aware and have a good working knowledge of the core third-party tools in the market place.
- data warehouse project manager
- tools specialist
- help disk functionality
- none of these
The technique of gathering data from various operational systems and from external sources is known as ___________.
- data extraction
- data staging component
- help disk functionality
- external data
____________ is the process of examining the data available in an existing data source, and collecting statistics and information about that data.
- Data profiling
- Data capture
- Data integration
- Data quality
Which of the following characteristics of data warehouse described by Bill Inmon means that once entered into the data warehouse, data should not change?
- Non-volatile
- Subject-oriented
- Integrated
- None of these
_____________ is the act of detecting and correcting corrupt or inaccurate records from a record set, table or database.
- Data scrubbing
- Data management
- Data enrichment
- None of these
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?
- Internal data
- Power user
- Production data
- External data
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?
- Technical architecture
- Management and control component
- Production data
- None of these
___________ in a data warehouse is similar to the data dictionary or data catalog in a data management system.
- Data mart
- Meta data
- Management and control components
- None of these
___________ data mining capabilities help to detect fraud, to segment the customers and to simplify market basket analysis.
- Intelligent Miner
- MineSet
- Enterprise Miner
- None of these
The perspective of ________________ in data warehouse building team is that of a bird flying over maze.
- public relations person
- database administrator
- data warehouse project director
- none of these