ETL and Data Transformation Quiz

What does ETL stand for in data mining?

• Evaluate, Transform, Load

• Extract, Transform, Load

• Extract, Transfer, Link

• Encode, Transfer, Load

Which of the following is NOT a phase of the ETL process?

• Extract

• Train

• Transform

• Load

In the extract phase, which of the following can be a data source?

• Web servers

• ERP software

• CRM systems

• All of the above

Which task belongs to the ‘Transform’ phase?

• Data extraction

• Data storage

• Data cleaning

• Data archiving

What is the goal of standardization in data transformation?

• Deleting old records

• Creating random data

• Unifying data formats

• Encrypting data

Which of these is an example of aggregation in ETL?

• Correcting spelling errors

• Summing daily sales to get a monthly total

• Normalizing dates

• Removing duplicate entries

What does a Full Load in ETL imply?

• Only new records are added

• All data is loaded, often for the first time

• Metadata is updated only

• Only incremental updates are done

Which cloud platform is commonly used for loading processed data?

• Google Docs

• Amazon Redshift

• Instagram

• Microsoft Paint

What does deduplication remove?

• Irrelevant fields

• Repetitive computations

• Duplicate records

• Backup data

Which is an example of enrichment in data transformation?

• Formatting timestamps

• Adding demographic data from zip codes

• Dropping missing values

• Encrypting sensitive fields