Microsoft
70-475 · Question #54
You are using a Microsoft Azure Data Factory pipeline to copy data to an Azure SQL database. You need to prevent the insertion of duplicate data for a given dataset slice. Which two actions should…
The correct answer is B. Add a column named SliceIdentifierColumnName to the output dataset. C. Set the SqlWriterCleanupScript property to true. See the full explanation below for the reasoning.
Question
You are using a Microsoft Azure Data Factory pipeline to copy data to an Azure SQL database. You need to prevent the insertion of duplicate data for a given dataset slice. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
Options
- ASet the External property to true.
- BAdd a column named SliceIdentifierColumnName to the output dataset.
- CSet the SqlWriterCleanupScript property to true.
- DRemove the duplicates in post-processing.
- EManually delete the duplicate data before running the pipeline activity.
How the community answered
(55 responses)- A11% (6)
- B78% (43)
- D7% (4)
- E4% (2)
Community Discussion
No community discussion yet for this question.