ExamTopics Logo
Mail Us[email protected]
Menu
Comptia Discussions
exam questions

Exam DA0-001 All Questions

View all questions & answers for the DA0-001 exam
Go to Exam

Exam DA0-001 topic 1 question 147 discussion

Actual exam question from CompTIA's DA0-001
Question #: 147
Topic #: 1
[All DA0-001 Questions]

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?

  • A. Multiple redundant data fields
  • B. Non-compliance with regulations
  • C. Unstandardized field names
  • D. Difficulties with personnel continuity
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by Swift_and_Quick at April 17, 2024, 9:28 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Swift_and_Quick
6 months, 3 weeks ago
The change in structure by introducing an additional lookup table helps address the MDM (Master Data Management) issue of multiple redundant data fields. Previously, in Table 1 and Table 2, there were duplicate fields such as LastName and FirstName. By consolidating these fields into a separate lookup table, redundant data is eliminated, and the database becomes more normalized. So, the correct answer is: A. Multiple redundant data fields
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago