nerdexam
CompTIA

DA0-001 · Question #51

A table in a hospital database has a column for patient height in inches and a column for patient height in centimeters. This is an example of:

The correct answer is D. redundant data. Having two columns that store the same information (patient height) in different units (inches and centimeters) is an example of redundant data, as one can be derived from the other.

Data Concepts and Environments

Question

A table in a hospital database has a column for patient height in inches and a column for patient height in centimeters. This is an example of:

Options

  • Adependent data.
  • Bduplicate data.
  • Cinvalid data
  • Dredundant data

How the community answered

(57 responses)
  • A
    2% (1)
  • B
    4% (2)
  • C
    4% (2)
  • D
    91% (52)

Why each option

Having two columns that store the same information (patient height) in different units (inches and centimeters) is an example of redundant data, as one can be derived from the other.

Adependent data.

Dependent data refers to data whose values rely on other data, which is true here, but "redundant" more specifically describes the storage of the same information twice.

Bduplicate data.

Duplicate data typically refers to identical records or entries, not different representations of the same underlying fact in different columns.

Cinvalid data

Invalid data implies that the data itself is incorrect or does not conform to expected rules, which is not necessarily the case here; the data might be correct, just stored redundantly.

Dredundant dataCorrect

Redundant data occurs when the same piece of information is stored multiple times in a database or can be derived from other existing data, such as height in inches and height in centimeters.

Concept tested: Database normalization - data redundancy

Source: https://learn.microsoft.com/en-us/sql/relational-databases/design/database-normalization-basics?view=sql-server-ver16

Topics

#Data redundancy#Database concepts#Data quality

Community Discussion

No community discussion yet for this question.

Full DA0-001 Practice