
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.