Which of the following tasks is an example of data parsing?

Splitting a full name field into first and last name fields

Joining two tables on a common key

Converting all currency values to USD

A retail analyst receives a daily sales file where the 'Amount' column contains values like '$1,234.56', '1,234.56', and '1234.56'. Before aggregating total sales, the analyst must ensure all values are numeric. Which transformation should be applied?

Replace all non-numeric characters with a space, then trim the column.

Parse the column to extract only the numeric characters, then cast to a decimal data type.

Apply a text-to-columns split using the comma as the delimiter.

Cast the column directly to a decimal data type.

An e-commerce analyst has a 'Phone' column with values like '(555) 123-4567', '555-123-4567', and '5551234567'. The analyst needs to standardize the phone numbers to a single format for a mailing list. Which transformation should be applied?

Sort the column by the phone number.

Cast the column to an integer data type.

Remove all non-numeric characters, then format the digits as (XXX) XXX-XXXX.

A school district has a student enrollment table and a test scores table. Both have a 'student_id' column, but the test scores table contains scores for only a subset of students. An analyst needs a dataset with all students and their test scores (null if no score). Which join should be used?

Right join on student_id, with test scores as the left table

Left join on student_id, with enrollment as the left table

CompTIAData+

Domain 2Objective 3

Apply Data Transformation DA0-001 Practice Questions (Page 2)

Part of the Data acquisition and preparation domain, which accounts for 22% of the DA0-001 exam. CompTIA does not publish an official question count, but from its 90-minute exam (~35–60 total, ~8–13 in this domain), expect 3–4 from this objective — we provide 27 practice questions to prepare you well beyond it. (estimate)

27questions here

6free pages

4concepts

22%of the exam

Questions 6–10

6foundation · easy
Which of the following tasks is an example of data parsing?
Select an answer first
7application · medium
A retail analyst receives a daily sales file where the 'Amount' column contains values like '$1,234.56', '1,234.56', and '1234.56'. Before aggregating total sales, the analyst must ensure all values are numeric. Which transformation should be applied?
Select an answer first
8application · medium
An e-commerce analyst has a 'Phone' column with values like '(555) 123-4567', '555-123-4567', and '5551234567'. The analyst needs to standardize the phone numbers to a single format for a mailing list. Which transformation should be applied?
Select an answer first
9foundation · easy
A data analyst needs to combine sales data from a spreadsheet and a database into a single table for analysis. Which data transformation process should be used?
Select an answer first
10application · easy
A school district has a student enrollment table and a test scores table. Both have a 'student_id' column, but the test scores table contains scores for only a subset of students. An analyst needs a dataset with all students and their test scores (null if no score). Which join should be used?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DA0-001

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by CompTIA. “DA0-001” is a trademark of its owner, used for identification only.