Exam DA0-001 topic 1 question 231 discussion

Actual exam question from CompTIA's DA0-001

Question #: 231
Topic #: 1

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?

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.

Show Suggested Answer

Suggested Answer: C 🗳️

by 927eb66 at Feb. 8, 2025, 3 a.m.

Comments

Submit Cancel

927eb66

4 months, 1 week ago

Selected Answer: C

The best option is C. Merge all date columns and unify the format. Explanation: Maintaining data consistency means ensuring all dates are represented in the same format and that they refer to the same thing. Since the analyst has three separate date columns, merging them and then unifying their format is the most direct and efficient way to achieve consistency. This approach allows the analyst to work with all dates as a single unit without the confusion of having multiple, potentially differently formatted, date columns.

upvoted 1 times

...