Q: 19
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?
Which of the following lines of code fills in the above blank to successfully complete the task?Options
Discussion
B , Databricks SQL expects USING CSV to define the file format when creating an external table. FROM is for specifying the path but not the format, so using FROM CSV wouldn't make sense syntactically. Seen this in practice tests too, but open to correction if I'm missing something.
Its C, this one is super straightforward compared to similar questions I’ve seen.
Had something like this in a mock, pretty sure it's B. In Databricks SQL, you use
USING CSV to specify the file format when creating the table.Be respectful. No spam.
