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.



14 comments :

  1. Excellent Post! It's too helpful for the freshers to explore their knowledge in data warehousing.
    Regards,
    Informatica training in chennai

    ReplyDelete

  2. Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging…
    Regards,
    ccna course in Chennai|ccna training in Chennai

    ReplyDelete
  3. Hi Admin,
    This information is impressive; I am inspired with your post writing style & how continuously you describe this topic. After reading your post, thanks for taking the time to discuss this, I feel happy about it and I love learning more about this topic.
    Regards,
    sas training in Chennai|sas course in Chennai|sas training institute in Chennai

    ReplyDelete
  4. Thanks for your great information, the contents are quiet interesting.
    Chicago Third Party Logistic Warehouse

    ReplyDelete
  5. Well Said, you have furnished the right information that will be useful to anyone at all time. Thanks for sharing your Ideas.
    Python Training in Chennai | Python Course in Chennai

    ReplyDelete
  6. Thanks for sharing this unique and informative content which provided me the required information.
    Java Training in Chennai | JAVA Course in Chennai

    ReplyDelete