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 is required to create a table in Databricks using data from a CSV file at location /path/to/csv.
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
None of these lines of code are needed to successfully complete the task
B
USING CSV
C
FROM CSV
D
USING DELTA
E
FROM "path/to/csv"
Explanation:
The correct answer is B (USING CSV). In Databricks SQL, when reading CSV files, you use the USING CSV clause to specify the file format. This is the proper syntax for loading CSV data in Databricks. Option A is incorrect because format specification is needed. Option C (FROM CSV) uses incorrect syntax. Option D (USING DELTA) is for Delta format, not CSV. Option E (FROM "path/to/csv") only specifies the path but not the format.
Comments
Loading comments...