MTS488 Quiz 2

What is the primary purpose of data ingestion in a data warehouse architecture?

• To visualize data trends

• To load data from various sources

• To create analytical models

• To store data permanently

Which process involves transforming data before loading it into an analytical store?

• Data modeling

• ELT

• ETL

• Data visualization

What type of data store is optimized for data analytics rather than transactional workloads?

• File system

• Data warehouse

• Data lake

• Data mart

Which of the following is a characteristic of a data lake?

• Schema-on-write approach

• Optimized for transactional workloads

• Supports only structured data

• File store on a distributed file system

What is a common use case for stream processing?

• Real-time stock market tracking

• Historical data reporting

• Monthly billing cycles

• Batch data analysis

In which scenario is batch processing most suitable?

• Processing large volumes of data at once

• Real-time data analysis

• Immediate response to data events

• Continuous data monitoring

Which of the following best describes stream processing?

• Processes data in large batches

• Processes data in real-time as it arrives

• Is suitable for historical data analysis

• Requires all data to be collected before processing

What is the main disadvantage of batch processing?

• It requires no data validation

• It has a time delay between data ingestion and results

• It processes data in real-time

• It can handle large datasets efficiently

What is the purpose of data visualization in a data warehouse?

• To store data permanently

• To create reports and dashboards

• To ingest data from various sources

• To transform data for analysis