QuestionQ56

Data analysis

A data analyst is examining a new data source containing employee IDs, job titles, dates of birth, addresses, years of service, and employees’ birth months. Which of the following inconsistencies should the analyst identify?

Explanation

Birth month is derivable from an employee’s date of birth. Keeping both fields stores the same underlying information twice, creating redundancy and the risk that the two values become inconsistent.

Community Discussion

No comments yet. Be the first to start the discussion!