Microsoft
70-776 · Question #23
70-776 Question #23: Real Exam Question with Answer & Explanation
Sign in or unlock 70-776 to reveal the answer and full explanation for question #23. The question stem and answer options stay visible for context.
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
Unlock 70-776 to see the answer
You've previewed enough free 70-776 questions. Unlock 70-776 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.