What distinguishes the `INSERT OVERWRITE` command from the `CREATE OR REPLACE TABLE` command in Databricks?

Real Exam

INSERT OVERWRITE maintains historical data versions by default, while CREATE OR REPLACE clears the historical data versions by default.

18.2%

INSERT OVERWRITE replaces data by default, whereas CREATE OR REPLACE replaces both data and schema by default.

58.4%

Both commands are functionally identical and yield the same outcomes.

5.8%

INSERT OVERWRITE clears historical data versions by default, while CREATE OR REPLACE maintains the historical data versions by default.

9.3%

INSERT OVERWRITE replaces data and schema by default, whereas CREATE OR REPLACE replaces data by default.

8.2%

Databricks Certified Data Engineer - Associate