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.
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)- A2% (1)
- B4% (2)
- C4% (2)
- D91% (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.
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.
Duplicate data typically refers to identical records or entries, not different representations of the same underlying fact in different columns.
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.
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
Community Discussion
No community discussion yet for this question.