A data analyst receives a log file where each line is a JSON object, but some lines are malformed (e.g., missing closing braces). The analyst needs to extract the 'timestamp' and 'user_id' fields from all valid lines. What should the analyst do?

Load the entire file as a single JSON array.

Manually fix each malformed line before parsing.

Parse each line as JSON and skip lines that fail to parse.

Use a regular expression to extract the fields from all lines, including malformed ones.

CompTIAData+

Domain 2Objective 3

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

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 26–27

26foundation · easy
A dataset contains dates in multiple formats, such as '01/15/2023', '15-Jan-2023', and '2023-01-15'. The analyst wants to convert all dates to the YYYY-MM-DD format. Which data transformation process is most directly used?
Select an answer first
27expert · hard
A data analyst receives a log file where each line is a JSON object, but some lines are malformed (e.g., missing closing braces). The analyst needs to extract the 'timestamp' and 'user_id' fields from all valid lines. What should the analyst do?
Select an answer first

Finished these 2 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack 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.

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

Questions 26–27

A dataset contains dates in multiple formats, such as '01/15/2023', '15-Jan-2023', and '2023-01-15'. The analyst wants to convert all dates to the YYYY-MM-DD format. Which data transformation process is most directly used?

A data analyst receives a log file where each line is a JSON object, but some lines are malformed (e.g., missing closing braces). The analyst needs to extract the 'timestamp' and 'user_id' fields from all valid lines. What should the analyst do?

Keep studying — Data acquisition and preparation