| 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. | |