DRAG DROP -
You develop data engineering solutions for a company. You must migrate data from Microsoft Azure Blob storage to an Azure SQL Data Warehouse for further transformation. You need to implement the solution.
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.
Select and Place:
Step 1: Provision an Azure SQL Data Warehouse instance.
Create a data warehouse in the Azure portal.
Step 2: Connect to the Azure SQL Data warehouse by using SQL Server Management Studio
Connect to the data warehouse with SSMS (SQL Server Management Studio)
Step 3: Build external tables by using the SQL Server Management Studio
Create external tables for data in Azure blob storage.
You are ready to begin the process of loading data into your new data warehouse. You use external tables to load data from the Azure storage blob.
Step 4: Run Transact-SQL statements to load data.
You can use the CREATE TABLE AS SELECT (CTAS) T-SQL statement to load the data from Azure Storage Blob into new tables in your data warehouse.
References:
https://github.com/MicrosoftDocs/azure-docs/blob/master/articles/sql-data-warehouse/load-data-from-azure-blob-storage-using-polybase.md
Step 2 should be "Connect to SQL data warehouse using SSMS
Step 2:Connect to the Azure SQL Data warehouse by using SQL Server Management Studio
I've a doubt about step 2. Which is the correct one? "Connect to the Blob Storage container by using SQL Server Management Studio." or "Connect to the Azure SQL Data Warehouse by using SQL Server Management Studio" Thank you in advance.
look at the explanation, it should be Azure SQL Data Warehouse. Blob storage doesn't make sense here.
Why are we using sql data warehouse instance?
nope step 2 is point to Blob Storage (check polybase load steps!)
also for me "Connect to SQL data warehouse using SSMS" on step 2