Quiznetik

Data Mining and Business Intelligence | Set 1

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

Correct : B. Data Warehousing

2. The data Warehouse is __________.

Correct : A. Read only

3. Expansion for DSS in DW is _________.

Correct : A. Decision Support system

4. The important aspect of the data warehouse environment is that data found within the data warehouse is__________.

Correct : D. D All of the above

5. The time horizon in Data warehouse is usually__________.

Correct : D. 5-10 years

6. The data is stored, retrieved & updated in___________.

Correct : B. OLTP

7. __________describes the data contained in the data warehouse.

Correct : C. Metadata

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

Correct : B. Data mining

9. _________is the heart of the warehouse.

Correct : B. Data warehouse database servers

10. _________is the specialized data warehouse database.

Correct : D. Redbrick

11. ___________defines the structure of the data held in operational databases and used by operational applications.

Correct : C. Operational metadata

12. _________is held in the catalog of the warehouse database system.

Correct : B. Algorithmic level metadata

13. __________maps the core warehouse metadata to business concepts, familiar and useful to end users.

Correct : A. Application level metadata

14. ____________ consists of formal definitions, such as a COBOL layout or a database schema.

Correct : A. Classical metadata

15. ________consists of information in the enterprise that is not in classical form.

Correct : A. Mushy metadata

16. ________ Databases are owned by particular departments or business groups.

Correct : B. Operational

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

Correct : A. one

18. The time horizon in operational environment is ________.

Correct : B. 60-90 days

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

Correct : A. Time

20. Data can be updated in ______ environment.

Correct : C. Operational

21. Record cannot be updated in__________.

Correct : D. data warehouse

22. The source of all data warehouse data is the__________.

Correct : A. Operational environment

23. Data warehouse contains ______data that is never found in the operational environment.

Correct : C. Summary

24. The modern CASE tools belong to_________category.

Correct : A. Analysis

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

Correct : D. 40 percent

26. Detail data in single fact table is otherwise known as__________.

Correct : C. Atomic data

27. ______test is used in an online transactional processing environment.

Correct : D. ACID

28. ______is a good alternative to the star schema.

Correct : C. Fact constellation

29. The biggest drawback of the level indicator in the classic star-schema is thatit limits_________.

Correct : C. Flexibility

30. A data warehouse is__________.

Correct : C. Organized around important subject areas

31. An operational system is________.

Correct : B. Used to run the business in real time and is based on current data

32. The generic two-level data warehouse architecture includes________.

Correct : C. Near real-time updates

33. The active data warehouse architecture includes _________.

Correct : D. All of the above

34. Reconciled data is_________.

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

35. Transient data is___________.

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

36. The extract process is __________.

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

37. Data scrubbing is___________.

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

38. The load and index is_______.

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

39. Data transformation includes___________.

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

40. ______ is called a multifield transformation.

Correct : A. Converting data from one field into multiple fields

41. The type of relationship in star schema is_________.

Correct : C. One-to-many

42. Fact tables are_______.

Correct : C. Completely normalize

43. ____________is the goal of data mining.

Correct : A. To explain some observed event or condition

44. Business Intelligence and data warehousing is used for________.

Correct : D. All of the above

45. The data administration subsystem helps you perform all of the following, except_________.

Correct : D. Create, change, and delete information

46. The most common source of change data in refreshing a data warehouse is__________.

Correct : A. Query able change data

47. ___________are responsible for running queries and reports against data warehouse tables.

Correct : C. End users

48. Query tool is meant for_________.

Correct : A. Data acquisition

49. Classification rules are extracted from____________.

Correct : B. Decision tree

50. Dimensionality reduction reduces the data set size by removing_____________.

Correct : B. Irrelevant attributes

51. ___________is a method of incremental conceptual clustering.

Correct : C. COBWEB

52. Effect of one attribute value on a given class is independent of values of other attribute is called____________.

Correct : A. Value independence

53. The main organizational justification for implementing a data warehouse is to provide__________.

Correct : C. Storing large volume of data

54. Multidimensional database is otherwise known as___________.

Correct : B. DBMS

55. Data warehouse architecture is based on___________.

Correct : B. RDBMS

56. Source data from the warehouse comes from__________.

Correct : A. ODS

57. ___________is a data transformation process.

Correct : D. Filtering

58. The technology area associated with CRM is__________.

Correct : C. Personalization

59. SMP stands for________.

Correct : A. Symmetric Multiprocessor

60. _____________are designed to overcome any limitations placed on the warehouse by the nature of the relational data model.

Correct : C. Multidimensional database

61. __________are designed to overcome any limitations placed on the warehouse by the nature of the relational data model.

Correct : C. Multidimensional database

62. MDDB stands for _______________.

Correct : B. Multidimensional databases

63. ____________is data about data.

Correct : A. Metadata

64. _____________is an important functional component of the metadata.

Correct : C. Information directory

65. EIS stands for____________.

Correct : C. Executive information system

66. ____________is data collected from natural systems.

Correct : A. MRI scan

67. __________is an example of application development environments.

Correct : A. Visual Basic

68. The term that is not associated with data cleaning process is____________.

Correct : D. Segmentation

69. __________are some popular OLAP tools.

Correct : A. Metacube, Informix

70. Capability of data mining is to build __________models.

Correct : C. Predictive

71. ________is a process of determining the preference of customer's majority.

Correct : B. Preferencing

72. Strategic value of data mining is_______.

Correct : C. Time-sensitive

73. ___________proposed the approach for data integration issues.

Correct : B. Ralph Kimball

74. The terms equality and roll up are associated with__________.

Correct : C. Data mart

75. Exceptional reporting in data warehousing is otherwise called as__________.

Correct : B. Alerts

76. _________is a metadata repository.

Correct : A. Prism solution directory manager

77. _________is an expensive process in building an expert system.

Correct : D. Information collection

78. The full form of KDD is__________.

Correct : B. Knowledge discovery in database

79. The first International conference on KDD was held in the year_________.

Correct : C. 1995

80. Removing duplicate records is a process called____________.

Correct : B. Data cleaning

81. __________contains information that gives users an easy-to-understand perspective of the information stored in the data warehouse.

Correct : A. Business metadata

82. _________helps to integrate, maintain and view the contents of the data warehousing system.

Correct : B. Information directory

83. Discovery of cross-sales opportunities is called _________.

Correct : D. Association

84. Data marts that incorporate data mining tools to extract sets of data are called_________.

Correct : B. Dependent data marts

85. __________can generate programs itself, enabling it to carry out new tasks.

Correct : D. Productivity system

86. The power of self-learning system lies in___________.

Correct : C. Accuracy

87. Building the informational database is done with the help of ___________.

Correct : A. Transformation or propagation tools

88. How many components are there in a data warehouse?

Correct : D. Five

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

Correct : D. Component Key

90. ___________is data that is distilled from the low level of detail found at the current detailed leve.

Correct : B. Lightly summarized data

91. Highly summarized data is __________.

Correct : A. Compact and easily accessible

92. A directory to help the DSS analyst locate the contents of the data warehouse isseen in __________.

Correct : C. Metadata

93. Metadata contains at least__________.

Correct : D. All of the above

94. Which of the following is not a old detail storage medium?

Correct : D. Pen drive

95. The data from the operational environment enter_____________of data warehouse.

Correct : A. Current detail data

96. The data in current detail level resides till__________event occurs.

Correct : D. D All of the above

97. The dimension tables describe the __________.

Correct : B. Facts

98. The granularity of the fact is the ___________ of detail at which it is recorded.

Correct : A. Transformation

99. Which of the following is not a primary grain in analytical modeling.

Correct : B. Periodic snapshot

100. Granularity is determined by___________.

Correct : C. Both A and B