Business Intelligence & Analytics Week 2 Nptel Answers
Are you looking for Nptel Business Intelligence & Analytics Week 2 Answers ? You are here at right place for assignment answers.
Table of Contents
Nptel Business Intelligence & Analytics Week 2 Answers (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
