You have an Azure Synapse Analytics dedicated SQL pool with a table named DimSalesPerson that has the following columns:

• RepSourceID

• SalesRepID

• FirstName

• LastName

• StartDate

• EndDate

• Region

You are building an Azure Synapse Analytics pipeline that uses a mapping data flow named Dataflow1. This data flow reads sales team data from an external source and implements a Type 2 slowly changing dimension (SCD) to load data into DimSalesPerson.

You need to update the last name of a salesperson in the DimSalesPerson table.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.