Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
What is the correct method to create a permanent view in Databricks SQL that directly references data from a CSV file stored in DBFS?
A
Use the CREATE PERMANENT VIEW statement and specify the CSV file path directly after the FROM keyword.
B
Permanent views cannot reference CSV files directly; they must be loaded into a table first.
C
Use the CREATE VIEW statement with the USING csv option followed by the path to the CSV file.
D
Use the CREATE VIEW statement followed by a SELECT query that uses the csv prefix to reference the CSV file.
