Data Warehouse

Description: data warehouse
Number of Questions: 15
Created by:
Tags: datawarehouse Database
Attempted 0/15 Correct 0 Score 0

Which of the following data warehouse types are those in which components are distributed across a number of physical databases?

  1. Distributed data warehouse

  2. Real-time data warehouse

  3. Federated data warehouse

  4. Temporary data warehouse

  5. Schema


Correct Option: A
Explanation:

A data warehouse of this type is that in which components are distributed across a number of physical databases.

Which of the following characteristics of data warehouses puts data from disparate sources into a consistent format?

  1. Subject-oriented

  2. Integrated

  3. Non-Volatile

  4. Time Variant

  5. Storage


Correct Option: B
Explanation:

This characteristic of data warehousing puts data from disparate sources into a consistent format.

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?

  1. Data storage component

  2. Information delivery component

  3. Metadata component

  4. Data staging component

  5. Management and control component


Correct Option: D
Explanation:

This component 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.

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

  1. ROLAP (Relational OLAP)

  2. HOLAP (Hybrid OLAP)

  3. MOLAP (Multidimensional OLAP)

  4. OLAP (Online Analytical Processing Server)

  5. KLAP


Correct Option: C
Explanation:

This server in data warehousing supportsx multidimensional views of data through array-based multidimensional storage engines.

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?

  1. Star schema

  2. Snowflake schema

  3. Fact constellation

  4. Physical data model

  5. Dimensional modeling


Correct Option: B
Explanation:

This schema in data warehouse is a method of normalising the dimension tables in a star schema and when one completely normalises all the dimension tables, the resultant structure resembles a schema with the fact table in the middle.

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?

  1. Multicube

  2. Hypercube

  3. Data cube

  4. OLAP

  5. Schema


Correct Option: C
Explanation:

This object in data a warehouse allows data to be modelled and viewed in multiple dimensions and it is defined by dimensions and facts.

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?

  1. Data quality

  2. Data capture

  3. Data integration

  4. Data profiling

  5. Data cleansing


Correct Option: D
Explanation:

This method in data warehouse is the process of examining the data available in an existing data source and collecting statistics and information about that data.

In which of the following levels of CMM data quality issues are acknowledged and major problems are handled, as and when they surface?

  1. Level 0

  2. Level 2

  3. Level 3

  4. Level 4

  5. Level 5


Correct Option: B
Explanation:

In this level of CMM data quality issues are acknowledged and major problems are handled, as and when they surface.

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?

  1. Level 0

  2. Level 1

  3. Level 2

  4. Level 3

  5. Level 5


Correct Option: E
Explanation:

This level in Capability Maturity Model (CMM) is the one in which a company understands how each IT process is related to the overall business strategies, and goals of the corporation.

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?

  1. Data profiling

  2. Data cleansing

  3. Data warehouse

  4. Data capture

  5. Data quality


Correct Option: C
Explanation:

This is the process of integrating data from multiple internal and external sources, and making it readily available for use in business analysis.

Which of the following loads in data warehousing refers to completely erasing the contents of one or more tables and reloading with fresh data?

  1. Initial load

  2. Incremental load

  3. Full refresh

  4. Half load

  5. Incomplete load


Correct Option: C
Explanation:

This type of load in data warehouse refers to completely erasing the contents of one or more tables, and reloading with fresh data.

Which of the following functions in data warehouse has to deal with numerous data sources and employs appropriate technique for each data source?

  1. Data transformation

  2. Data loading

  3. Data extraction

  4. Data marts

  5. Metadata


Correct Option: C
Explanation:

This function in data warehouse has to deal with numerous data sources and employs appropriate technique for each data source.

Which of the following databases is designed for analysis of business measures by categories and attributes?

  1. OLTP database

  2. Data warehouse database

  3. Operational database

  4. User database

  5. Employee database


Correct Option: B
Explanation:

This database is designed for analysis of business measures by categories and attributes.

Which of the following components of a data warehouse is used to load the source data into the warehouse?

  1. Destination databases

  2. Wrappers

  3. Meta database

  4. Agents

  5. Sources


Correct Option: B
Explanation:

This component of a data warehouse is used to load the source data into the warehouse.

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?

  1. Conceptual data model

  2. Logical data model

  3. Physical data model

  4. E-R modeling

  5. Hierarchical data model


Correct Option: C
Explanation:

This data model in database describes the implementation of data in a physical database and is also called the blueprint for the database.

- Hide questions