Data Warehousing MCQs Quiz Multiple Choice Questions & Answers

Data Warehousing MCQs questions answers

Test Your Skills in Data Warehousing Quiz Online

MCQ quiz on Data Warehousing multiple choice questions and answers on Data Warehousing MCQ questions quiz on Data Warehousing objectives questions with answer test pdf for interview preparations, freshers jobs and competitive exams.

Data Warehousing Questions with Answers

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

31. The type of relationship in star schema is

32. _______test is used in an online transactional processing environment.

33. Which of the following is not a component of a data warehouse?

34. Detail data in single fact table is otherwise known as

35. _____________consists of information in the enterprise that is not in classical form.

36. Data warehouse contains_____________data that is never found in the operational environment.

37. An .................. system is market-oriented and is used for data analysis by knowledge workers, including managers, executives, and analysts.

38. The data is stored, retrieved & updated in

39. Record cannot be updated in

40. The star schema is composed of __________ fact table.

41. The full form of OLAP is

42. The source of all data warehouse data is the

43. ________________ is the specialized data warehouse database.

44. The biggest drawback of the level indicator in the classic star-schema is that it limits

45. The data Warehouse is

46. __________describes the data contained in the data warehouse.

47. ........................ is a good alternative to the star schema.

48. ___________ is a good alternative to the star schema.

49. The important aspect of the data warehouse environment is that data found within the data warehouseis___________.

50. The key used in operational environment may not have an element of


Multiple Choice Questions and Answers on Data Warehousing

Data Warehousing Multiple Choice Questions and Answers

Data Warehousing Trivia Quiz

Data Warehousing Question and Answer PDF Online

Spreading Knowledge Across the World

United States, United Kingdom, India, Nigeria, Philippines, Pakistan, Nepal, Singapore, Indonesia, Bangladesh, Ghana, United Arab Emirates, Kenya, Canada, Malaysia, Australia, Iran, South Africa, Uganda, France, Ireland, Egypt, Tanzania, Ethiopia, Thailand, Sri Lanka, Cameroon, Hong Kong, Spain, Vietnam, New Zealand, Japan, Brazil, Saudi Arabia, Zambia, Czechia, Italy, Russia, Myanmar (Burma), Netherlands, Germany, Romania, Mexico, Rwanda, Sierra Leone, Turkey, Zimbabwe, Poland, Iraq, Cyprus, Algeria, Liberia, Greece, Jamaica, Malawi, Qatar, Portugal, South Korea, Argentina, Colombia, Morocco, Peru, Kuwait, Lithuania, Finland, Somalia, Israel, Bulgaria, Chile, Hungary, Trinidad & Tobago, Uzbekistan, Ukraine, Sweden, Kazakhstan, Norway, Macedonia, Benin, Switzerland, Oman, Botswana, Belgium, Ecuador, Slovakia, China, Croatia, Brunei, Serbia, Papua New Guinea, Bahrain, Guyana, Denmark, Lesotho, Lebanon, Jordan, Azerbaijan, Latvia, Cambodia, Namibia, Mauritius, Austria, Mongolia, Albania, Libya, Gambia, Taiwan, Bhutan, Venezuela, Dominican Republic, Tunisia, Luxembourg, Bosnia & Herzegovina, Guatemala, Solomon Islands, Guam, Costa Rica, Yemen, Bolivia, and many more ...