Forum Discussion

jerrylau38's avatar
jerrylau38
Copper Contributor
Apr 28, 2025

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

 

Resources