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 - St
Sign in or unlock DP-203 to reveal the answer and full explanation for question #313. The question stem and answer options stay visible for context.
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.
Unlock DP-203 to see the answer
You've previewed enough free DP-203 questions. Unlock DP-203 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.