adplus-dvertising
frame-decoration

Question

How is redundancy addressed in data quality?

a.

All missing values for a given attribute are filled

b.

Redundancy is allowed for efficiency reasons

c.

All duplicate records are identified and cross-referenced

d.

Data items adhere to prescribed business rules

Answer: (b).Redundancy is allowed for efficiency reasons Explanation:Redundancy may be allowed for efficiency reasons, but it must be clearly identified and verified.

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. How is redundancy addressed in data quality?

Similar Questions

Discover Related MCQs

Q. What does completeness refer to in data quality?

Q. What does conformance to business rules relate to in data quality?

Q. What is the role of clarity in data quality?

Q. Who determines the timeliness of data in the context of data quality?

Q. What role does usefulness play in data quality?

Q. What are the two integrity rules in the context of data integrity?

Q. How does improved data quality benefit data warehouse users in the context of timely information?

Q. How does complete and accurate information improve customer service?

Q. How can quality data benefit marketing departments in a data warehouse?

Q. What risks are associated with poor data quality?

Q. How does quality data in a data warehouse contribute to improved productivity?

Q. Why is reliable strategic decision-making essential in a data warehouse?

Q. What is the potential issue with old product codes when used in a data warehouse that stores historical data?

Q. What is the result of the unofficial use of fields in data records?

Q. What is a common issue with cryptic values in old legacy systems?

Q. Which of the following is a violation of a basic business rule in a personnel and payroll system?

Q. What is the problem with reused primary keys when capturing data in a data warehouse?

Q. When identifiers for product codes are different in various systems, what problem does this cause?

Q. What is the issue with inconsistent values for policy types in different legacy systems?

Q. What problem is associated with multipurpose fields that can be used differently by various departments?