CompTIA Exam DA0-001 Topic 11 Question 14 Discussion

Actual exam question for CompTIA's DA0-001 exam

Question #: 14
Topic #: 11

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?

AAppend all date columns and parse the strings.

BImpute all three date columns and then merge.

CMerge all date columns and unify the format.

DSeparate the columns into a table and merge.

Show Suggested Answer

Suggested Answer: A

by Bette at Mar 02, 2023, 09:10 PM

Limited Time Offer

25%

Off

Get Premium DA0-001 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Marisha

1 months ago

Option C is the way to go - merge all date columns and unify the format. It's the date-iest solution, if you ask me.

upvoted 0 times

Kirk

8 days ago

User 3: That makes sense. It's important to have consistent date formats for accurate analysis.

upvoted 0 times

...

Elmer

17 days ago

User 2: I agree, merging all date columns and unifying the format is the most logical approach.

upvoted 0 times

...

Maryln

1 months ago

User 1: Option C is definitely the best choice. It will make the data consistent.

upvoted 0 times

...

Colette

2 months ago

Appending and parsing the date strings? That's like trying to read a calendar in a foreign language - it's going to take some serious linguistic skills.

upvoted 0 times

...