McqMate
1. |
The data Warehouse is__________. |
A. | read only. |
B. | write only. |
C. | read write only. |
D. | none. |
Answer» A. read only. |
2. |
The important aspect of the data warehouse environment is that data found within the data warehouse is___________. |
A. | subject-oriented. |
B. | time-variant. |
C. | integrated. |
D. | All of the above. |
Answer» D. All of the above. |
3. |
__________ 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. |
4. |
The biggest drawback of the level indicator in the classic star-schema is that it limits_________. |
A. | quantify. |
B. | qualify. |
C. | flexibility. |
D. | ability. |
Answer» C. flexibility. |
5. |
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. |
6. |
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. |
7. |
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. |
8. |
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. |
9. |
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. |
10. |
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 added. |
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. |
11. |
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 support systems. |
Answer» B. capturing a subset of the data contained in various operational systems. |
12. |
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 |
13. |
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. |
14. |
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. |
15. |
____________ 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. |
16. |
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. |
17. |
Fact tables are ___________. |
A. | completely demoralized. |
B. | partially demoralized. |
C. | completely normalized. |
D. | partially normalized. |
Answer» C. completely normalized. |
18. |
_______________ 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. |
19. |
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. |
20. |
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. |
21. |
The most common source of change data in refreshing a data warehouse is _______. |
A. | queryable change data. |
B. | cooperative change data. |
C. | logged change data. |
D. | snapshot change data. |
Answer» A. queryable change data. |
22. |
________ 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. |
23. |
Query tool is meant for __________. |
A. | data acquisition. |
B. | information delivery. |
C. | information exchange. |
D. | communication. |
Answer» A. data acquisition. |
24. |
Classification rules are extracted from _____________. |
A. | root node. |
B. | decision tree. |
C. | siblings. |
D. | branches. |
Answer» B. decision tree. |
25. |
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. |
26. |
___________ is a method of incremental conceptual clustering. |
A. | CORBA. |
B. | OLAP. |
C. | COBWEB. |
D. | STING. |
Answer» C. COBWEB. |
27. |
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. |
28. |
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. |
29. |
Multidimensional database is otherwise known as____________. |
A. | RDBMS |
B. | DBMS |
C. | EXTENDED RDBMS |
D. | EXTENDED DBMS |
Answer» B. DBMS |
30. |
Data warehouse architecture is based on ______________. |
A. | DBMS. |
B. | RDBMS. |
C. | Sybase. |
D. | SQL Server. |
Answer» B. RDBMS. |
31. |
Source data from the warehouse comes from _______________. |
A. | ODS. |
B. | TDS. |
C. | MDDB. |
D. | ORDBMS. |
Answer» A. ODS. |
32. |
________________ is a data transformation process. |
A. | Comparison. |
B. | Projection. |
C. | Selection. |
D. | Filtering. |
Answer» D. Filtering. |
33. |
The technology area associated with CRM is _______________. |
A. | specialization. |
B. | generalization. |
C. | personalization. |
D. | summarization. |
Answer» C. personalization. |
34. |
SMP stands for _______________. |
A. | Symmetric Multiprocessor. |
B. | Symmetric Multiprogramming. |
C. | Symmetric Metaprogramming. |
D. | Symmetric Microprogramming. |
Answer» A. Symmetric Multiprocessor. |
35. |
__________ 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. |
36. |
MDDB stands for ___________. |
A. | multiple data doubling. |
B. | multidimensional databases. |
C. | multiple double dimension. |
D. | multi-dimension doubling. |
Answer» B. multidimensional databases. |
37. |
______________ is data about data. |
A. | Metadata. |
B. | Microdata. |
C. | Minidata. |
D. | Multidata. |
Answer» A. Metadata. |
38. |
___________ is an important functional component of the metadata. |
A. | Digital directory. |
B. | Repository. |
C. | Information directory. |
D. | Data dictionary. |
Answer» C. Information directory. |
39. |
EIS stands for ______________. |
A. | Extended interface system. |
B. | Executive interface system. |
C. | Executive information system. |
D. | Extendable information system. |
Answer» C. Executive information system. |
40. |
___________ is data collected from natural systems. |
A. | MRI scan. |
B. | ODS data. |
C. | Statistical data. |
D. | Historical data. |
Answer» A. MRI scan. |
41. |
_______________ is an example of application development environments. |
A. | Visual Basic. |
B. | Oracle. |
C. | Sybase. |
D. | SQL Server. |
Answer» A. Visual Basic. |
42. |
The term that is not associated with data cleaning process is ______. |
A. | domain consistency. |
B. | deduplication. |
C. | disambiguation. |
D. | segmentation. |
Answer» D. segmentation. |
43. |
____________ are some popular OLAP tools. |
A. | Metacube, Informix. |
B. | Oracle Express, Essbase. |
C. | HOLAP. |
D. | MOLAP. |
Answer» A. Metacube, Informix. |
44. |
Capability of data mining is to build ___________ models. |
A. | retrospective. |
B. | interrogative. |
C. | predictive. |
D. | imperative. |
Answer» C. predictive. |
45. |
_____________ is a process of determining the preference of customer's majority. |
A. | Association. |
B. | Preferencing. |
C. | Segmentation. |
D. | Classification. |
Answer» B. Preferencing. |
46. |
Strategic value of data mining is ______________. |
A. | cost-sensitive. |
B. | work-sensitive. |
C. | time-sensitive. |
D. | technical-sensitive. |
Answer» C. time-sensitive. |
47. |
____________ proposed the approach for data integration issues. |
A. | Ralph Campbell. |
B. | Ralph Kimball. |
C. | John Raphlin. |
D. | James Gosling. |
Answer» B. Ralph Kimball. |
48. |
The terms equality and roll up are associated with ____________. |
A. | OLAP. |
B. | visualization. |
C. | data mart. |
D. | decision tree. |
Answer» C. data mart. |
49. |
Exceptional reporting in data warehousing is otherwise called as __________. |
A. | exception. |
B. | alerts. |
C. | errors. |
D. | bugs. |
Answer» B. alerts. |
50. |
____________ is a metadata repository. |
A. | Prism solution directory manager. |
B. | CORBA. |
C. | STUNT. |
D. | COBWEB. |
Answer» A. Prism solution directory manager. |
51. |
________________ is an expensive process in building an expert system. |
A. | Analysis. |
B. | Study. |
C. | Design. |
D. | Information collection. |
Answer» D. Information collection. |
52. |
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. |
53. |
The first International conference on KDD was held in the year _____________. |
A. | 1996. |
B. | 1997. |
C. | 1995. |
D. | 1994. |
Answer» C. 1995. |
54. |
Removing duplicate records is a process called _____________. |
A. | recovery. |
B. | data cleaning. |
C. | data cleansing. |
D. | data pruning. |
Answer» B. data cleaning. |
55. |
____________ 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. |
56. |
_______________ 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. |
57. |
Discovery of cross-sales opportunities is called ________________. |
A. | segmentation. |
B. | visualization. |
C. | correction. |
D. | association. |
Answer» D. association. |
58. |
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. |
59. |
____________ 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. |
60. |
The power of self-learning system lies in __________. |
A. | cost. |
B. | speed. |
C. | accuracy. |
D. | simplicity. |
Answer» C. accuracy. |
61. |
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. |
62. |
How many components are there in a data warehouse? |
A. | two. |
B. | three. |
C. | four. |
D. | five. |
Answer» D. five. |
63. |
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. |
64. |
________ 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. |
65. |
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. |
66. |
A directory to help the DSS analyst locate the contents of the data warehouse is seen in ______. |
A. | Current detail data. |
B. | Lightly summarized data. |
C. | Metadata. |
D. | Older detail data. |
Answer» C. Metadata. |
67. |
Metadata contains atleast _________. |
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. |
68. |
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. |
69. |
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. |
70. |
The data in current detail level resides till ________ event occurs. |
A. | purge. |
B. | summarization. |
C. | archieved. |
D. | all of the above. |
Answer» D. all of the above. |
71. |
The dimension tables describe the _________. |
A. | entities. |
B. | facts. |
C. | keys. |
D. | units of measures. |
Answer» B. facts. |
72. |
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. |
73. |
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. |
74. |
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. |
75. |
___________ of data means that the attributes within a given entity are fully dependent on the entire primary key of the entity. |
A. | Additivity. |
B. | Granularity. |
C. | Functional dependency. |
D. | Dimensionality. |
Answer» C. Functional dependency. |
76. |
A fact is said to be fully additive if ___________. |
A. | it is additive over every dimension of its dimensionality. |
B. | additive over atleast one but not all of the dimensions. |
C. | not additive over any dimension. |
D. | None of the above. |
Answer» A. it is additive over every dimension of its dimensionality. |
77. |
A fact is said to be partially additive if ___________. |
A. | it is additive over every dimension of its dimensionality. |
B. | additive over atleast one but not all of the dimensions. |
C. | not additive over any dimension. |
D. | None of the above. |
Answer» B. additive over atleast one but not all of the dimensions. |
78. |
A fact is said to be non-additive if ___________. |
A. | it is additive over every dimension of its dimensionality. |
B. | additive over atleast one but not all of the dimensions. |
C. | not additive over any dimension. |
D. | None of the above. |
Answer» C. not additive over any dimension. |
79. |
Non-additive measures can often combined with additive measures to create new _________. |
A. | additive measures. |
B. | non-additive measures. |
C. | partially additive. |
D. | All of the above. |
Answer» A. additive measures. |
Done Reading?