Ultimate access to all questions.
You are using Azure Synapse Pipelines to ingest and transform data from multiple sources. You have a source dataset that contains duplicate records, and you need to remove these duplicates before loading the data into the destination dataset. Which of the following Azure Synapse Pipeline activities would you use to handle duplicate data?