DA0-002 Data Acquisition and Preparation Practice Question
A data analyst at a retail bank is preparing a daily transaction file for loading into the analytics warehouse. The source system exports dates in the format 'MM/DD/YYYY', but the target warehouse requires ISO 8601 format 'YYYY-MM-DD'. The analyst needs to transform the date column without changing the underlying date value. Which transformation should the analyst perform?
⚠ Common exam trap
The trap here is assuming any string manipulation that rearranges characters is equivalent to proper date conversion, when only a date-aware function validates and preserves the actual calendar value.
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
✓
Use a date parsing and formatting function to interpret MM/DD/YYYY and output YYYY-MM-DD.
Converting a date representation while preserving the value is a standard data transformation task. Using a native parse-and-format function with an explicit input format ensures the calendar date is interpreted correctly and emitted as ISO 8601. Regex reordering, source-system changes, or untyped strings either risk invalid dates, affect unrelated systems, or defer correctness to query time, none of which meets the warehouse loading requirement cleanly.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Apply a regular expression to reorder the month, day, and year components into YYYY-MM-DD.
Why it's wrong here
A regular expression can reorder the captured groups, but it is fragile for date conversion because it does not validate whether the resulting date is real, such as February 30. It also requires custom pattern maintenance and can silently pass invalid values through. For a standard date format change in an ETL pipeline, a native date parsing and formatting function is safer and more accurate than regex.
- ✗
Change the source system's regional date setting so exports use ISO 8601.
Why it's wrong here
Altering the source system's configuration affects every downstream consumer and may break other reports or interfaces that expect MM/DD/YYYY. It also requires change control and coordination outside the analyst's scope. The transformation should occur in the data preparation layer, not by mutating the operational source's behavior, so this does not solve the stated requirement safely.
- ✓
Use a date parsing and formatting function to interpret MM/DD/YYYY and output YYYY-MM-DD.
Why this is correct
Parsing the source string with the known input format and then formatting it to ISO 8601 preserves the actual date value while meeting the target schema requirement. Native date functions also validate calendar constraints and handle leap years and month lengths correctly. This is the standard, maintainable approach for changing a date representation during data preparation.
- ✗
Store the date column as a string and let the warehouse interpret the format at query time.
Why it's wrong here
Leaving dates as untyped strings prevents reliable date arithmetic, sorting, and indexing, and pushes format ambiguity to every query. The warehouse may misinterpret MM/DD/YYYY depending on session settings, producing wrong results. The target schema explicitly requires ISO 8601, so deferring interpretation does not satisfy the requirement and creates downstream data quality risk.
Go deeper
Related to this question
About these practice questions
This DA0-002 question is part of Courseiva's 1,004-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official CompTIA exam blueprint
This DA0-002 practice question is part of Courseiva's free CompTIA certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DA0-002 exam.