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.
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
Spreading Knowledge Across the World
USA - United States of America Canada United Kingdom Australia New Zealand South America Brazil Portugal England Scotland Norway Ireland Denmark France Spain Poland Netherland Germany Sweden South Africa Ghana Tanzania Nigeria Kenya Ethiopia Zambia Singapore Malaysia India Pakistan Nepal Taiwan Philippines Libya Cambodia Hong Kong China UAE - Saudi Arabia Qatar Oman Kuwait Bahrain Dubai Israil and many more....