Home - Database - Data Warehousing

Data Warehousing Online Exam Quiz

Important questions about Data Warehousing. Data Warehousing MCQ questions with answers. Data Warehousing exam questions and answers for students and interviews.

1. A star schema has what type of relationship between a dimension and fact table?

Options

A : Many-to-many

B : One-to-one

C : One-to-many

D : All of the above.

2. Transient data is which of the following?

Options

A : Data in which changes to existing records cause the previous version of the records to be eliminated

B : Data in which changes to existing records do not cause the previous version of the records to be eliminated

C : Data that are never altered or deleted once they have been added

D : Data that are never deleted once they have been added

3. Reconciled data is which of the following?

Options

A : Data stored in the various operational systems throughout the organization.

B : Current data intended to be the single source for all decision support systems.

C : Data stored in one operational system in the organization.

D : Data that has been selected and formatted for end-user support applications.

4. The load and index is which of the following?

Options

A : A process to reject data from the data warehouse and to create the necessary indexes

B : A process to load the data in the data warehouse and to create the necessary indexes

C : A process to upgrade the quality of data after it is moved into a data warehouse

D : A process to upgrade the quality of data before it is moved into a data warehouse

5. A multifield transformation does which of the following?

Options

A : Converts data from one field into multiple fields

B : Converts data from multiple fields into one field

C : Converts data from multiple fields into multiple fields

D : All of the above

6. The role of the ETL process is to identify erroneous data and to fix them.

Options

A : True

B : False

C :

D :

7. A data mart is designed to optimize the performance for well-defined and predicable uses.

Options

A : True

B : False

C :

D :

8. Data in operational systems are typically fragmented and inconsistent.

Options

A : True

B : False

C :

D :

9. Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW.

Options

A : True

B : False

C :

D :

10. Successful data warehousing requires that a formal program in total quality management (TQM) be implemented.

Options

A : True

B : False

C :

D :

1. A snowflake schema is which of the following types of tables?

Options

A : Fact

B : Dimension

C : Helper

D : All of the above

2. Fact tables are which of the following?

Options

A : Completely denoralized

B : Partially denoralized

C : Completely normalized

D : Partially normalized

3. An operational system is which of the following?

Options

A : A system that is used to run the business in real time and is based on historical data.

B : A system that is used to run the business in real time and is based on current data.

C : A system that is used to support decision making and is based on current data.

D : A system that is used to support decision making and is based on historical data.

4. The @active data warehouse architecture includes which of the following?

Options

A : At least one data mart

B : Data that can extracted from numerous internal and external sources

C : Near real-time updates

D : All of the above.

5. A goal of data mining includes which of the following?

Options

A : To explain some observed event or condition

B : To confirm that data exists

C : To analyze data for expected relationships

D : To create a new data warehouse

6. The extract process is which of the following?

Options

A : Capturing all of the data contained in various operational systems

B : Capturing a subset of the data contained in various operational systems

C : Capturing all of the data contained in various decision support systems

D : Capturing a subset of the data contained in various decision support systems

7. A data warehouse is which of the following?

Options

A : Can be updated by end users.

B : Contains numerous naming conventions and formats.

C : Organized around important subject areas.

D : Contains only current data.

8. Data transformation includes which of the following?

Options

A : A process to change data from a detailed level to a summary level

B : A process to change data from a summary level to a detailed level

C : Joining data from one source into various sources of data

D : Separating data from one source into various sources of data

9. The generic two-level data warehouse architecture includes which of the following?

Options

A : At least one data mart

B : Data that can extracted from numerous internal and external sources

C : Near real-time updates

D : All of the above.

10. Data scrubbing is which of the following?

Options

A : A process to reject data from the data warehouse and to create the necessary indexes

B : A process to load the data in the data warehouse and to create the necessary indexes

C : A process to upgrade the quality of data after it is moved into a data warehouse

D : A process to upgrade the quality of data before it is moved into a data warehouse

Database more Online Exam Quiz

Copyright © 2021
Exam-GK-MCQ-Questions.Com | Contact Us | Privacy Policy | Terms of Use | Sitemap | 0.02207612991333