NPTEL Business Intelligence & Analytics Week 2 Assignment Answers 2024

Join Our WhatsApp Group Join Now
Join Us On Telegram Join Now

NPTEL Business Intelligence & Analytics Week 2 Assignment Answers 2024

1. Which term describes the practice of making decisions purely on data analysis rather than intuition?

  • Data Science
  • Data Engineering
  • Data-Driven Decision (DDD) Making
  • Fundamental principles of data extraction
Answer :- For Answer Click Here

2. What characterizes the primary function of databases supporting Online Transaction Processing (OLTP)?

  • Complex queries and analysis of data
  • Retrieval of business trends and statistics
  • Handling a large number of simple transactions and updates
  • Aggregation of data into cubes
Answer :- For Answer Click Here

3. What does the acronym ACID stand for in the context of databases?

  • Atomicity, Consistency, Integration, Durability
  • Atomicity, Continuity, Isolation, Durability
  • Atomicity, Consistency, Isolation, Durability
  • Atomicity, Continuity, Integration, Durability
Answer :- For Answer Click Here

4. What primarily distinguishes Online Analytical Processing (OLAP) from Online Transaction Processing (OLTP)?

  • OLTP converts data cube into relational data, while OLAP focusses on real time data entry.
  • OLAP handles a large number of simple transactions, while OLTP deals with complex analysis of data.
  • OLAP deals with data retrieval and analysis for revealing business trends, while OLTP supports a large number of simple transactions.
  • OLTP utilizes cubes as its primary data structure, while OLAP uses traditional relational databases.
Answer :- 

5. Which of the following best describes a data warehouse?

  • An operational database used for day-to-day transactions.
  • A repository separate from operational databases, providing integrated and historic data for decision-making processes.
  • A system focused on real-time data analysis and customer interactions.
  • An integrated data structure primarily handling transaction processing.
Answer :- 

6. Why does a data warehouse not require transaction processing, recovery, and concurrency control mechanisms?

  • Because data warehouse is volatile
  • Due to its physical separation from operational data
  • Because it focuses on day-to-day operational activities rather than historical data.
  • Since it integrates multiple heterogeneous data sources for decision support.
Answer :- For Answer Click Here

7. Which data warehouse model spans the entire organization and provides corporate-wide data integration?

  • Data mart
  • Virtual warehouse
  • Enterprise warehouse
  • Operational system
Answer :- 

8. What distinguishes a data mart from an enterprise warehouse?

  • Data marts contain detailed data, while enterprise warehouses contain summarized data.
  • Enterprise warehouses are implemented on departmental servers, while data marts utilize parallel architecture platforms.
  • Data marts require extensive business modelling, while enterprise warehouses have a shorter implementation cycle.
  • Data marts typically contain a subset of corporate-wide data for specific users, while enterprise warehouses collect information spanning the entire organization.
Answer :- 

9. Which function of back-end tools in data warehouse systems involves rectifying errors detected in the data?

  • Data extraction
  • Data cleaning
  • Data transformation
  • Load
Answer :- 

10. What is the first step in the ETL process?

  • Load data into the target system.
  • Clean and transform the data.
  • Extract data from source systems.
  • Validate the data for accuracy.
Answer :- For Answer Click Here

11. Which of the following gives a logical structure of the database graphically?

  • Entity-relationship diagram
  • Data mining diagram
  • Database diagram
  • Architectural representation
Answer :- 

12. Which type of DBMS language is used to create the database schema?

  • Data Manipulation Language
  • Data Query Language
  • Data Definition Language
  • Transaction Control Language
Answer :- For Answer Click Here

13. Which Data Manipulation command is used to add a new record in a database?

  • SELECT
  • INSERT
  • UPDATE
  • DELETE
Answer :- 

14. What does the atomicity property of the ACID database guarantee in a transaction?

  • That the transaction will be completed
  • That the transaction will be all-or-nothing.
  • That the transaction will be isolated from other transactions.
  • That the transaction will be durable and survive failures.
Answer :- 

15. What problem does the ACID property of isolation address?

  • Incomplete or inconsistent updates during transactions.
  • Concurrent access to data causing inconsistencies.
  • Loss of data due to system failures.
  • Unrealistic expectations for transaction performance.
Answer :- For Answer Click Here