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
How To Pass Azure AZ-305 Exam?Microsoft Azure AZ-305 PDF dumps.High quality AZ-305 PDF and software. VALID exam to help you pass. |