Answer-first summary for fast verification
Answer: Create a view with necessary joins and transformations, simplifies complex queries and ensures consistent data access.
Option B is the correct approach. Creating a view with necessary joins and transformations simplifies complex queries, ensures consistent data access, and can improve performance by encapsulating the logic in a reusable object.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
You are asked to create a view in your lakehouse that combines data from multiple tables related to customer transactions. Describe the steps you would take to create this view, including any necessary joins and transformations. Discuss the advantages of using a view over directly querying the base tables.
A
Directly query the base tables without creating a view.
B
Create a view with necessary joins and transformations, simplifies complex queries and ensures consistent data access.
C
Create a view without any joins or transformations.
D
Create a view that only selects data from a single table.