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.



58 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. 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
  6. You have a very good posting, I love it very well, your posting warehousing service in Gurgaon

    ReplyDelete
  7. 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
  8. Really Good blog post.provided a helpful data warehosuing and data mining aquestion and answers.keep updating...
    Digital marketing company in Chennai

    ReplyDelete
  9. IT series The Concepts of Information Technology Introduction to Computers & Information Technology Free Education Computers And Software Education website

    Visit: http://itseries.net

    itseries.net

    ReplyDelete
  10. This is extremely great information for these blog!! And Very good work. It is very interesting to learn from to easy understood. Thank you for giving information. Please let us know and more information get post to link.
    aws s3 interview questions

    ReplyDelete
  11. I believe there are many more pleasurable opportunities ahead for individuals that looked at your site.
    safety course in chennai

    ReplyDelete


  12. I enjoyed over read your blog post. Your blog have nice information, I got good ideas from this amazing blog. I am always searching like this type blog post. I hope I will see again.
    Deer Hunting Tips Camping Trips Guide DEER HUNTING TIPS travel touring tips

    ReplyDelete
  13. Nice Blog!! Thanks For Sharing!!!Wonderful blog & good post.Its really helpful for me, waiting for a more new post. Keep Blogging!
    Live Streaming Company in Bhubaneswar
    Server Management Company in Delhi

    ReplyDelete
  14. Ini juga dapat membantu kita untuk menang mudah dalam bermain, karena dengan sering bermain dan berlatih mempertajam insting dan feeling kita dalam bermain
    asikqq
    dewaqq
    sumoqq
    interqq
    pionpoker
    bandar ceme
    hobiqq
    paito warna terlengkap
    Syair HK

    ReplyDelete
  15. This is a nice article here with some useful tips for those who are not used-to comment that frequently. Thanks for this helpful information I agree with all points you have given to us. I will follow all of them.
    hadoop admin certification course

    ReplyDelete
  16. Nice explanations of Tech Cloud ERP’s Business Intelligence Tool, it's good to know that! A friend of mine has implemented a company which is the best ERP software in Hyderabad right now, she provides cloud based ERP software in Hyderabad, so I hope it goes well for her.
    Best Regards

    ReplyDelete
  17. Your very own commitment to getting the message throughout came to be rather powerful and have consistently enabled employees just like me to arrive at their desired goals.


    Best PHP Training Institute in Chennai|PHP Course in chennai

    Best .Net Training Institute in Chennai

    Software Testing Training in Chennai
    Blue Prism Training in Chennai
    Angularjs Training in Chennai

    ReplyDelete
  18. Amazing post! Thanks for sharing with us. You can also have a look at Digital Marketing Services. SreeMedia agency is one of the leading digital marketing services agency in offering no.1 Digital Marketing Services in Vijayawada.

    ReplyDelete
  19. Thanks for sharing valuable information and very well explained.
    ETL Testing Online Training
    ETL Course

    ReplyDelete
  20. Thank you for sharing such a beautiful information.I hope you will keep sharing such wonderful information in future.It is amazing and wonderful to visit your site.
    https://www.lcrenovation.co.uk/house-extensions/
    House Renovations in Clapham

    ReplyDelete

  21. That is nice article from you, this is informative stuff. Hope more articles from you . I also want to share some information about
    cognos online training

    ReplyDelete
  22. Superb explanation & it's too clear to understand the concept as well, keep sharing admin with some updated information with right examples. Keep update more posts. Nice Article! Thanks for sharing such amazing information.
    SEO Company
    Digital Marketing Service
    Digital Marketing company in Delhi

    ReplyDelete
  23. I wanted to thank you for this excellent read!! I definitely loved every little bit of it. I have you bookmarked your site to check out the new stuff you post. lhd caterpillar

    ReplyDelete
  24. Need help to make the major shift to a new ERP?, Nevas Technologies can help support your current Microsoft Dynamics NAV Environment irrespective of the version that you are on.We Provide Functional, Technical, Production support and infrastructure (Server Maintenance, Finetuning, and so on…) services for your current Navision application. We also provide upgrade services of your old MS Navision version to the latest Dynamics Navision 2016/2017/2018 versions if you are not ready to upgrade to Dynamics 365 Business Central or Unified Operations.

    ReplyDelete
  25. Hey, thanks for the article post.Really looking forward to read more. Really Great.
    sccm training
    sccm online training

    ReplyDelete
  26. I appreciate this piece of useful information,Thank You ,I also want to share information aboutBest Sweets in Hyderabad

    ReplyDelete
  27. Dynamics 365 supply chain management Manage and create your projects using timesheets and advanced reporting and cost forecasting technologies. Control budgets to ensure your profitability.

    ReplyDelete
  28. I really enjoyed all of articles on this website, I hope you will continue to have similar posts to share with everyone.
    WD1600BEAE

    ReplyDelete
  29. Western Overseas is Best Regional Business Partner Award Winner in IELTS by Australia and Gold Member of British Council. Its Time to Apply yourself towards Success . Take your right decision at right time.

    ReplyDelete
  30. It comes with an active substance of Bimatprost Opthalmic Solution 3ml.
    Buy Bimat 3ml Eye Drop
    Contact : +91 92163-25377

    ReplyDelete
  31. Good one. At our website www.naattumarundhu.com, once can purchase Siddha and Ayurveda products online. Door delivery is available for free for orders above Rs. 2000.

    ReplyDelete
  32. Offering Fullz & Tools with tutorials

    USA Database SSN DOB DL Fullz/Pros
    High CS Pros 700+
    DUMPS with Pins & CC's With CVV+SSN Info
    TAX Return Filling Fullz/Pros
    Bulk Fullz with valid & Guaranteed Results

    For Order Contact Below :
    --------------------------
    --------------------------
    WA - +92-317-2721122
    TG/ICQ - @killhacks
    Email - exploit(dot)tools4u at Gmail(dot)com
    Wickr/Skype - @peeterhacks

    OTHER GADGETS :

    Business EIN Fullz
    Loan Applying & Carding Updates Methods
    Tutorials & Tools for Spamming CC/Logs/Personal Info/Bank Account Info
    Hac-king Stuff with complete guide, tools & Tutorials
    Kali Linux Master Class/Python Complete Course
    WA/FB/PayPal Hacking & Spamming stuff
    2021/2022 Fra*d Bib*e updated
    Mailers/Shells/C-panels
    RDP's/SMTP's/Key Loggers/Viruses

    Email - exploit(dot)tools4u at Gmail(dot)com
    Wickr/Skype - @peeterhacks
    WA - +92-317-2721122
    TG/ICQ - @killhacks

    Many other stuff we can provide on demand, just ordered
    Hot & Cool stuff with Legit providers
    feel free to contact

    ReplyDelete