Microsoft
70-776 · Question #23
You have an on-premises data warehouse that uses Microsoft SQL Server 2016. All the data in the data warehouse comes from text files stored in Azure Blob storage. The text files are imported into…
The correct answer is D. Execute the CREATE TABLE AS SELECT statement to load the data. E. Define external tables in the Azure SQL data warehouse that map to the existing files in Azure. https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-load-from-azure- blob-storage-with-polybase
Implement Big Data Batch Processing Solutions
Question
You have an on-premises data warehouse that uses Microsoft SQL Server 2016. All the data in the data warehouse comes from text files stored in Azure Blob storage. The text files are imported into the data warehouse by using SQL Server Integration Services (SSIS). The text files are not transformed. You need to migrate the data to an Azure SQL data warehouse in the least amount of time possible. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
Options
- AUse SSIS to upload the files in Azure Blob storage to tables in the Azure SQL data warehouse.
- BExecute the CREATE EXTERNAL TABLE AS SELECT statement to export the data.
- CUse AzCopy to transfer the data from the on-premises data warehouse to Azure SQL data
- DExecute the CREATE TABLE AS SELECT statement to load the data.
- EDefine external tables in the Azure SQL data warehouse that map to the existing files in Azure
How the community answered
(24 responses)- A8% (2)
- B4% (1)
- C8% (2)
- D79% (19)
Explanation
https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-load-from-azure- blob-storage-with-polybase
Topics
#Azure SQL Data Warehouse#external tables#CTAS#data migration
Community Discussion
No community discussion yet for this question.