Past Paper

Question 1

Purpose of ETL?

Answer 1

Extract, transform and load.
It allows data integration strategies by allowing companies to gather data from multiple sources and upload it onto one centralised location, and the ETL tools allows different types of data to work together.

1. Time efficiency
2. Handle complex data easily
3. Reduced error probability
4. Improved business intelligence and ROI

Question 2

Process of ETL:

Answer 2

Extract, transfer and load.

1. Prepare the data for extraction.

Data preparation refers to getting data ready for analytics and visualisations. Its core components include extracting data from the internet or local databases, transforming it by cleaning or joining datasets, and loading it into analytics or visualisation tools.

Question 3

5 examples of the IoT:

Answer 3

Home Automation
Wearable health monitors
Biometric security system
Barcode scanner at malls
Process Automation