Databricks Certified Data Engineer Associate · Free Practice Question Easy
Question 17
What type of table is created when you create delta table with below command?
CREATE TABLE transactions USING DELTA LOCATION "DBFS:/mnt/bronze/transactions"
-
A
Managed delta table
-
B
External table
-
C
Managed table
-
D
Temp table
-
E
Delta Lake table
Reveal correct answer
Correct answer: B
Explanation
Anytime a table is created using the LOCATION keyword it is considered an external table, below is the current syntax.
Syntax
CREATE TABLE table_name ( column column_data_type…) USING format LOCATION "dbfs:/"
format -> DELTA, JSON, CSV, PARQUET, TEXT
I created the table command based on the above question, you can see it created an external table,
Let's remove the location keyword and run again, same syntax except for the LOCATION keyword is removed.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
