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

You have an Azure Databricks workspace that is enabled for Unity Catalog and contains two Delta tables named Table1 and Table2 of the same data type.Table1 contains a column named Column1. Table2 contains a column named Column2. You run the following query. SELECT Colum1 -FROM Table1 -GROUP BY Column1 -HAVING COUNT(*) > 1 -INTERSECT -SELECT Column2 -FROM Table2 -GROUP BY Column2 -HAVING COUNT(*) > 1;What occurs when you run the query?

1. A. Values appear in both tables more than once. — đáp án hiện tại
2. B. Values appear in either table more than once.
3. C. Values appear in Table2 but NOT Table1.
4. D. Values appear in Table1 more than once.