Exam DP-200 topic 2 question 60 discussion

Actual exam question from Microsoft's DP-200

Question #: 60
Topic #: 2

Note: This question is a part of series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.
You develop a data ingestion process that will import data to an enterprise data warehouse in Azure Synapse Analytics. The data to be ingested resides in parquet files stored in an Azure Data Lake Gen 2 storage account.
You need to load the data from the Azure Data Lake Gen 2 storage account into the Data Warehouse.
Solution:
1. Create an external data source pointing to the Azure storage account
2. Create an external file format and external table using the external data source
3. Load the data using the INSERT`¦SELECT statement
Does the solution meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: B 🗳️
You load the data using the CREATE TABLE AS SELECT statement.
References:
https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-load-from-azure-data-lake-store

by memo43 at May 16, 2021, 5:48 p.m.

Comments

Submit Cancel

maciejt

4 years ago

Doen't it meet the goal

upvoted 1 times

...

memo43

4 years ago

answer is CORRECT

upvoted 3 times

lgtiza

3 years, 11 months ago

I think it's not correct unless the table (not the external table) was created already, which means you need a CREATE TABLE ... AS SELECT.. statement. Since it doesn't say the table exists you need to create it.

upvoted 2 times

...