DA0-001 · Question #216
Data was previously stored in the following relational tables: A database architect changes the relational database structure to include an additional lookup table, which includes the following…
The correct answer is A. Multiple redundant data fields. By introducing a lookup table, a database architect aims to centralize and standardize common data elements, thereby eliminating redundant data fields that might have existed across multiple tables. This structure improves data consistency and reduces storage overhead.
Question
Data was previously stored in the following relational tables:
A database architect changes the relational database structure to include an additional lookup table, which includes the following:
Which of the following MDM issues does this change in structure solve?
Exhibits
Options
- AMultiple redundant data fields
- BNon-compliance with regulations
- CUnstandardized field names
- DDifficulties with personnel continuity
How the community answered
(38 responses)- A95% (36)
- C3% (1)
- D3% (1)
Why each option
By introducing a lookup table, a database architect aims to centralize and standardize common data elements, thereby eliminating redundant data fields that might have existed across multiple tables. This structure improves data consistency and reduces storage overhead.
Adding a lookup table for common attributes, like status codes or product types, eliminates the need to store the same descriptive data repeatedly in multiple main tables. This reduces data redundancy, improves data integrity by having a single source of truth for these attributes, and makes updates more efficient.
While improved data quality can indirectly support compliance, the primary and direct benefit of a lookup table for common data elements is addressing redundancy, not regulatory non-compliance.
A lookup table standardizes data values, but not necessarily field names in other tables; its main purpose is to reduce data repetition, not to rename existing columns.
Database structural changes like adding lookup tables do not directly address issues related to personnel continuity or knowledge transfer among staff.
Concept tested: Master Data Management (MDM) - data redundancy
Source: https://learn.microsoft.com/en-us/sql/relational-databases/tables/create-lookup-tables-in-a-database?view=sql-server-ver16
Topics
Community Discussion
No community discussion yet for this question.