Which two tasks are performed as part of the transform step of the ETL data process? (Choose two.)
- removing the blank records
- standardizing formats such as date, time, and location
- communicating results to decision-makers
- collecting and recording the data
- transferring the data into a database
Explanation: The process of transforming the data includes tasks such as:
- Combining and sorting data sources
- Locating and removing duplicate data
- Providing data for missing values
- Rejecting or correcting erroneous data
Related exam: Data Analytics Essentials Course Final Exam
