
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.
A
CREATE VIEW product_sales AS SELECT product_id, quantity FROM sales_data_
B
CREATE TABLE product_sales AS SELECT product_id, quantity FROM sales_data_
C
CREATE TEMPORARY VIEW product_sales AS SELECT product_id, quantity FROM sales_data_
D
CREATE GLOBAL TEMPORARY VIEW product_sales AS SELECT product_id, quantity FROM sales_data_