DWDM CIE-I

If a retail company collects data from multiple sources such as customer transactions, online orders, and in-store purchases, how should they combine this data for reporting?

• Store it in separate databases and generate reports individually

• Use a Data Warehouse to integrate and analyze data from different sources

• Keep the data in a transactional database and run queries for integration

• Convert all the data into spreadsheets for easy reporting

Which of the following best describes the role of a staging area in the ETL process?

• It is a temporary storage area where data is cleaned and prepared before being loaded into the data warehouse

• It is the final destination for all extracted data before it is used for analytics

• It is a backup system for recovering lost data from transactional databases

• It is a cloud-based storage location for archived data

Why is data transformation necessary in the ETL process of a data warehouse?

• To change the data format so that it matches the source system

• To convert unstructured data into a structured format for analysis

• To delete all duplicate records before storage

• To create new data records for real-time transactions

Which of the following is a key difference between a Data Warehouse and a DBMS?

• A Data Warehouse processes transactions, while a DBMS is used for analytics

• A DBMS supports real-time operations, while a Data Warehouse is optimized for historical data analysis

• Data Warehouses are faster than DBMS in handling transactional operations

• A DBMS stores only unstructured data, while a Data Warehouse stores structured data

A bank wants to store and analyze monthly account balances of its customers over the past 5 years. Which type of database should it use?

• Transactional Database

• Data Warehouse

• NoSQL Database

• Relational Database with ACID compliance

What is the main function of the Extract, Transform, Load (ETL) process in data warehousing?

• Storing transaction records in the database

• Moving real-time data from DBMS to a cloud system

• Collecting, processing, and loading data into a data warehouse

• Performing live updates to customer order records

Which of the following best explains why a data warehouse is separate from a transactional database?

• To reduce the cost of storage for transactional databases
  

• To ensure that complex analytical queries do not affect real-time transaction processing

• To allow customers to access historical data directly

• To replace transactional databases with a better alternative

Why is a transactional database not suitable for analyzing sales data from the last five years?

• Transactional databases cannot store historical data

• Running complex queries on transactional databases can slow down real-time operations

• Transactional databases do not support data retrieval functions

• Analyzing sales data does not require a database system

Which of the following is an example of an additive fact?

• Discount percentage on a product in a store

• Total revenue generated by a store in a month

• Average customer rating of a product

• Inventory level at a specific time

A retail chain wants to compute the total inventory level across all its stores on a specific date. This is an example of:

• Additive fact

• Non-additive fact

• Semi-additive fact

• Derived fact