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.
Ultimate access to all questions.
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?
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"