Explanation:
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.
Ultimate access to all questions.
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.
No comments yet.