What should you do?

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?
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.

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.