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