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.



26 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
  7. Such a nice blog. I really like the information provided regarding Warehouses. Hope to get some more information in future also. 
    Chicago Ambient Warehouse

    ReplyDelete
  8. I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in Data Mining, kindly contact us http://www.maxmunus.com/contact
    MaxMunus Offer World Class Virtual Instructor led training on Data Mining. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.

    For Free Demo Contact us:
    Name : Arunkumar U
    Email : arun@maxmunus.com
    Skype id: training_maxmunus
    Contact No.-+91-9738507310
    Company Website –http://www.maxmunus.com


    ReplyDelete
  9. You have a very good posting, I love it very well, your posting warehousing service in Gurgaon

    ReplyDelete
  10. I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in Data Science with SAS Training, kindly contact us http://www.maxmunus.com/contact
    MaxMunus Offer World Class Virtual Instructor led training on TECHNOLOGY. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
    For Demo Contact us.
    Sangita Mohanty
    MaxMunus
    E-mail: sangita@maxmunus.com
    Skype id: training_maxmunus
    Ph:(0) 9738075708 / 080 - 41103383
    http://www.maxmunus.com/

    ReplyDelete
  11. Great post! I am see the programming coding and step by step execute the outputs.I am gather this coding more information. It's helpful for me my friend. Also great blog here with all of the valuable information you have.
    Data Warehousing Training in Chennai

    ReplyDelete