Hello learners In this article we are going to discuss NPTEL Business Intelligence & Analytics Assignment 2 Answers. All the Answers provided below to help the students as a reference, You must submit your assignment with your own knowledge and use this article as reference only.
About the course:-
This course equips students with necessary knowledge and skills on the thought process, modelling approaches and tools required to use data from the enterprise databases and other sources for business decisions. In turn, the course prepares participants for a career in data science, business analytics and market research. This course will introduce the context of data mining, and cover important modelling techniques such as regression, decision trees, clustering, ANN and text mining.
NPTEL Business Intelligence & Analytics Assignment 2 Answers 2024:
1. Which term describes the practice of making decisions purely on data analysis rather than intuition?
Answer :- c
2. What characterizes the primary function of databases supporting Online Transaction Processing (OLTP)?
Answer :- c
3. What does the acronym ACID stand for in the context of databases?
Answer :- c
4. What primarily distinguishes Online Analytical Processing (OLAP) from Online Transaction Processing (OLTP)?
Answer :- c
5. Which of the following best describes a data warehouse?
Answer :- b
6. Why does a data warehouse not require transaction processing, recovery, and concurrency control mechanisms?
Answer :- c
7. Which data warehouse model spans the entire organization and provides corporate-wide data integration?
Answer :- c
8. What distinguishes a data mart from an enterprise warehouse?
Answer :- d
9. Which function of back-end tools in data warehouse systems involves rectifying errors detected in the data?
Answer :- b
10. What is the first step in the ETL process?
Answer :- c
11. Which of the following gives a logical structure of the database graphically?
Answer :- a
12. Which type of DBMS language is used to create the database schema?
Answer :- c
13. Which Data Manipulation command is used to add a new record in a database?
Answer :- b
14. What does the atomicity property of the ACID database guarantee in a transaction?
Answer :- b
15. What problem does the ACID property of isolation address?
Answer :- b
