Which three actions should you perform in sequence?

DRAG DROP

You have a query named Customer that imports CSV files from a data lake.

The query contains 500 rows as shown in the exhibit. (Click the Exhibit tab.)

Each file contains deltas of any new or modified rows from each load to the data lake.

Multiple files can have the same customer ID.

You need to keep only the last modified row for each customer ID.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

View Answer

Answer:

Explanation:

1) Duplicate Customer query

2) Group by CustId by Max ModifiedDate (only 2 columns to keep)

3) Merge two queries on CustId and ModifiedDate inner join (to retreive other customer informations related to latest Date)