What is the best way to query external csv files located on DBFS Storage to inspect the data using SQL?
What is the best way to query external csv files located on DBFS Storage to inspect the data using SQL?
A . SELECT * FROM ‘dbfs:/location/csv_files/’ FORMAT = ‘CSV’
B. SELECT CSV. * from ‘dbfs:/location/csv_files/’
C. SELECT * FROM CSV. ‘dbfs:/location/csv_files/’
D. You can not query external files directly, us COPY INTO to load the data into a table first
E. SELECT * FROM ‘dbfs:/location/csv_files/’ USING CSV
Answer: C
Explanation:
Answer is, SELECT * FROM CSV. ‘dbfs:/location/csv_files/’
you can query external files stored on the storage using below syntax SELECT * FROM format.`/Location` format – CSV, JSON, PARQUET, TEXT
Latest Databricks Certified Data Engineer Professional Dumps Valid Version with 278 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
Subscribe
Login
0 Comments
Inline Feedbacks
View all comments