Exit 70-776 Perform Big Data Engineering on Microsoft Cloud Services
Question 5 of 5
0% complete
Q5 Single choice

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.

Previous Save & finish