Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
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:
CREATE TABLE new_table
______
OPTIONS (
header = "true",
delimiter = "|"
)
LOCATION "path/to/csv"
CREATE TABLE new_table
______
OPTIONS (
header = "true",
delimiter = "|"
)
LOCATION "path/to/csv"
Which of the following lines of code fills in the above blank to successfully complete the task?
Real Exam
Community
KKeng
0
A
FROM "path/to/csv"
B
USING CSV
C
FROM CSV
D
USING DELTA
Explanation:
Explanation
In Databricks SQL, when creating a table from an external file format like CSV, the correct syntax is to use USING CSV after the table name and before the OPTIONS clause. This syntax specifies the file format to be used for reading the data.
Why Option B is correct:
USING CSVexplicitly tells Databricks that the table should be created from CSV format data- The
OPTIONSclause then provides additional configuration for the CSV reader (like header and delimiter settings) - The
LOCATIONclause specifies where the CSV file is stored
Why other options are incorrect:
- Option A (FROM "path/to/csv"): This is not valid syntax for creating tables from external files in Databricks SQL
- Option C (FROM CSV): This is not valid syntax; you need to use
USINGnotFROMfor specifying file format - Option D (USING DELTA): This would create a Delta table, not read from a CSV file
Complete correct syntax:
CREATE TABLE new_table
USING CSV
OPTIONS (
header = "true",
delimiter = "|"
)
LOCATION "path/to/csv"
CREATE TABLE new_table
USING CSV
OPTIONS (
header = "true",
delimiter = "|"
)
LOCATION "path/to/csv"
This syntax creates an external table that reads directly from the CSV file at the specified location, using the pipe character as delimiter and treating the first row as header.
Comments
Loading comments...