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?
Certified Data Engineer Associate Exam QuestionsBrowse all questions from this exam
Certified Data Engineer Associate Exam - Question 69
Show AnswerHide Answer
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
6 commentsmeow_akkOption: B
Oct 22, 2023Ans B : Using csv is correct. that is the correct syntax
55f31c8Option: B
Nov 29, 2023https://docs.databricks.com/en/sql/language-manual/sql-ref-syntax-ddl-create-table-using.html#parameters
kishanuOption: B
Oct 20, 2023USING CSV
fifirifiOption: B
Mar 10, 2024correct 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
kz_dataOption: B
Dec 6, 2023B is correct
Bob123456
Feb 22, 2024I have a question Why can option using delta