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. | integrated. |
D. | all of the above. |
Answer» 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. | datamarts. |
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. | 40 percent |
D. | 80 percent. |
Answer» D. 80 percent. |
We're developing a website for study materials for students.
We would love to hear your answers to some of the questions.