Please help me check my answers for this study guide. I will thumbs up. I believe the answers are:

1. A 2. D 3. D 4. A 5. A 6. C 7. B 8. E 9. D 10. D 11. C 12. C 13. D 14. C 15. D

1) In a Data Warehouse, what are the typical daily operations? a) Insert, Update, Delete and Select statements. b) Update and Select statements only. c) Insert in batch (large groups) and Select involving many records. d) Interactive Insert and Select. Answer: A 2) Data Warehouses are typically ... a) Small Databases belonging to only one department. b) A large database belonging to only one department. c) Small databases belonging to many departments. d) A very large databases belonging to many departments. 3) Typical users of the Data Warehouse are ... a) Walmart. b) Target. c) Operational Clerks. d) Business Analysts and Upper Management. 4) Which of the following is considered a sub-set of a Data Warehouse or a mini-Data Warehouse. 10) The following is typical of Data Mining? a) Data Mart. a) It works on large sets of data such as a Data Warehouse (typically historical data). b) Data Store. b) It works in many different fields such as hurricane predictions, stock market c) Staging Area. predictions and security (detecting cyberattacks). d) Materialized Views. c) It can use Al, Statistic, Neural Networks as well as other techniques. d) All the above. 5) Which of the following can be viewed as a sophisticated Staging Area where the enduser of a Datawarehouse may be able to query data from? 11) Which of the following is true about a Data Warehouse? a) Data Mart. a) It must be stored in an Oracle Database. b) Data Store. b) It must be stored in a DBMS that runs under MS-Windows. c) Data Mining. d) Materialized Views. c) It can be implemented with any DBMS, but it is typically recommended to use an enterprise DBMS such as Oracle, IBM-DB2, POSTGRES or MS-SQL Server. d) Is cheap and easy to implement. 6) Knowledge Discovery by detecting certain patterns in your data can also be called ... a) Data Mart. b) Data Store. 12) Which is true about a Data Warehouse with Independent Data Marts? c) Data Mining. d) Materialized Views. a) It is better for ETL. b) It is better for queries. 7) ETL stands for ... c) It is better for ETL and queries. a) Evaluate, Truncate and Lease. b) Extract, Transform and Load. d) The advantage over a conventional Data Warehouse is that it is not vendor c) Evaluate, Transform, Load. d) Extract, Terminate and Load. specific. 8) Artificial Intelligence ... 13) The Dictionary of a Data Warehouse should contain ... a) Can be defined as the area of computer science that humans still outperform a) Where the data is coming from. computers in. AKA computers have not progressed to the level of cognitive thinking b) During what period is the data imported (Loaded/Inserted). as humans. c) How is the data converted. b) Deals with non-deterministic problems. d) All of the above. c) Is an area of computer science that tries to make the computers behave more like 14) Which of the following statements is true about a Data Warehouse? humans. a) The data and the structure are updated less than an OLTP database. d) Has as its main contributors Alan Turing, Marvin Minski, Roger Schank and John b) The data is updated less than an OLTP database, but the structure is updated more. McCarthy (not Paul McCarthy (long live the Beatles) and not Joe McCarthy (who?). c) The data is updated more than an OLTP database, but the structure is updated less. e) All the above, d) The data and the structure are updated more than an OLTP database. 9) Which of the following would you expect from a Data Warehouse? 15) Which is true about a Data Warehouse? a) Smaller block (page) size and no Indexing. a) Data should only be loaded once a day. b) Only current data. b) Data should be loaded more than once a day. c) Tedious on-line Update Operations. c) Data should be loaded less than once a day. d) More indexes and bigger block sizes. d) Data should be loaded according to the business requirements, although it is typically loaded once a day