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

Last Updated on October 23, 2021 by Admin 3

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.)

DA-100 Analyzing Data with Microsoft Power BI Part 05 Q12 122
DA-100 Analyzing Data with Microsoft Power BI Part 05 Q12 122

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.

DA-100 Analyzing Data with Microsoft Power BI Part 05 Q12 123 Question
DA-100 Analyzing Data with Microsoft Power BI Part 05 Q12 123 Question
DA-100 Analyzing Data with Microsoft Power BI Part 05 Q12 123 Answer
DA-100 Analyzing Data with Microsoft Power BI Part 05 Q12 123 Answer

0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments