DRAG DROP You have a query named Customer that imports CSV files from a data lake. The query contains 50,000 rows as shown in the exhibit. (Click the Exhibit tab.) *(refer to diagram in explanation below)* 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.
Select one answer.
Purchase Full Access to view answer options & explanation
The first 134 questions in this bank are completely free. Unlock Full Access on the exam page to view all answer choices, verified answers, explanations, and community discussions for all 444 questions.
