Answer-first summary for fast verification
Answer: Use Azure Data Factory to create a pipeline that moves data from the on-premises SQL Server database to Azure Synapse Analytics.
The correct approach is to use Azure Data Factory to create a pipeline that moves data from the on-premises SQL Server database to Azure Synapse Analytics. This allows for efficient processing of large amounts of data using the power of Azure Synapse Analytics. Option A is incorrect because Azure Blob Storage is a storage service and is not used for processing data. Option B is incorrect because Azure Data Lake Storage Gen2 is a storage service and is not used for processing data. Option D is incorrect because Azure Databricks is used for processing data, but it is not the best choice for moving data from an on-premises SQL Server database.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You are tasked with developing a batch processing solution using Azure Data Factory. Your company has a large amount of data stored in an on-premises SQL Server database that needs to be processed. How would you approach this task?
A
Use Azure Data Factory to create a pipeline that moves data from the on-premises SQL Server database to Azure Blob Storage.
B
Use Azure Data Factory to create a pipeline that moves data from the on-premises SQL Server database to Azure Data Lake Storage Gen2.
C
Use Azure Data Factory to create a pipeline that moves data from the on-premises SQL Server database to Azure Synapse Analytics.
D
Use Azure Data Factory to create a pipeline that moves data from the on-premises SQL Server database to Azure Databricks.
No comments yet.