Microsoft
70-776 · Question #35
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…
The correct answer is D. Create a Microsoft SQL Server Integration Services (SSIS) package that has an SSIS Azure Blob. See the full explanation below for the reasoning.
Question
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?
Options
- AUse the bcp utility.
- BExecute the CREATE EXTERNAL TABLE AS SELECT statement.
- CCreate a Microsoft SQL Server Integration Services (SSIS) package that has a data flow task.
- DCreate a Microsoft SQL Server Integration Services (SSIS) package that has an SSIS Azure Blob
How the community answered
(27 responses)- A15% (4)
- B4% (1)
- C4% (1)
- D78% (21)
Community Discussion
No community discussion yet for this question.