Question 66

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.

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