Data Warehousing and Data Mining Set 3

Data Warehousing and Data Mining

Questions 21 to 30

Set 1 Set 2 Set 3

21. Multiple Regression means (a) Data are modeled using a straight line (b) Data are modeled using a curve line (c) Extension of linear regression involving only one predicator value (d) Extension of linear regression involving more than one predicator value (e) All (a), (b), (c) and (d) above. 22. Which of the following should not be considered for each dimension attribute? (a) Attribute name (b) Rapid changing dimension policy (c) Attribute definition (d) Sample data (e) Cardinality. 23. A Business Intelligence system requires data from: (a) Data warehouse (b) Operational systems (c) All possible sources within the organization and possibly from external sources (d) Web servers (e) Database servers. 24. Data mining application domains are (a) Biomedical  (b) DNA data analysis (c) Financial data analysis (d) Retail industry and telecommunication industry (e) All (a), (b), (c) and (d) above. 25. The generalization of multidimensional attributes of a complex object class can be performed by examining each attribute, generalizing each attribute to simple-value data and constructing a multidimensional data cube is called as (a) Object cube (b) Relational cube (c) Transactional cube (d) Tuple (e) Attribute. 26. Which of the following project is a building a data mart for a business process/department that is very critical for your organization? (a) High risk high reward (b) High risk low reward (c) Low risk low reward (d) Low risk high reward (e) Involves high risks. 27. Which of the following tools a business intelligence system will have? (a) OLAP tool (b) Data mining tool (c) Reporting tool (d) Both(a) and (b) above (e) (a), (b) and (c) above. 28. Which of the following is/are the Data mining tasks? (a) Regression (b) Classification (c) Clustering (d) inference of  associative rules (e) All (a), (b), (c) and (d) above. 29. In a data warehouse, if D1 and D2 are two conformed dimensions, then (a) D1 may be an exact replica of D2 (b) D1 may be at a rolled up level of granularity compared to D2 (c) Columns of D1 may be a subset of D2 and vice versa (d) Rows of D1 may be a subset of D2 and vice versa (e) All (a), (b), (c) and (d) above. 30. Which of the following is not an ETL tool? (a) Informatica (b) Oracle warehouse builder (c) Datastage (d) Visual studio (e) DT/studio.

Answers

      Ans                                           Explanation 

21. D Multiple Regression means extension of linear regression involving more than one predicator value.

22. B Rapid changing dimension policy should not be considered for each dimension attribute.

23. A A business Intelligence system requires data from Data warehouse

24. E Data mining application domains are Biomedical, DNA data analysis, Financial data analysis and Retail industry and telecommunication industry

25. A The generalization of multidimensional attributes of a complex object class can be performed by examining each attribute, generalizing each attribute to simple-value data and constructing a multidimensional data cube is called as object cube.

26. A High risk high reward project is a building a data mart for a business process/department that is very critical for your organization

27. A Business intelligence system will have OLAP, Data mining and reporting tolls.

28. E Regression, Classification and Clustering are the data mining tasks.

29. A In a data warehouse, if D1 and D2 are two conformed dimensions, then D1 may be an exact replica of D2.

30. D Visual Studio is not an ETL tool.