Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
Question 18
Which of the following commands will return records from an existing Delta table my_table where duplicates have been removed?
my_table
A
DROP DUPLICATES FROM my_table;
B
SELECT * FROM my_table WHERE duplicate = False;
C
SELECT DISTINCT * FROM my_table;
D
MERGE INTO my_table a USING new_records b ON a.id = b.id WHEN NOT MATCHED THEN INSERT *;
E
MERGE INTO my_table a USING new_records b;