Ultimate access to all questions.
In a scenario where you are working with a Delta Lake table named 'sales_data' that contains multiple columns including 'product_id' and 'quantity', you are tasked with creating a view named 'product_sales' that will be used by the analytics team for reporting purposes. The view should only include the 'product_id' and 'quantity' columns to simplify the data model for the end users. Considering the need for cost efficiency and compliance with data governance policies, which of the following Spark SQL queries would you use to create this view? Choose the single best option.