Data Warehousing and Data Mining Set 2

Data Warehousing and Data Mining 

Questions 11 to 21

Set 1 Set 2 Set 3

11. Data modeling technique used for data marts is (a) Dimensional modeling (b) ER – model (c) Extended ER – model (d) Physical model (e) Logical model. 12. A warehouse architect is trying to determine what data must be included in the warehouse. A meeting has been arranged with a business analyst to understand the data requirements, which of the following should be included in the agenda? (a) Number of users (b) Corporate objectives (c) Database design (d) Routine reporting (e) Budget. 13. An OLAP tool provides for (a) Multidimensional analysis (b) Roll-up and drill-down (c) Slicing and dicing (d) Rotation (e) Setting up only relations. 14. The Synonym for data mining is (a) Data warehouse (b) Knowledge discovery in database (c) ETL (d) Business intelligence (e) OLAP. 15. Which of the following statements is true? (a) A fact table describes the transactions stored in a DWH (b) A fact table describes the granularity of data held in a DWH (c) The fact table of a data warehouse is the main store of descriptions of the transactions stored in a DWH (d) The fact table of a data warehouse is the main store of all of the recorded transactions over time (e) A fact table maintains the old records of the database. 16. Most common kind of queries in a data warehouse (a) Inside-out queries (b) Outside-in queries (c) Browse queries (d) Range queries (e) All (a), (b), (c) and (d) above. 17. Concept description is the basic form of the (a) Predictive data mining (b) Descriptive data mining (c) Data warehouse (d) Relational data base (e) Proactive data mining. 18. The apriori property means (a) If a set cannot pass a test, all of its supersets will fail the same test as well (b) To improve the efficiency the level-wise generation of frequent item sets (c) If a set can pass a test, all of its supersets will fail the same test as well (d) To decrease the efficiency the level-wise generation of frequent item sets (e) All (a), (b), (c) and (d) above. 19. Which of following form the set of data created to support a specific short lived business situation? (a) Personal data marts (b) Application models (c) Downstream systems (d) Disposable data marts (e) Data mining models. 20. What is/are the different types of Meta data? I. Administrative. II. Business. III. Operational. (a) Only (I) above (b) Both (II) and (III) above (c) Both (I) and (II) above (d) Both (I) and (III) above (e) All (I), (II) and (III) above.

Answers

      Ans                               Explanation

11. A Data modeling technique used for data marts is Dimensional modeling.

12. D Routine reporting should be included in the agenda.

13. C An OLAP tool provides for Slicing and dicing.

14. C The synonym for data mining is Knowledge discovery in Database.

15. D The fact table of a data warehouse is the main store of all of the recorded transactions over time is the correct statement.

16. A The Most common kind of queries in a data warehouse is Inside-out queries.

17. B Concept description is the basis form of the descriptive data mining.

18. B The apriori property means to improve the efficiency the level-wise generation of frequent item sets.

19. D Disposable Data Marts is the form the set of data created to support a specific short lived business situation.

20. E The different types of Meta data are Administrative, Business and Operational.