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.
A. Set the External property to true.
B. Add a column named SliceIdentifierColumnName to the output dataset.
C. Set the SqlWriterCleanupScript property to true.
D. Remove the duplicates in post-processing.
E. Manually delete the duplicate data before running the pipeline activity.
