DA0-002 Data Concepts and Environments Practice Question

Drag and drop the steps for the ETL (Extract, Transform, Load) process in the correct order.

Drag steps to the numbered slots on the right, or tap a step then tap a slot.

Steps

Order

1Step 1

2Step 2

3Step 3

4Step 4

5Step 5

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

✓

Step 1: Extract, Step 2: Cleanse, Step 3: Transform, Step 4: Load, Step 5: Verify

ETL begins with extraction, followed by cleaning, transformation, loading, and verification.

Answer analysis

For each option: why learners choose it and why it is or isn't the right answer here.

✓
Step 1: Extract, Step 2: Cleanse, Step 3: Transform, Step 4: Load, Step 5: Verify
Why this is correct
This order follows the standard ETL process: extract data first, then clean it to remove errors, transform it into the desired format, load it into the target system, and finally verify the data integrity.
✗
Step 1: Extract, Step 2: Transform, Step 3: Cleanse, Step 4: Load, Step 5: Verify
Why it's wrong here
This order is incorrect because cleansing should occur before transformation to ensure that only clean data is transformed; otherwise, you may transform erroneous data.
✗
Step 1: Extract, Step 2: Load, Step 3: Transform, Step 4: Cleanse, Step 5: Verify
Why it's wrong here
This order is incorrect because loading data before cleansing and transforming contradicts the purpose of ETL; raw data should be processed before loading into the target system.
✗
Step 1: Cleanse, Step 2: Extract, Step 3: Transform, Step 4: Load, Step 5: Verify
Why it's wrong here
This order is incorrect because extraction is the first step; you cannot cleanse data before extracting it, as the data source must be accessed first.

Go deeper