CompTIA Data+ (DA0-001) — Question 32

While reviewing survey data, an analyst notices respondents entered “Jan,” “January,” and “01” as responses for the month of January. Which of the following steps should be taken to ensure data consistency?

Answer options

• A. Delete any of the responses that do not have “January” written out.
• B. Replace any of the responses that have “01”.
• C. Filter on any of the responses that do not say “January” and update them to “January”.
• D. Sort any of the responses that say “Jan” and update them to “01”.

Correct answer: C

Explanation

Option C is correct because it addresses the need to standardize the month entries by converting any variations to the full name 'January'. Option A is too extreme as it removes valid responses, while option B only addresses one variation without considering others. Option D incorrectly suggests converting 'Jan' to '01', which does not promote consistency.