Exam DP-203 topic 1 question 82 discussion

The answer is correct. Check "Exercise - Design and implement a Type 1 slowly changing dimension with mapping data flows", there is described implementation of the dataflow mentioned in this question. https://learn.microsoft.com/en-us/training/modules/populate-slowly-changing-dimensions-azure-synapse-analytics-pipelines/4-exercise-design-implement-type-1-dimension In the exercise 'Derived column' transformation is used to add InsertedDate and ModifiedDate columns. ModifiedDate column can be used to detect whether the customer data has changed. For Upsert 'Alter row' tranformation is used. The answer is definitely correct.

Answer is correct.. 1) we don't need a surrogate key in SCD type 1. you can use a Derived Column transformation to compare the incoming data with the existing data in the DimCustomer table and detect changes.. Statement 2: To perform an upsert to the DimCustomer table, you should use an Alter Row transformation. This transformation can be used to specify the actions to take for each row of data, such as inserting new rows or updating existing rows. The current web page context is empty.

I found this question on my exam 30/04/2024, and I put: - derived column - alter row I passed the exam with a high score, but I'm not sure if the answer is correct.

Aggregate and alter row. Aggregate will give table statistics which reveals information on max.minimum,sum ,average etc. While alter row encompasses ,update & insert which are upset operations

'Derived column' &'Alter row'

answer is correct

'Derived column' & 'Alter row'

surrogate key and assert

surrogate key and alter row according to chatgpt

It should be aggregate and alter row As we talking Type 1 slowly changing dimension, we want to replace the current row with the updated one. This can be achieved by aggregate. "A common use of the aggregate transformation is removing or identifying duplicate entries in source data. This process is known as deduplication. Based upon a set of group by keys, use a heuristic of your choosing to determine which duplicate row to keep. Common heuristics are first(), last(), max(), and min(). Use column patterns to apply the rule to every column except for the group by columns." As in https://learn.microsoft.com/en-us/azure/data-factory/data-flow-aggregate Alter row is correct: https://learn.microsoft.com/en-us/azure/data-factory/data-flow-alter-row#merges-and-upserts-with-azure-sql-database-and-azure-synapse