Correct Answer is: a process to upgrade the quality of data after it is moved into a data warehouse.

Correct Answer is: partially normalized.

Data Warehousing MCQ Multiple Choice Questions Answers

Q: 3. The time horizon in operational environment is

Correct Answer is: 120-150 days.

Q: 4. Data transformation includes

Correct Answer is: separating data from one source into various sources of data.

Q: 8. ________________ is held in the catalog of the warehouse database system.

Correct Answer is: Corewarehouse metadata.

Q: 9. _________maps the core warehouse metadata to business concepts, familiar and useful to end users.

Correct Answer is: Core level metadata.

Q: 10. The generic two-level data warehouse architecture includes

Correct Answer is: far reaz-time updates.

Q: 11. The active data warehouse architecture includes

Correct Answer is: near real-time updates.

Q: 12. The data administration subsystem helps you perform all of the following, except

Correct Answer is: security management.

Q: 13. A data warehouse iswhich of the following?

Correct Answer is: Contains only current data.

Prepare for your exams and interviews with our Data Warehousing Multiple Choice Questions (MCQs). These questions are designed to help students and aspirants test their knowledge and improve their understanding of key concepts in data warehousing.

About Data Warehousing MCQ Questions

Data Warehousing MCQs cover a wide range of topics, including data modeling, ETL processes, data storage, and query optimization. These questions are crafted to ensure a comprehensive understanding of the subject, making them ideal for both beginners and advanced learners.

Why Practice Data Warehousing Objective Questions?

Practicing Data Warehousing MCQs offers several benefits. They help you prepare for school and college exams, competitive exams, and job interviews. Regular practice enhances your problem-solving skills, boosts your confidence, and ensures you are well-versed in the fundamental and advanced concepts of data warehousing.

Who Should Use These MCQs?

Data Warehousing MCQ Questions for Practice

1. Bill Inmon has estimated___________of the time required to build a data warehouse, is consumed inthe conversion process.

10 percent.
20 percent.
40 percent
80 percent

2. The time horizon in Data warehouse is usually

1-2 years.
3-4years.
5-6 years.
5-10 years.

3. The time horizon in operational environment is

30-60 days.
60-90 days.
90-120 days.
120-150 days.

4. Data transformation includes

a process to change data from a detailed level to a summary level.
a process to change data from a summary level to a detailed level.
joining data from one source into various sources of data.
separating data from one source into various sources of data.

5. Data scrubbing is

a process to reject data from the data warehouse and to create the necessary indexes.
a process to load the data in the data warehouse and tocreate the necessary indexes.
a process to upgrade the quality of data after it is moved into a data warehouse.
a process to upgrade the quality of data before it is movedinto a data warehouse

6. The load and index is

a process to reject data from the data warehouse and to create the necessary indexes.
a process to load the data in the data warehouse and to create the necessary indexes.
a process to upgrade the quality of data after it is moved into a data warehouse.
a process to upgrade the quality of data before it is moved into a data warehouse.

7. The modern CASE tools belong to _______ category.

analysis.
Development
Coding
Delivery

8. ________________ is held in the catalog of the warehouse database system.

Application level metadata.
Algorithmic level metadata.
Departmental level metadata.
Corewarehouse metadata.

9. _________maps the core warehouse metadata to business concepts, familiar and useful to end users.

Application level metadata.
User level metadata.
Enduser level metadata.
Core level metadata.

10. The generic two-level data warehouse architecture includes

at least one data mart.
data that can extracted from numerous internal and external sources.
near realtimeupdates.
far reaz-time updates.

11. The active data warehouse architecture includes

at least one data mart.
data that can extracted from numerous internal and external sources.
near real-time updates.
all of the above.

12. The data administration subsystem helps you perform all of the following, except

backups and recovery.
query optimization.
security management.
create, change, and delete information.

13. A data warehouse iswhich of the following?

Can be updated by end users.
Contains numerous naming conventions and formats.
Organized around important subject areas.
Contains only current data.

14. The extract process is

capturing all of the data contained in various operational systems.
capturing a subset of the data contained in various operational systems.
capturing all of the data contained in various decision support systems.
capturing a subset of the data contained in various decision support systems.

15. ______consists of formal definitions, such as a COBOL layout or a database schema.

Classical metadata.
Transformation metadata.
Historical metadata.
Structural metadata.

16. Fact tables are

completely demoralized.
partially demoralized.
completely normalized.
partially normalized.

17. ____________ is called a multifield transformation.

Converting data from one field into multiple fields.
Converting data from fields into field.
Converting data from double fields into multiple fields.
Converting data from one field to one field.

18. Transient data is

data in which changes to existing records cause the previous version of the records to be eliminated.
data in which changes to existing records do not cause the previous version of the records to beeliminated.
data that are never altered or deleted once they have been added.
data that are never deleted once they have been added.

19. __________ is a subject-oriented, integrated, time-variant, nonvolatile collection of data in support of management decisions.

Data Mining
Data Warehousing
Web Mining
Text Mining

20. ......................... is a subject-oriented, integrated, time-variant, nonvolatile collection or data in support of management decisios.

Data Mining
DataWarehousing
Document Mining
Text Mining

21. __________ is the heart of the warehouse.

Data mining database servers.
Data warehouse database servers.
Data mart database servers.
Relational data base servers.

22. Reconciled data is

data stored in the various operational systems throughout the organization.
current data intended to be the single source for all decision supportsystems.
data stored in one operational system in the organization.
data that has been selected and formatted for end-user support applications.

23. ____________predicts future trends & behaviors, allowing business managers to make proactive,knowledge-driven decisions.

Data warehouse.
Data mining.
Datamarts.
Metadata.

24. Data can be updated in _____environment.

data warehouse.
data mining.
operational.
informational.

25. Expansion for DSS in DW is

Decision Support system.
Decision Single System.
Data Storable System.
Data Support System.

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

Fact
Dimension
Helper
All of the above

27. Business Intelligence and data warehousing is used for

Forecasting.
Data Mining.
Analysis of large volumes of product sales data.
All of the above.

28. Which of the following is not a kind of data warehouse application?

Information processing
Analytical processing
Data mining
Transaction processing

29. ______________databases are owned by particular departments or business groups.

Informational.
Operational.
Both informational and operational.
Flat.

30. The type of relationship in star schema is

many to many
one to one
one to many
many to one

Data Warehousing MCQ Multiple Choice Questions Answers | Quiz for Practice

About Data Warehousing MCQ Questions

Why Practice Data Warehousing Objective Questions?

Who Should Use These MCQs?

Data Warehousing MCQ Questions for Practice

1. Bill Inmon has estimated___________of the time required to build a data warehouse, is consumed inthe conversion process.

2. The time horizon in Data warehouse is usually

3. The time horizon in operational environment is

4. Data transformation includes

5. Data scrubbing is

6. The load and index is

7. The modern CASE tools belong to _______ category.

8. ________________ is held in the catalog of the warehouse database system.

9. _________maps the core warehouse metadata to business concepts, familiar and useful to end users.

10. The generic two-level data warehouse architecture includes

11. The active data warehouse architecture includes

12. The data administration subsystem helps you perform all of the following, except

13. A data warehouse iswhich of the following?

14. The extract process is

15. ______consists of formal definitions, such as a COBOL layout or a database schema.

16. Fact tables are

17. ____________ is called a multifield transformation.

18. Transient data is

19. __________ is a subject-oriented, integrated, time-variant, nonvolatile collection of data in support of management decisions.

20. ......................... is a subject-oriented, integrated, time-variant, nonvolatile collection or data in support of management decisios.

21. __________ is the heart of the warehouse.

22. Reconciled data is

23. ____________predicts future trends & behaviors, allowing business managers to make proactive,knowledge-driven decisions.

24. Data can be updated in _____environment.

25. Expansion for DSS in DW is

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

27. Business Intelligence and data warehousing is used for

28. Which of the following is not a kind of data warehouse application?

29. ______________databases are owned by particular departments or business groups.

30. The type of relationship in star schema is

Your Score

Related Quiz Topics

Recent Articles

Looking to post on our portal?

Data Warehousing MCQ Multiple Choice Questions Answers | Quiz for Practice

About Data Warehousing MCQ Questions

Why Practice Data Warehousing Objective Questions?

Who Should Use These MCQs?

Data Warehousing MCQ Questions for Practice

1. Bill Inmon has estimated___________of the time required to build a data warehouse, is consumed inthe conversion process.

2. The time horizon in Data warehouse is usually

3. The time horizon in operational environment is

4. Data transformation includes

5. Data scrubbing is

6. The load and index is

7. The modern CASE tools belong to _______ category.

8. ________________ is held in the catalog of the warehouse database system.

9. _________maps the core warehouse metadata to business concepts, familiar and useful to end users.

10. The generic two-level data warehouse architecture includes

11. The active data warehouse architecture includes

12. The data administration subsystem helps you perform all of the following, except

13. A data warehouse iswhich of the following?

14. The extract process is

15. ______consists of formal definitions, such as a COBOL layout or a database schema.

16. Fact tables are

17. ____________ is called a multifield transformation.

18. Transient data is

19. __________ is a subject-oriented, integrated, time-variant, nonvolatile collection of data in support of management decisions.

20. ......................... is a subject-oriented, integrated, time-variant, nonvolatile collection or data in support of management decisios.

21. __________ is the heart of the warehouse.

22. Reconciled data is

23. ____________predicts future trends & behaviors, allowing business managers to make proactive,knowledge-driven decisions.

24. Data can be updated in _____environment.

25. Expansion for DSS in DW is

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

27. Business Intelligence and data warehousing is used for

28. Which of the following is not a kind of data warehouse application?

29. ______________databases are owned by particular departments or business groups.

30. The type of relationship in star schema is

Your Score

Related Quiz Topics

Recent Articles

Login at Quizforum