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.
In your lakehouse, you need to create a view that aggregates sales data from multiple tables. Describe the steps you would take to create this view, including any necessary transformations and joins. 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.
No comments yet.