Home » Microsoft » 70-473 v.2 » Which four actions should you perform in sequence?
DRAG DROP
You are designing a hybrid data analytics solution that contains an on-premises Microsoft SQL Server environment and a Microsoft Azure SQL Data warehouse.
You need to load data into the data warehouse from the SQL Server environment as quickly as possible.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
Select and Place:
Correct Answer:
Explanation/Reference:
Explanation:
Step 1: Prepare to copy the on-premise data.
Step 2:
Copy the data from on-premise SQL server to Azure Blob Storage
Step 3:
Run the CREATE EXTERNAL DATA SOURCE statement to define the location of the Azure blob.
Then create a schema for your external file format. The ext schema provides a way to organize the external tables you are about to create.
Step 4:
Create the external tables. The table definitions are stored in SQL Data Warehouse, but the tables reference data that is stored in Azure blob storage.
Next Step:
Load the data into your data warehouse
Use the external tables you just defined to load the data from Azure Blob to SQL Data Warehouse.
Reference: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/load-data-wideworldimportersdw https://docs.microsoft.com/en-us/azure/data-factory/ tutorial-hybrid-copy-data-tool