Data Warehouse Fundamentals
Covers core data warehouse concepts including types, characteristics, architecture, schemas, OLAP servers, ETL processes, data modeling, and quality management.
Questions
Which of the following data warehouse types are those in which components are distributed across a number of physical databases?
- Distributed data warehouse
- Real-time data warehouse
- Federated data warehouse
- Temporary data warehouse
- Schema
Which of the following characteristics of data warehouses puts data from disparate sources into a consistent format?
- Subject-oriented
- Integrated
- Non-Volatile
- Time Variant
- Storage
Which of the following components of data warehouse architecture has the major function to extract the data, transform the data, and then load the data into the data warehouse storage?
- Data storage component
- Information delivery component
- Metadata component
- Data staging component
- Management and control component
Which of the following servers in data warehouse supports multidimensional views of data through array-based multidimensional storage engines?
- ROLAP (Relational OLAP)
- HOLAP (Hybrid OLAP)
- MOLAP (Multidimensional OLAP)
- OLAP (Online Analytical Processing Server)
- KLAP
Which of the following schema in data warehousing is a method of normalising the dimension tables in a star schema and when it is completely normalised, the resultant structure resembles a schema with the fact table in the middle?
- Star schema
- Snowflake schema
- Fact constellation
- Physical data model
- Dimensional modeling
Which of the following objects in a data warehouse allows data to be modelled and viewed in multiple dimensions and is defined by dimensions and facts?
- Multicube
- Hypercube
- Data cube
- OLAP
- Schema
Which of the following methods in data warehousing is the process of examining the data available in an existing data source and collecting statistics and information about that data?
- Data quality
- Data capture
- Data integration
- Data profiling
- Data cleansing
In which of the following levels of CMM data quality issues are acknowledged and major problems are handled, as and when they surface?
- Level 0
- Level 2
- Level 3
- Level 4
- Level 5
Which of the levesl in Capability Maturity Model (CMM) is the one in which a company understands how each IT process is related to overall business strategies and goals of the corporation?
- Level 0
- Level 1
- Level 2
- Level 3
- Level 5
Which of the following is the process of integrating data from multiple internal and external sources and making it readily available for use in business analysis?
- Data profiling
- Data cleansing
- Data warehouse
- Data capture
- Data quality
Which of the following loads in data warehousing refers to completely erasing the contents of one or more tables and reloading with fresh data?
- Initial load
- Incremental load
- Full refresh
- Half load
- Incomplete load
Which of the following functions in data warehouse has to deal with numerous data sources and employs appropriate technique for each data source?
- Data transformation
- Data loading
- Data extraction
- Data marts
- Metadata
Which of the following databases is designed for analysis of business measures by categories and attributes?
- OLTP database
- Data warehouse database
- Operational database
- User database
- Employee database
Which of the following components of a data warehouse is used to load the source data into the warehouse?
- Destination databases
- Wrappers
- Meta database
- Agents
- Sources
Which of the following data models in database describes the implementation of data in a physical database and is also called the blueprint for the database?
- Conceptual data model
- Logical data model
- Physical data model
- E-R modeling
- Hierarchical data model