ExpertEasy1 markMultiple Choice
CPA · Question 28 · Area I: Information Systems
In the ETL (Extract, Transform, Load) process, at which stage is data cleaned, deduplicated, and converted into a consistent format?
In the ETL (Extract, Transform, Load) process, at which stage is data cleaned, deduplicated, and converted into a consistent format?
Answer options:
A.
Extract
B.
Transform
C.
Load
D.
Archive
How to approach this question
Match the action (cleaning/converting) to the name.
Full Answer
B.Transform✓ Correct
Transform
The Transform stage involves applying rules to the extracted data to clean it, validate it, and format it for the target system.
Common mistakes
Thinking cleaning happens during Extraction.
Practice the full CPA ISC Practice Exam 5
82 questions · hints · full answers · grading
More questions from this exam
Q01A service organization provides a cloud-based payroll processing application to its user entities...MediumQ02An auditor is reviewing the shared responsibility model for a client using an Infrastructure as a...HardQ03A financial institution requires a cloud deployment model that offers the highest level of contro...MediumQ04During an IT audit, you observe that a company uses a 'Hybrid Cloud' architecture. Which scenario...MediumQ05Which component of IT architecture is primarily responsible for translating domain names (like ww...Easy