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…)
Latest Databricks Certified Data Engineer Professional Practice Questions with 278 Q&As
Updated Study Material | Instant Download | Detailed Answers and Explanations
Subscribe
Login
0 Comments