A data engineer needs to create a table in Databricks using data from a CSV file at location /path/to/csv.
They run the following command:
Which of the following lines of code fills in the above blank to successfully complete the task?
Exam Certified Data Engineer Associate All QuestionsBrowse all questions from this exam
Question 69
Correct Answer: B
To successfully create a table in Databricks using data from a CSV file, the correct syntax requires specifying the format of the source data. The `USING CSV` clause tells Databricks that the data source format is a CSV file, allowing it to correctly interpret and load the data. This is essential for the process and is the appropriate line of code to complete the task.
Discussion
55f31c8Option: B
https://docs.databricks.com/en/sql/language-manual/sql-ref-syntax-ddl-create-table-using.html#parameters
meow_akkOption: B
Ans B : Using csv is correct. that is the correct syntax
fifirifiOption: B
correct answer: B explanation: To create a table in Databricks using data from a CSV file, the correct syntax after specifying the table name and schema (if applicable) would be to use the USING CSV clause to define the format of the source data. This clause tells Databricks that the data source format is CSV. The command would typically look
kishanuOption: B
USING CSV
Bob123456
I have a question Why can option using delta
kz_dataOption: B
B is correct