Ultimate access to all questions.
You have an Azure subscription containing an Azure SQL database named DB1 and a storage account named storage1. The storage1 account contains a file named File1.txt, which lists the names of specific tables from DB1.
You need to create an Azure Synapse Analytics pipeline to copy data from the listed tables in DB1 to corresponding files in storage1. The solution must meet the following requirements:
• The Copy activity must be parameterized to use the information in File1.txt to determine the source table and the destination file. • Copy operations should run in parallel whenever possible.
Which two pipeline activities should you use? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.