Exam DP-600 topic 1 question 116 discussion

Actual exam question from Microsoft's DP-600

Question #: 116
Topic #: 1

DRAG DROP
-

You have a Fabric tenant that contains a data warehouse named DW1. DW1 contains a table named DimCustomer. DimCustomer contains the fields shown in the following table.

You need to identify duplicate email addresses in DimCustomer. The solution must return a maximum of 1,000 records.

Which four T-SQL statements should you run in sequence? To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.