Câu 28: DP-750: Implementing Data Engineering Solutions Using Azure Databricks

You have an Azure Databricks workspace that is enabled for Unity Catalog and contains two managed Delta tables named sales.schema1.table1 and sales.schema1.table2. sales.schema1.table1 contains sales data from the current year. sales.schema1 .table2 contains historical data. You need to load all the rows from sales.schema1.table1 into sales.schema1.table2. The solution must preserve any existing data in sales.schema1.table2 and minimize processing effort. Which command should you run?

1. A. INSERT OVERWRITE sales.schema1.table2 SELECT * FROM sales.schema1.table1;
2. B. CREATE TABLE sales.schema1.table2 AS SELECT * FROM sales.schema1.table1;
3. C. INSERT INTO sales.schema1.table2 SELECT * FROM sales.schema1.table1; — đáp án hiện tại
4. D. CREATE OR REPLACE TABLE sales.schema1.table2 AS SELECT * FROM sales.schema1.table1;