Answer-first summary for fast verification
Answer: Create an external table in the SQL pool that references the data stored in Azure Blob Storage.
The correct approach is to create an external table in the SQL pool that references the data stored in Azure Blob Storage. This allows PolyBase to access the data in Azure Blob Storage and load it into the SQL pool. Option B is incorrect because Azure Data Factory is used for moving data between different storage services, not for loading data into a SQL pool. Option C is incorrect because Azure Databricks is used for processing data, not for loading data into a SQL pool. Option D is incorrect because Azure Synapse Link is used for replicating data from Azure Cosmos DB to a SQL pool, not from Azure Blob Storage.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You are working on a project that requires loading large amounts of data into a SQL pool. You have been asked to use PolyBase to achieve this. What steps would you take to implement PolyBase for loading data into a SQL pool?
A
Create an external table in the SQL pool that references the data stored in Azure Blob Storage.
B
Use Azure Data Factory to create a pipeline that moves data from Azure Blob Storage to the SQL pool.
C
Use Azure Databricks to read data from Azure Blob Storage and write it to the SQL pool.
D
Use Azure Synapse Link to replicate data from Azure Blob Storage to the SQL pool.
No comments yet.