Exam4Training

What is the type of table created when you issue SQL DDL command CREATE TABLE sales (id int, units int)

What is the type of table created when you issue SQL DDL command CREATE TABLE sales (id int, units int)
A . Query fails due to missing location
B . Query fails due to missing format
C . Managed Delta table
D . External Table
E . Managed Parquet table

Answer: C

Explanation:

Answer is Managed Delta table

Anytime a table is created without the Location keyword it is considered a managed table, by de-fault all managed tables DELTA tables

Syntax

CREATE TABLE table_name (column column_data_type…)

Exit mobile version