Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Which of the following lines of code fills in the above blank to successfully complete the task?
Real Exam
Community
KKeng
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...