Explanation:
The correct answer is Managed Delta table. Whenever a table is created without specifying the LOCATION keyword, it is considered a managed table. By default, all managed tables in Databricks are Delta tables. The syntax for creating such a table is CREATE TABLE table_name (column column_data_type…).
Ultimate access to all questions.
No comments yet.
When you execute the SQL DDL command CREATE TABLE sales (id int, units int), what type of table is created?
A
Query fails due to missing format
B
Managed Delta table
C
Query fails due to missing location
D
External Table
E
Managed Parquet table