McqMate
1. |
__________ is a subject-oriented, integrated, time-variant, nonvolatile collection of data in support of management decisions. |
A. | Data Mining |
B. | Data Warehousing |
C. | Web Mining |
D. | Text Mining |
Answer» B. Data Warehousing |
2. |
The data Warehouse is __________. |
A. | Read only |
B. | Write only |
C. | Read write only |
D. | None |
Answer» A. Read only |
3. |
Expansion for DSS in DW is _________. |
A. | Decision Support system |
B. | Decision Single System |
C. | Data Storable System |
D. | Data Support System |
Answer» A. Decision Support system |
4. |
The important aspect of the data warehouse environment is that data found within the data warehouse is__________. |
A. | subject-oriented |
B. | time-variant |
C. | integrate |
D. | D All of the above |
Answer» D. D All of the above |
5. |
The time horizon in Data warehouse is usually__________. |
A. | 1-2 years |
B. | 3-4years |
C. | 5-6 years |
D. | 5-10 years |
Answer» D. 5-10 years |
6. |
The data is stored, retrieved & updated in___________. |
A. | OLAP |
B. | OLTP |
C. | SMTP |
D. | FTP |
Answer» B. OLTP |
7. |
__________describes the data contained in the data warehouse. |
A. | Relational data |
B. | Operational data |
C. | Metadata |
D. | Informational data |
Answer» C. Metadata |
8. |
__________predicts future trends & behaviors, allowing business managers to make proactive, knowledge-driven decisions. |
A. | Data warehouse |
B. | Data mining |
C. | Data marts |
D. | Metadata |
Answer» B. Data mining |
9. |
_________is the heart of the warehouse. |
A. | Data mining database servers |
B. | Data warehouse database servers |
C. | Data mart database servers |
D. | Relational data base servers |
Answer» B. Data warehouse database servers |
10. |
_________is the specialized data warehouse database. |
A. | Oracle |
B. | DBZ |
C. | Informix |
D. | Redbrick |
Answer» D. Redbrick |
11. |
___________defines the structure of the data held in operational databases and used by operational applications. |
A. | User-level metadata |
B. | Data warehouse metadata |
C. | Operational metadata |
D. | Data mining metadata |
Answer» C. Operational metadata |
12. |
_________is held in the catalog of the warehouse database system. |
A. | Application level metadata |
B. | Algorithmic level metadata |
C. | Departmental level metadata |
D. | Core warehouse metadata |
Answer» B. Algorithmic level metadata |
13. |
__________maps the core warehouse metadata to business concepts, familiar and useful to end users. |
A. | Application level metadata |
B. | User level metadata |
C. | Enduser level metadata |
D. | Core level metadata |
Answer» A. Application level metadata |
14. |
____________ consists of formal definitions, such as a COBOL layout or a database schema. |
A. | Classical metadata |
B. | Transformation metadata |
C. | Historical metadata |
D. | Structural metadata |
Answer» A. Classical metadata |
15. |
________consists of information in the enterprise that is not in classical form. |
A. | Mushy metadata |
B. | Differential metadata |
C. | Data warehouse |
D. | Data mining |
Answer» A. Mushy metadata |
16. |
________ Databases are owned by particular departments or business groups. |
A. | Informational |
B. | Operational |
C. | Both informational and operational |
D. | Flat |
Answer» B. Operational |
17. |
The star schema is composed of __________ fact table. |
A. | one |
B. | Two |
C. | Three |
D. | four |
Answer» A. one |
18. |
The time horizon in operational environment is ________. |
A. | 30-60 days |
B. | 60-90 days |
C. | 90-120 days |
D. | 120-150 days |
Answer» B. 60-90 days |
19. |
The key used in operational environment may not have an element of _________. |
A. | Time |
B. | Cost |
C. | Frequency |
D. | Quality |
Answer» A. Time |
20. |
Data can be updated in ______ environment. |
A. | Data warehouse |
B. | Data mining |
C. | Operational |
D. | Informational |
Answer» C. Operational |
21. |
Record cannot be updated in__________. |
A. | OLTP |
B. | Files |
C. | RDBMS |
D. | data warehouse |
Answer» D. data warehouse |
22. |
The source of all data warehouse data is the__________. |
A. | Operational environment |
B. | Informal environment |
C. | Formal environment |
D. | Technology environment |
Answer» A. Operational environment |
23. |
Data warehouse contains ______data that is never found in the operational environment. |
A. | Normalized |
B. | Informational |
C. | Summary |
D. | Denormalized |
Answer» C. Summary |
24. |
The modern CASE tools belong to_________category. |
A. | Analysis |
B. | Development |
C. | Coding |
D. | Delivery |
Answer» A. Analysis |
25. |
Bill Inmon has estimated___________of the time required to build a data warehouse, is consumed in the conversion process. |
A. | 10 percent |
B. | 20 percent |
C. | 30 percent |
D. | 40 percent |
Answer» D. 40 percent |
26. |
Detail data in single fact table is otherwise known as__________. |
A. | Monoatomic data |
B. | Diatomic data |
C. | Atomic data |
D. | Multiatomic data |
Answer» C. Atomic data |
27. |
______test is used in an online transactional processing environment. |
A. | MEGA |
B. | MICRO |
C. | MACRO |
D. | ACID |
Answer» D. ACID |
28. |
______is a good alternative to the star schema. |
A. | Star schema |
B. | Snowflake schema |
C. | Fact constellation |
D. | Star-snowflake schema |
Answer» C. Fact constellation |
29. |
The biggest drawback of the level indicator in the classic star-schema is thatit limits_________. |
A. | Quantify |
B. | Qualify |
C. | Flexibility |
D. | Ability |
Answer» C. Flexibility |
30. |
A data warehouse is__________. |
A. | Updated by end users |
B. | Contains numerous naming conventions and formats |
C. | Organized around important subject areas |
D. | Contains only current data |
Answer» C. Organized around important subject areas |
31. |
An operational system is________. |
A. | Used to run the business in real time and is based on historical data |
B. | Used to run the business in real time and is based on current data |
C. | Used to support decision making and is based on current data |
D. | Used to support decision making and is based on historical data |
Answer» B. Used to run the business in real time and is based on current data |
32. |
The generic two-level data warehouse architecture includes________. |
A. | At least one data mart |
B. | Data that can extracted from numerous internal and external sources |
C. | Near real-time updates |
D. | Far real-time updates |
Answer» C. Near real-time updates |
33. |
The active data warehouse architecture includes _________. |
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 |
Answer» D. All of the above |
34. |
Reconciled data is_________. |
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 |
Answer» B. Current data intended to be the single source for all decision support systems |
35. |
Transient data is___________. |
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 adde |
D. | D Data that are never deleted once they have been added |
Answer» A. Data in which changes to existing records cause the previous version of the records to be eliminated |
36. |
The extract process is __________. |
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 supportsystems |
Answer» B. Capturing a subset of the data contained in various operational systems |
37. |
Data scrubbing is___________. |
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 |
Answer» D. A process to upgrade the quality of data before it is moved into a data warehouse |
38. |
The load and index is_______. |
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 |
Answer» B. A process to load the data in the data warehouse and to create the necessary indexes |
39. |
Data transformation includes___________. |
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 |
Answer» A. A process to change data from a detailed level to a summary level |
40. |
______ is called a multifield transformation. |
A. | Converting data from one field into multiple fields |
B. | Converting data from fields into field |
C. | Converting data from double fields into multiple fields |
D. | Converting data from one field to one field |
Answer» A. Converting data from one field into multiple fields |
41. |
The type of relationship in star schema is_________. |
A. | Many-to-many |
B. | One-to-one |
C. | One-to-many |
D. | Many-to-one |
Answer» C. One-to-many |
42. |
Fact tables are_______. |
A. | Completely demoralized |
B. | Partially demoralized |
C. | Completely normalize |
D. | D Partially normalized |
Answer» C. Completely normalize |
43. |
____________is the goal of data mining. |
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 |
Answer» A. To explain some observed event or condition |
44. |
Business Intelligence and data warehousing is used for________. |
A. | Forecasting |
B. | Data Mining |
C. | Analysis of large volumes of product sales data |
D. | All of the above |
Answer» D. All of the above |
45. |
The data administration subsystem helps you perform all of the following, except_________. |
A. | Backups and recovery |
B. | Query optimization |
C. | Security management |
D. | Create, change, and delete information |
Answer» D. Create, change, and delete information |
46. |
The most common source of change data in refreshing a data warehouse is__________. |
A. | Query able change data |
B. | Cooperative change data |
C. | Logged change data |
D. | Snapshot change data |
Answer» A. Query able change data |
47. |
___________are responsible for running queries and reports against data warehouse tables. |
A. | Hardware |
B. | Software |
C. | End users |
D. | Middle ware |
Answer» C. End users |
48. |
Query tool is meant for_________. |
A. | Data acquisition |
B. | Information delivery |
C. | Information exchange |
D. | Communication |
Answer» A. Data acquisition |
49. |
Classification rules are extracted from____________. |
A. | Root node |
B. | Decision tree |
C. | Siblings |
D. | Branches |
Answer» B. Decision tree |
50. |
Dimensionality reduction reduces the data set size by removing_____________. |
A. | Relevant attributes |
B. | Irrelevant attributes |
C. | Derived attributes |
D. | Composite attributes |
Answer» B. Irrelevant attributes |
51. |
___________is a method of incremental conceptual clustering. |
A. | CORBA |
B. | OLAP |
C. | COBWEB |
D. | STING |
Answer» C. COBWEB |
52. |
Effect of one attribute value on a given class is independent of values of other attribute is called____________. |
A. | Value independence |
B. | Class conditional independence |
C. | Conditional independence |
D. | Unconditional independence |
Answer» A. Value independence |
53. |
The main organizational justification for implementing a data warehouse is to provide__________. |
A. | Cheaper ways of handling transportation |
B. | Decision support |
C. | Storing large volume of data |
D. | Access to data |
Answer» C. Storing large volume of data |
54. |
Multidimensional database is otherwise known as___________. |
A. | RDBMS |
B. | DBMS |
C. | EXTENDED RDBMS |
D. | EXTENDED DBMS |
Answer» B. DBMS |
55. |
Data warehouse architecture is based on___________. |
A. | DBMS |
B. | RDBMS |
C. | Sybase |
D. | SQL Server |
Answer» B. RDBMS |
56. |
Source data from the warehouse comes from__________. |
A. | ODS |
B. | TDS |
C. | MDDB |
D. | ORDBMS |
Answer» A. ODS |
57. |
___________is a data transformation process. |
A. | Comparison |
B. | Projection |
C. | Selection |
D. | Filtering |
Answer» D. Filtering |
58. |
The technology area associated with CRM is__________. |
A. | Specialization |
B. | Generalization |
C. | Personalization |
D. | Summarization |
Answer» C. Personalization |
59. |
SMP stands for________. |
A. | Symmetric Multiprocessor |
B. | Symmetric Multiprogramming |
C. | Symmetric Metaprogramming |
D. | Symmetric Microprogramming |
Answer» A. Symmetric Multiprocessor |
60. |
_____________are designed to overcome any limitations placed on the warehouse by the nature of the relational data model. |
A. | Operational database |
B. | Relational database |
C. | Multidimensional database |
D. | Data repository |
Answer» C. Multidimensional database |
61. |
__________are designed to overcome any limitations placed on the warehouse by the nature of the relational data model. |
A. | Operational database |
B. | Relational database |
C. | Multidimensional database |
D. | Data repository |
Answer» C. Multidimensional database |
62. |
MDDB stands for _______________. |
A. | Multiple data doubling |
B. | Multidimensional databases |
C. | Multiple double dimension |
D. | Multi-dimension doubling |
Answer» B. Multidimensional databases |
63. |
____________is data about data. |
A. | Metadata |
B. | Microdata |
C. | Minidata |
D. | Multidata |
Answer» A. Metadata |
64. |
_____________is an important functional component of the metadata. |
A. | Digital directory |
B. | Repository |
C. | Information directory |
D. | Data dictionary |
Answer» C. Information directory |
65. |
EIS stands for____________. |
A. | Extended interface system |
B. | Executive interface system |
C. | Executive information system |
D. | Extendable information system |
Answer» C. Executive information system |
66. |
____________is data collected from natural systems. |
A. | MRI scan |
B. | ODS data |
C. | Statistical data |
D. | Historical data |
Answer» A. MRI scan |
67. |
__________is an example of application development environments. |
A. | Visual Basic |
B. | Oracle |
C. | Sybase |
D. | SQL Server |
Answer» A. Visual Basic |
68. |
The term that is not associated with data cleaning process is____________. |
A. | Domain consistency |
B. | Deduplication |
C. | Disambiguation |
D. | Segmentation |
Answer» D. Segmentation |
69. |
__________are some popular OLAP tools. |
A. | Metacube, Informix |
B. | Oracle Express, Essbase |
C. | HOLAP |
D. | MOLAP |
Answer» A. Metacube, Informix |
70. |
Capability of data mining is to build __________models. |
A. | Retrospective |
B. | Interrogative |
C. | Predictive |
D. | Imperative |
Answer» C. Predictive |
71. |
________is a process of determining the preference of customer's majority. |
A. | Association |
B. | Preferencing |
C. | Segmentation |
D. | Classification |
Answer» B. Preferencing |
72. |
Strategic value of data mining is_______. |
A. | Cost-sensitive |
B. | Work-sensitive |
C. | Time-sensitive |
D. | Technical-sensitive |
Answer» C. Time-sensitive |
73. |
___________proposed the approach for data integration issues. |
A. | Ralph Campbell |
B. | Ralph Kimball |
C. | John Raphlin |
D. | James Gosling |
Answer» B. Ralph Kimball |
74. |
The terms equality and roll up are associated with__________. |
A. | OLAP |
B. | Visualization |
C. | Data mart |
D. | Decision tree |
Answer» C. Data mart |
75. |
Exceptional reporting in data warehousing is otherwise called as__________. |
A. | Exception |
B. | Alerts |
C. | Errors |
D. | Bugs |
Answer» B. Alerts |
76. |
_________is a metadata repository. |
A. | Prism solution directory manager |
B. | CORBA |
C. | STUNT |
D. | COBWEB |
Answer» A. Prism solution directory manager |
77. |
_________is an expensive process in building an expert system. |
A. | Analysis |
B. | Study |
C. | Design |
D. | Information collection |
Answer» D. Information collection |
78. |
The full form of KDD is__________. |
A. | Knowledge database |
B. | Knowledge discovery in database |
C. | Knowledge data house |
D. | Knowledge data definition |
Answer» B. Knowledge discovery in database |
79. |
The first International conference on KDD was held in the year_________. |
A. | 1996 |
B. | 1997 |
C. | 1995 |
D. | 1994 |
Answer» C. 1995 |
80. |
Removing duplicate records is a process called____________. |
A. | Recovery |
B. | Data cleaning |
C. | Data cleansing |
D. | Data pruning |
Answer» B. Data cleaning |
81. |
__________contains information that gives users an easy-to-understand perspective of the information stored in the data warehouse. |
A. | Business metadata |
B. | Technical metadata |
C. | Operational metadata |
D. | Financial metadata |
Answer» A. Business metadata |
82. |
_________helps to integrate, maintain and view the contents of the data warehousing system. |
A. | Business directory |
B. | Information directory |
C. | Data dictionary |
D. | Database |
Answer» B. Information directory |
83. |
Discovery of cross-sales opportunities is called _________. |
A. | Segmentation |
B. | Visualization |
C. | Correction |
D. | Association |
Answer» D. Association |
84. |
Data marts that incorporate data mining tools to extract sets of data are called_________. |
A. | Independent data mart |
B. | Dependent data marts |
C. | Intra-entry data mart |
D. | Inter-entry data mart |
Answer» B. Dependent data marts |
85. |
__________can generate programs itself, enabling it to carry out new tasks. |
A. | Automated system |
B. | Decision making system |
C. | Self-learning system |
D. | Productivity system |
Answer» D. Productivity system |
86. |
The power of self-learning system lies in___________. |
A. | Cost |
B. | Speed |
C. | Accuracy |
D. | Simplicity |
Answer» C. Accuracy |
87. |
Building the informational database is done with the help of ___________. |
A. | Transformation or propagation tools |
B. | Transformation tools only |
C. | Propagation tools only |
D. | Extraction tools |
Answer» A. Transformation or propagation tools |
88. |
How many components are there in a data warehouse? |
A. | Two |
B. | Three |
C. | Four |
D. | Five |
Answer» D. Five |
89. |
Which of the following is not a component of a data warehouse? |
A. | Metadata |
B. | Current detail data |
C. | Lightly summarized data |
D. | Component Key |
Answer» D. Component Key |
90. |
___________is data that is distilled from the low level of detail found at the current detailed leve. |
A. | Highly summarized data |
B. | Lightly summarized data |
C. | Metadata |
D. | Older detail data |
Answer» B. Lightly summarized data |
91. |
Highly summarized data is __________. |
A. | Compact and easily accessible |
B. | Compact and expensive |
C. | Compact and hardly accessible |
D. | Compact |
Answer» A. Compact and easily accessible |
92. |
A directory to help the DSS analyst locate the contents of the data warehouse isseen in __________. |
A. | Current detail data |
B. | Lightly summarized data |
C. | Metadata |
D. | Older detail data |
Answer» C. Metadata |
93. |
Metadata contains at least__________. |
A. | The structure of the data |
B. | The algorithms used for summarization |
C. | The mapping from the operational environment to the data warehouse |
D. | All of the above |
Answer» D. All of the above |
94. |
Which of the following is not a old detail storage medium? |
A. | Phot Optical Storage |
B. | RAID |
C. | Microfinche |
D. | Pen drive |
Answer» D. Pen drive |
95. |
The data from the operational environment enter_____________of data warehouse. |
A. | Current detail data |
B. | Older detail data |
C. | Lightly summarized data |
D. | Highly summarized data |
Answer» A. Current detail data |
96. |
The data in current detail level resides till__________event occurs. |
A. | Purge |
B. | Summarization |
C. | Archieve |
D. | D All of the above |
Answer» D. D All of the above |
97. |
The dimension tables describe the __________. |
A. | Entities |
B. | Facts |
C. | Keys |
D. | Units of measures |
Answer» B. Facts |
98. |
The granularity of the fact is the ___________ of detail at which it is recorded. |
A. | Transformation |
B. | Summarization |
C. | Level |
D. | Tr |
Answer» A. Transformation |
99. |
Which of the following is not a primary grain in analytical modeling. |
A. | Transaction |
B. | Periodic snapshot |
C. | Accumulating snapshot |
D. | All of the above |
Answer» B. Periodic snapshot |
100. |
Granularity is determined by___________. |
A. | Number of parts to a key |
B. | Granularity of those parts |
C. | Both A and B |
D. | None of the above |
Answer» C. Both A and B |
Done Reading?