CompTIA Data+ (DA0-001) — Question 268

A data analyst received a large amount of third-party data that needs to be joined with in-house data files. After the data is joined, the analyst notices three columns all contain dates. Which of the following should the analyst do to maintain data consistency?

Answer options

• A. Append all date columns and parse the strings.
• B. Impute all three date columns and then merge.
• C. Merge all date columns and unify the format.
• D. Separate the columns into a table and merge.

Correct answer: C

Explanation

The correct answer is C because merging all date columns and unifying the format ensures that all date values are consistent and comparable. Options A and B do not address the need for a unified format specifically, while option D complicates the structure without resolving the date consistency issue.