DP-203 · Question #313
You have an Azure Synapse Analytics dedicated SQL pool that contains a table named DimSalesPerson. DimSalesPerson contains the following columns: - RepSourceID - SalesRepID - FirstName - LastName…
The correct answer is C. Insert an extra row. D. Update one column of an existing row. SCD Type 2 will have historical changes hence we will have new row and we need to update the existing row's end date. Hence - CD
Question
You have an Azure Synapse Analytics dedicated SQL pool that contains a table named DimSalesPerson. DimSalesPerson contains the following columns:
- RepSourceID
- SalesRepID
- FirstName
- LastName
- StartDate
- EndDate
- Region
You are developing an Azure Synapse Analytics pipeline that includes a mapping data flow named Dataflow1. Dataflow1 will read sales team data from an external source and use a Type 2 slowly changing dimension (SCD) when loading the data into DimSalesPerson. You need to update the last name of a salesperson in DimSalesPerson. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
Options
- AUpdate three columns of an existing row.
- BUpdate two columns of an existing row.
- CInsert an extra row.
- DUpdate one column of an existing row.
How the community answered
(36 responses)- A17% (6)
- B11% (4)
- C72% (26)
Explanation
SCD Type 2 will have historical changes hence we will have new row and we need to update the existing row's end date. Hence - CD
Topics
Community Discussion
No community discussion yet for this question.