Databricks Data Engineer Professional Question 1
Single answerYou are working on a Databricks workspace where multiple teams collaborate. You need to create a Delta Table for shared use, but you want to ensure that the table is stored in a specific location within the cloud storage for better data management. Additionally, you want to ensure that the table is registered in the Databricks metastore for easy querying. Which of the following commands will achieve this?
- A
CREATE DELTA TABLE shared_data LOCATION '/mnt/data/shared';
- B
CREATE TABLE shared_data USING DELTA LOCATION '/mnt/data/shared';
- C
CREATE TABLE shared_data LOCATION '/mnt/data/shared' FORMAT DELTA;
- D
CREATE OR REPLACE TABLE shared_data USING DELTA LOCATION '/mnt/data/shared';
Show answer and explanation
Correct answer: B
Explanation
To create a Delta table and store it in a specific cloud storage location while registering it in the Databricks metastore, the correct syntax is 'CREATE TABLE table_name USING DELTA LOCATION path'. This ensures the table is stored in Delta format, linked to the specified cloud storage location, and available for querying using SQL within the Databricks workspace.
- A. Incorrect.
This command is incorrect because the correct syntax for creating a Delta table and specifying a storage location must use the 'USING DELTA' clause.
- B. Correct.
This is the correct command as it specifies the use of Delta format using 'USING DELTA' and defines the storage location with 'LOCATION', ensuring the table is registered in the Databricks metastore.
- C. Incorrect.
This command is incorrect because the syntax 'FORMAT DELTA' is not valid. Databricks uses 'USING DELTA' to specify the Delta format.
- D. Incorrect.
This command is incorrect because 'CREATE OR REPLACE TABLE' is not required when creating a new table. The 'CREATE TABLE' command is sufficient for this scenario.