exam questions

Exam DP-200 All Questions

View all questions & answers for the DP-200 exam

Exam DP-200 topic 1 question 2 discussion

Actual exam question from Microsoft's DP-200
Question #: 2
Topic #: 1
[All DP-200 Questions]

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:

Show Suggested Answer Hide Answer
Suggested Answer:
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

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
ssanka
Highly Voted 4 years ago
Step 2 should be "Connect to SQL data warehouse using SSMS
upvoted 15 times
...
massnonn
Most Recent 3 years, 5 months ago
also for me "Connect to SQL data warehouse using SSMS" on step 2
upvoted 1 times
...
Williammm
3 years, 10 months ago
nope step 2 is point to Blob Storage (check polybase load steps!)
upvoted 1 times
...
fumaniM
3 years, 11 months ago
Step 2:Connect to the Azure SQL Data warehouse by using SQL Server Management Studio
upvoted 4 times
...
Aakansha01
4 years ago
Why are we using sql data warehouse instance?
upvoted 1 times
...
tucho
4 years, 1 month ago
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.
upvoted 3 times
DongDuong
4 years, 1 month ago
look at the explanation, it should be Azure SQL Data Warehouse. Blob storage doesn't make sense here.
upvoted 9 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago