Databricks Certified Data Engineer - Associate

Explanation

In Databricks SQL, when creating a table from a CSV file using the CREATE TABLE statement, you need to specify the data source format using the USING clause. The correct syntax is:

CREATE TABLE table_name
USING CSV
OPTIONS (
    header = "true",
    delimiter = "|"
)
LOCATION "path/to/csv"

CREATE TABLE table_name
USING CSV
OPTIONS (
    header = "true",
    delimiter = "|"
)
LOCATION "path/to/csv"

Let's analyze each option:

• Option A (None of these lines of code are needed): ❌ Incorrect. The USING clause is required to specify the data source format.
• Option B (USING CSV): ✅ Correct. This is the proper syntax for creating a table from a CSV file.
• Option C (FROM CSV): ❌ Incorrect. The correct keyword is USING, not FROM.
• Option D (USING DELTA): ❌ Incorrect. This would create a Delta table, not read from a CSV file.
• Option E (FROM "path/to/csv"): ❌ Incorrect. The LOCATION clause already specifies the path; using FROM here would be syntactically incorrect.

Key Points:

1. The USING clause specifies the data source format (CSV, JSON, PARQUET, DELTA, etc.)
2. The OPTIONS clause provides format-specific options like header, delimiter, etc.
3. The LOCATION clause specifies where the data files are stored.
4. This syntax creates an external table that references the CSV files at the specified location without moving the data.