
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.