Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25

- Free Preparation Discussions

CompTIA Exam DA0-001 Topic 11 Question 14 Discussion

Actual exam question for CompTIA's DA0-001 exam

Question #: 14
Topic #: 11

[All DA0-001 Questions]

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

Gwenn

Separate the columns into a table and merge? I'd rather navigate a maze of spreadsheets than try that approach.

upvoted 0 times

...

Izetta

4 days ago

Merging all the date columns and unifying the format? Sounds like a job for a data alchemist, not an analyst.

upvoted 0 times

...

Ronald

10 days ago

Imputing date columns? That's like trying to fill in a pothole with duct tape - it might work temporarily, but it's not a long-term solution.

upvoted 0 times

...

Mayra

11 days ago

I disagree, I think we should append all date columns and parse the strings for better accuracy.

upvoted 0 times

...

Aleisha

13 days ago

I agree with Jessenia, it's important to maintain data consistency.

upvoted 0 times

...

Jessenia

15 days ago

I think we should merge all date columns and unify the format.

upvoted 0 times

...