PrepAway - Latest Free Exam Questions & Answers

You need to export 10 TB of data from a data warehouse …

You have a Microsoft Azure SQL data warehouse that has 10 compute nodes.
You need to export 10 TB of data from a data warehouse table to several new flat files in Azure Blob storage.
The solution must maximize the use of the available compute nodes.
What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Use the bcp utility.

B.
Execute the CREATE EXTERNAL TABLE AS SELECT statement.

C.
Create a Microsoft SQL Server Integration Services (SSIS) package that has a data flow task.

D.
Create a Microsoft SQL Server Integration Services (SSIS) package that has an SSIS Azure Blob Storage
task.


Leave a Reply