Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
What distinguishes the INSERT OVERWRITE command from the CREATE OR REPLACE TABLE command in Databricks?
INSERT OVERWRITE
CREATE OR REPLACE TABLE
A
INSERT OVERWRITE maintains historical data versions by default, while CREATE OR REPLACE clears the historical data versions by default.
CREATE OR REPLACE
B
INSERT OVERWRITE replaces data by default, whereas CREATE OR REPLACE replaces both data and schema by default.
C
Both commands are functionally identical and yield the same outcomes.
D
INSERT OVERWRITE clears historical data versions by default, while CREATE OR REPLACE maintains the historical data versions by default.
E
INSERT OVERWRITE replaces data and schema by default, whereas CREATE OR REPLACE replaces data by default.
