Answer-first summary for fast verification
Answer: Denormalize by selectively combining tables, considering data redundancy to minimize it while enhancing query performance.
Option C is the optimal approach as it involves selectively combining tables during denormalization, carefully considering data redundancy to balance between minimizing it and improving query performance.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
You are given a dataset that needs to be denormalized for easier querying in a data lakehouse. Describe the process you would follow to denormalize this data, including the considerations you would take into account regarding data redundancy and query performance.
A
Denormalize by combining all tables into one large table without considering data redundancy.
B
Avoid denormalization to prevent data redundancy and maintain data integrity.
C
Denormalize by selectively combining tables, considering data redundancy to minimize it while enhancing query performance.
D
Denormalize by duplicating all data across tables to ensure high availability of data.