Business Intelligence & Analytics Week 1 NPTEL Assignment Answers 2025

NPTEL Business Intelligence & Analytics Week 1 Assignment Answers 2024

Q1. What concept does the phrase “turning data tombs into ‘golden nuggets’ of knowledge” signify with respect to data mining?

a) The transformation of extensive data reserves into valuable insights and knowledge.
b) The replacement of conventional data repositories with intuitive decision-making tools.
c) The extraction of specific data sets for expert systems’ utilization.
d) The integration of data archives with cutting-edge data mining technologies.

Answer: a
Explanation:
This metaphor highlights the value extraction from vast, unprocessed data (the “tombs”) to derive actionable knowledge (the “nuggets”).

---

Q2. Which step involves the extraction of data patterns using intelligent methods?

a) Data cleaning
b) Data integration
c) Data selection
d) Data mining

Answer: d
Explanation:
Data mining is the process of discovering patterns, correlations, trends, and useful information from large data sets using statistical, machine learning, or AI methods.

---

Q3. What is the primary purpose of data mining in the context of the data age?

a) Storing and organizing massive amounts of data
b) Creating social networks and communities
c) Uncovering valuable information from vast data and converting it into organized knowledge
d) Supporting scientific experiments and observations

Answer: c
Explanation:
Data mining aims to extract meaningful patterns from big data, aiding in decision-making and strategic planning.

---

Q4. Which technology contributed substantially to the evolution and wide acceptance of relational technology for efficient storage, retrieval, and management of large amounts of data?

a) Advanced indexing and accessing methods
b) Online transaction processing (OLTP)
c) Hierarchical database systems
d) Object-oriented database models

Answer: a
Explanation:
Advanced indexing and data access methods greatly improved performance and scalability, making relational databases efficient and widely used.

---

Q5. What does the architecture of a data warehouse primarily aim to facilitate?

a) Data cleaning and integration
b) Advanced query optimization
c) Management decision making
d) Real-time data processing

Answer: c
Explanation:
A data warehouse is designed to help with strategic decisions by providing integrated, historical, and summarized data to managers.

---

Q6. What is the primary advantage of using data warehouse systems for OLAP?

a) Providing detailed transactional views to users
b) Performing daily transaction analysis
c) Presenting data at different levels of abstraction
d) Enabling real-time data updates and modifications

Answer: c
Explanation:
OLAP (Online Analytical Processing) enables users to analyze data hierarchically, e.g., monthly, quarterly, or yearly reports.

---

Q7. What defines outliers in a dataset?

a) Objects that conform to the general behaviour or model of the data.
b) Data objects that are commonly discarded as exceptions.
c) Data that adhere strictly to statistical or distance measures.
d) Objects that deviate from the general behaviour or model of the data.

Answer: d
Explanation:
Outliers are data points that do not fit the expected pattern or distribution and may indicate anomalies or errors.

---

Q8. How does data mining benefit from scalable database technologies?

a) It diminishes efficiency and scalability on large datasets
b) It relies solely on traditional database systems
c) It enables high efficiency and scalability on large datasets
d) It limits scalability to small datasets for efficiency

Answer: c
Explanation:
Scalable technologies allow data mining to handle big data efficiently, which is critical in modern applications.

---

Q9. What distinguishes Descriptive Analytics from other types of analytics?

a) It focuses on predicting future outcomes.
b) It identifies patterns and trends from past data.
c) It prescribes actions based on analyzed data.
d) It evaluates data in real-time for immediate decisions.

Answer: b
Explanation:
Descriptive analytics answers “what happened” by summarizing past data to identify trends and patterns.

---

Q10. Which phase in the knowledge discovery process involves the removal of noise and inconsistent data?

a) Data integration
b) Data transformation
c) Data cleaning
d) Data selection

Answer: c
Explanation:
Data cleaning ensures quality by removing incorrect, inconsistent, or noisy data, making it suitable for analysis.

---

Q11. In the context of data preprocessing, what is the purpose of data transformation?

a) To retrieve relevant data from the database
b) To remove noise and inconsistent data
c) To prepare data for mining by performing summary or aggregation operations
d) To evaluate interesting patterns based on specific measures

Answer: c
Explanation:
Data transformation includes normalization, summarization, or aggregation to make the data suitable for mining algorithms.

---

Q12. What is the fundamental characteristic of a relational database?

a) It consists of a collection of tables with unique names.
b) It uses graphs or networked structures to store data.
c) It primarily stores multimedia data and text data.
d) It represents the database as a set of entities and their relationships.

Answer: a
Explanation:
Relational databases are structured as tables (relations), each with unique names, storing rows and columns of data.

---

Q13. Which of the following can be called as a major driver of Data Mining?

a) Decline of open-source technologies
b) Declining growth in Manufacturing sector globally
c) Penetration of MOOC platforms
d) Rise of transaction processing systems/ERPs

Answer: d
Explanation:
The growth of ERP and transactional systems has led to massive data generation, creating a need for data mining tools.

---

Q14. What does the “long tail” phenomenon refer to in business?

a) A marketing strategy focused on a narrow customer base
b) The distribution of sales that extends to less common products returning substantial profits
c) A strategy to increase product diversity without considering market demand
d) A method to minimize inventory costs in retail businesses

Answer: b
Explanation:
The long tail shows that niche products can collectively generate more revenue than a few mainstream bestsellers.

---

Q15. What can you infer from the following graph?

a) Less travelled destinations are growing more popular with each passing year
b) Top travel destinations are becoming more popular with each passing year
c) The growth of ICT evidently played an important role in making least popular places more popular
d) The growth of social media evidently played an important role in making least popular places more popular

Answer: d
Explanation:
The graph likely shows how social media influence makes lesser-known destinations more visible and attractive, shifting tourism trends.