Forum Discussion
DP-600PA-202 assessment incorrect setup
Hi all,
Not sure if this is the right place to go
For the DP-600 exam prep assessment Q31
It asked to select 3 steps (answers) but the shown up correct answers selected 2 only
---------------------------------------------------------------------------------------------
You have a Fabric lakehouse named Lakehouse1 that contains a Dataflow Gen2 query.
You have an Azure SQL database that contains a type 2 slowly changing dimension database table named CustomerMaster.
CustomerMaster contains the following columns:
- Customer ID – Number
- EffectiveDate – Date
- Address – Text
- Status - Text
You plan to ingest CustomerMaster into Lakehouse1. The solution must only keep the latest record (unique) per Customer ID.
Which three applied steps should you use? Each correct answer presents part of the solution.
Add Table.Buffer applied step
Group By: Customer ID
Keep top rows
Max Customer ID
Remove duplicates on the Customer ID column
Remove duplicates on the CustomerMaster table
1 Reply
- Julian_SharpLearn Expert
If you would like to provide feedback about a Practice Assessment use https://aka.ms/PracticeTestFdbk