Exam DP-200 topic 2 question 2 discussion

The answer is B. Use Azure PowerShell with SQL Server linked service as a source https://docs.microsoft.com/en-us/azure/data-factory/tutorial-incremental-copy-multiple-tables-powershell

C says the linked service is Blob storage. The question says it coming from SQL Server. Why would you use Blob storage as the source?

Correct answer is B. 1. Both *Azure Data Factory UI (Azure Portal)* and *Azure PowerShell* can be used to incrementally load data from multiple tables in SQL Server to a database in Azure SQL Database. 2. Both *Azure Data Factory UI (Azure Portal)* and *Azure PowerShell* can use an SQL Server linked service as a source for this incremental copy. Evidence for these two statements: - *ADF GUI*: https://docs.microsoft.com/en-us/azure/data-factory/tutorial-incremental-copy-multiple-tables-portal - *PowerShell*: https://docs.microsoft.com/en-us/azure/data-factory/tutorial-incremental-copy-multiple-tables-powershell Hence, use *Azure Data Factory UI (Azure Portal) with SQL Server linked service* or use *Azure PowerShell with SQL Server linked service*. Since *ADF with SQL Server linked service* is not an option among the answers ("Blob storage linked service as a source" in answer C is really not necessary), the correct answer is B: Use Azure PowerShell with SQL Server linked service as a source.

The correct answer is : 100% is C

This should be ADF

The answer is B since the catch is the movement of data incrementally which can be done easily through powershell

In my opinion the key word is "pipeline". ADF UI is the only one that creates a pipeline

looks like the question is based on a scenario presented in one of Microsoft help docs : https://docs.microsoft.com/en-us/azure/machine-learning/team-data-science-process/move-sql-azure-adf the scenario assuming the following: The Scenario We set up an ADF pipeline that composes two data migration activities. Together they move data on a daily basis between a SQL Server database and Azure SQL Database. The two activities are: Copy data from a SQL Server database to an Azure Blob Storage account Copy data from the Azure Blob Storage account to Azure SQL Database.

hi to all, the text says "...tool..." so for me that leaves out B and D. answer C seems right but the source is SQL Server onprem, not the blob storage ! so for me it's A because its source is SQL onPrem and because of this link: https://docs.microsoft.com/pt-pt/azure/data-factory/tutorial-hybrid-copy-data-tool so it's A for me. regards

Can someone please explain how blob storage comes into picture in this scenario? The data transformation is being carried out using ADF, and the data moves between on premise SQL Server instance and Azure SQL DB.