Microsoft
70-475 · Question #54
70-475 Question #54: Real Exam Question with Answer & Explanation
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.
Community Discussion
No community discussion yet for this question.