Business Intelligence & Analytics Week 2 Nptel Answers 2026
Are you looking for Nptel Business Intelligence & Analytics Week 2 Answers 2026? You are here at right place for assignment answers.
Table of Contents
Nptel Business Intelligence & Analytics Week 2 Answers (Jan-Apr 2026)
Que.1
In a snowflake schema, some dimension tables are split into smaller, related tables to reduce redundancy and save storage space. This process is known as ________.
a) Normalization
b) Denormalization
c) Aggregation
d) Indexing
Que.2
According to the lecture, which of the following is a behavioral indicator used to help determine the Bizocity score?
a) The duration of a customer’s contract
b) The customer’s demographic profile
c) Whether calls are made during day hours
d) The number of services subscribed to by the customer
Que.3
Making organizational decisions based on analytical evidence rather than intuition is referred to as ________.
a) Data Engineering
b) Data-Driven Decision Making
c) Data Science
d) Prescriptive Analytics
Que.4
A ______ is a repository designed for analytical use, kept separate from an organization’s ______ to ensure that historical data can be consolidated and examined effectively.
a) Data warehouse; operational databases
b) Data mart; transactional systems
c) Data warehouse; data marts
d) Operational data store (ODS); analytical databases
Que.5
True or False: A data warehouse is typically created from a single homogeneous source, and techniques such as data cleaning and integration are used to standardize naming, encoding, and attribute formats.
a) True
b) False
Que.6
According to W.H. Inmon’s definition, which combination reflects the properties that differentiate data warehouses from traditional operational databases?
a) Subject-oriented, integrated, time-variant, and non-volatile
b) Application-oriented, integrated, real-time, and volatile
c) Subject-oriented, decentralized, time-invariant, and non-volatile
d) Subject-oriented, integrated, time-variant, and volatile
Que.7
A corporate company wants to build a centralized, integrated data repository that consolidates historical data from its Finance, Marketing, and Operations departments to support decision-making across the entire organization. Which type of data storage architecture best fits this requirement?
a) Data mart
b) Virtual warehouse
c) Operational databases
d) Enterprise warehouse
Que.8
Which function of back-end tools in data warehouse systems involves converting data from host formats into a consistent structure suitable for loading into the warehouse?
a) Data extraction
b) Data cleaning
c) Data transformation
d) Load
Que.9
Which statement correctly highlights a key difference between a data lake and a data warehouse?
a) A data warehouse stores all data types in raw form, while a data lake only stores structured data
b) A data warehouse loads data according to predefined schemas, whereas a data lake can store all types of data without requiring a fixed schema
c) A data lake accepts only numerical and categorical attributes, while a data warehouse stores multimedia content
d) A data lake transforms data before ingestion, while a data warehouse transforms data only when it is queried
Que.10
The NPTEL platform stores lecture videos, course materials, discussion forum logs, and student activity data in their raw form to support large-scale learning analytics. Such a storage system is best described as a ________.
a) Data warehouse
b) Data mart
c) Data lake
d) Transactional database
Que.11
Which statement correctly distinguishes the data models commonly used in OLTP and OLAP systems?
a) OLTP systems use star or snowflake schemas, while OLAP systems use ER models
b) Both OLTP and OLAP systems rely on subject-oriented database schemas
c) OLTP systems adopt ER models while OLAP systems use star or snowflake schemas
d) OLAP systems primarily use flat files, whereas OLTP systems use multidimensional cubes
Que.12
Following the Indian women’s basketball team’s victory in the SABA Women’s Championship 2025, the national sports federation plans to implement a centralized DBMS to manage player statistics, performance analytics, and training records across all regional training centers. What is the primary benefit of this approach?
a) All the options given
b) Enhanced data security and privacy through controlled access and protection of sensitive athlete information
c) Efficient retrieval and analysis of data to support coaching decisions, talent scouting, and tournament planning
d) Improved data consistency and accuracy across training centers, ensuring uniform and reliable player performance records
Que.13
When a person pays their electricity bill through a UPI app, the system ensures that the transfer satisfies all database constraints, such as ensuring the sender has sufficient funds and the total money in the system remains constant. Which ACID property guarantees this?
a) Atomicity
b) Consistency
c) Isolation
d) Durability
Que.14
Which data warehouse design features a central fact table connected to single, denormalized dimension tables for each dimension?
a) Network schema
b) Snowflake schema
c) Fact constellation
d) Star schema
Que.15
Which DBMS language is responsible for defining structures such as tables, views, and constraints before data is stored?
a) Data Manipulation Language
b) Data Query Language
c) Data Definition Language
d) Transaction Control Language
(Jan-Apr 2025)
Course link: Click here
1) Data warehouses provide:
Options:
[a] Data mining tools for interactive analysis of multidimensional data of varied granularities.
[b] Online Analytical Processing (OLAP).
[c] Transaction processing.
[d] Data visualization.
2) What was the primary business problem faced by AT&T Long Distance?
Options:
[a] Inefficient telemarketing campaigns.
[b] Difficulty in acquiring new customers.
[c] Lack of technology for data analysis.
[d] Insufficient funding for marketing.
Nptel Business Intelligence & Analytics Week 2 Answers (Jan-Apr 2025)
3) What is the purpose of data cleaning and integration techniques in the construction of a data warehouse?
Options:
[a] To enhance the speed of data retrieval.
[b] To ensure consistency in naming conventions, encoding structures, and attribute measures.
[c] To permanently delete irrelevant data.
[d] To store data in multiple formats for redundancy.
4) Which of the following best describes the “nonvolatile” nature of data in a data warehouse?
Options:
[a] Data is constantly changing and requires frequent updates.
[b] Data remains stable and is not subject to regular deletions or modifications.
[c] Data is always accessed for real-time transactions.
[d] Data is stored temporarily and can be easily altered.
Nptel Business Intelligence & Analytics Week 2 Answers (Jan-Apr 2025)
5) An OLTP system usually adopts an
Options:
[a] Hierarchical data model.
[b] Entity-Relationship data model.
[c] Object-Relational data model.
[d] Network data model.
6) What is the primary characteristic of OLAP system access patterns?
Options:
[a] Frequent updation and live alteration to the data.
[b] Real-time transaction processing.
[c] Primarily read-only operations.
[d] Atomic transactions.
7) Why is it not recommended to process complex OLAP queries on operational databases?
Options:
[a] It can increase the risk of security breaches.
[b] It can lead to data inconsistencies.
[c] It can significantly degrade the performance of transactional operations.
[d] Incompatible with operational data structures.
Nptel Business Intelligence & Analytics Week 2 Answers (Jan-Apr 2025)
8) Which of the following is a key function of back-end tools and utilities in a data warehouse system?
Options:
[a] Query optimization.
[b] Data extraction and transformation.
[c] User interface design.
[d] Data visualization.
9) What is a major challenge associated with data loading in large-scale data warehouses?
Options:
[a] Ensuring data consistency across multiple sources.
[b] Managing distributed loading and performance optimization.
[c] Preventing data loss during the loading process.
[d] Ensuring data privacy and security during the loading process.
10) What is the primary difference between an enterprise data warehouse and a data mart?
Options:
[a] Enterprise data warehouses are more complex to implement and need more technical expertise than data marts.
[b] Data marts are primarily used for strategic decision-making, while enterprise data warehouses are for tactical decisions.
[c] Enterprise data warehouses provide a comprehensive view of the entire organization’s data, while data marts focus on specific business areas.
[d] Data marts are more expensive to maintain than enterprise data warehouses.
Nptel Business Intelligence & Analytics Week 2 Answers (Jan-Apr 2025)
11) What is a potential drawback of using a virtual warehouse?
Options:
[a] Increased load on operational databases.
[b] High implementation costs.
[c] Limited scalability and performance.
[d] Difficulty in integrating data from multiple sources.
12) Consider a large-scale healthcare organization with multiple hospitals and clinics. What are the primary benefits of implementing a centralized database management system (DBMS) to manage patient records, medical history, and billing information?
Options:
[a] Improved data consistency and accuracy across different healthcare facilities, reducing errors and inconsistencies in patient records.
[b] Enhanced data security and privacy through robust access controls and encryption to protect sensitive patient information.
[c] Efficient data retrieval and analysis to support clinical decision-making, research, and regulatory compliance.
[d] All of the above.
13) A person transferred 5000 to his friend via a UPI application to contribute to a weekend trip. Which ACID property ensures that the transaction is either fully completed or completely rolled back?
Options:
[a] Atomicity.
[b] Consistency.
[c] Isolation.
[d] Durability.
14) What is the purpose of normalization in a snowflake schema?
Options:
[a] To improve query performance.
[b] To reduce data redundancy.
[c] To increase data security.
[d] To simplify data loading and transformation.
15) Which data warehouse schema is typically more efficient for querying due to its simplified structure and fewer joins?
Options:
[a] Star schema.
[b] Snowflake schema.
[c] Both A & B are equally efficient.
[d] It depends on the specific query workload.
Nptel Business Intelligence & Analytics Week 2 Answers (Jan-Apr 2025)
For answers or latest updates join our telegram channel: Click here to join
These are Nptel Business Intelligence & Analytics Week 2 Answers
More Answers of Nptel Business Intelligence & Analytics: Click here
For answers to additional Nptel courses, please refer to this link: NPTEL Assignment