What should you use?

You have an Azure Data Lake Storage account that contains 1,000 10-MB CSV files and an Azure Synapse Analytics dedicated SQL pool named sql1. You need to load the files to sql1.

The solution must meet the following requirements:

✑ Maximize data load performance.

✑ Eliminate the need to define external tables before the data loads.

What should you use?
A . the copy statement
B. PolyBase
C. BCP
D. the sqlBulkcopy object

View Answer

Answer: B