Data Warehousing and Data Mining mcq

 

Data Warehousing and Data Mining 

Questions 11 To 21

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. (A) Data modeling technique used for data marts is Dimensional modeling. 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. (D) Routine reporting should be included in the agenda. 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. (C) An OLAP tool provides for Slicing and dicing. 14. The Synonym for data mining is (a) Data warehouse (b) Knowledge discovery in database (c) ETL (d) Business intelligence (e) OLAP. (C) The synonym for data mining is Knowledge discovery in Database. 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. (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. 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. (A) The Most common kind of queries in a data warehouse is Inside-out queries. 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. (B) Concept description is the basis form of the descriptive 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. (B) The apriori property means to improve the efficiency the level-wise generation of frequent item sets. 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. (D) Disposable Data Marts is the form the set of data created to support a specific short lived business situation. 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. (E) The different types of Meta data are Administrative, Business and Operational.