Answer-first summary for fast verification
Answer: USING CSV
The correct answer is `USING CSV` because the `CREATE TABLE USING` statement allows you to specify an external data source type, such as CSV format, along with any additional options. This creates an external table that points to files stored in an external location. Reference: [Databricks SQL Documentation](https://docs.databricks.com/sql/language-manual/sql-ref-syntax-ddl-create-table-using.html)
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
What should you fill in the blank to successfully create a table using data from CSV files located at /path/input?
CREATE TABLE my_table(col1 STRING, col2 STRING)____________OPTIONS (header = “true“, delimiter = “;“)LOCATION = “/path/input“
A
FROM CSV
B
USING DELTA
C
AS
D
USING CSV
E
AS CSV