Database Fundamentals — Question 43

This question requires that you evaluate the underlined text to determine if it is correct.
You combine data from three tables into one table. The new table includes redundancy to optimize read performance.
The data in the new table has been denormalized.
Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct.

Answer options

• A. No change is needed
• B. Normalized
• C. Truncated
• D. Indexed

Correct answer: A

Explanation

The original statement is accurate as it correctly describes that denormalization introduces redundancy to improve read performance. The other options, such as 'Normalized,' 'Truncated,' and 'Indexed,' do not relate correctly to the concept of combining data with redundancy for optimization purposes.