PrepAway - Latest Free Exam Questions & Answers

Which two actions should you perform?

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.

PrepAway - Latest Free Exam Questions & Answers

A.
Use SSIS to upload the files in Azure Blob storage to tables in the Azure SQL data warehouse.

B.
Execute the CREATE EXTERNAL TABLE AS SELECT statement to export the data.

C.
Use AzCopy to transfer the data from the on-premises data warehouse to Azure SQL data warehouse.

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 Blob storage.

Explanation:
https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-load-from-azure-blob-storagewith-polybase


Leave a Reply