Exam Databricks-Certified-Professional-Data-Engineer Topic 5 Question 155 Discussion

Actual exam question for Databricks's Databricks-Certified-Professional-Data-Engineer exam
Question #: 155
Topic #: 5

Which of the following commands will return records from an existing Delta table my_table where duplicates
have been removed?

A. 1. MERGE INTO my_table a
2. USING new_records b ON a.id = b.id
3. WHEN NOT MATCHED
4. THEN INSERT *; B. 1. SELECT DISTINCT *
2. FROM my_table; C. 1. MERGE INTO my_table a
2. USING new_records b; D. 1. DROP DUPLICATES
2. FROM my_table; E. 1. SELECT *
2. FROM my_table
3. WHERE duplicate = False;

Comments

0 Satisfied Customers

0 Shares

0 Demo Downloads

10 Years in Business