Answer-first summary for fast verification
Answer: `spark.sql('CREATE TABLE managed_table USING DELTA;');`
D is the correct way to create a managed table in Databricks using PySpark. The CREATE TABLE statement with the USING DELTA clause tells Databricks to create a managed table using the Delta Lake format. Databricks will manage both the metadata and the data storage for this table.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Describe the process of creating a managed table in Databricks using PySpark. Include the necessary code snippet and explain each step of the process.
A
CREATE TABLE managed_table AS SELECT * FROM source_table;
B
spark.sql('CREATE MANAGED TABLE managed_table AS SELECT * FROM source_table');
C
spark.read.format('delta').load('/path/to/data').createOrReplaceTempView('managed_table');
D
spark.sql('CREATE TABLE managed_table USING DELTA;');
No comments yet.