ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-200 All Questions

View all questions & answers for the DP-200 exam
Go to Exam

Exam DP-200 topic 2 question 59 discussion

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

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. Use Azure Data Factory to convert the parquet files to CSV files
2. Create an external data source pointing to the Azure storage account
3. Create an external file format and external table using the external data source
4. Load the data using the INSERT`¦SELECT statement
Does the solution meet the goal?

  • A. Yes
  • B. No
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
There is no need to convert the parquet files to CSV files.
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 TJ0071 at April 18, 2021, 4:53 p.m.

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
Submit Cancel
SorinXp
3 years, 12 months ago
This solution meet the goal, but it is not an optimized solution. The answer should be Yes
upvoted 2 times
...
MMM777
4 years ago
1) Create the target table to load data from Azure Data Lake Storage. 2) Use the COPY statement to load data into the data warehouse. t-sql COPY statement can directly read Parquet https://docs.microsoft.com/en-us/sql/t-sql/statements/copy-into-transact-sql?view=azure-sqldw-latest&preserve-view=true
upvoted 1 times
...
cadio30
4 years ago
No, instead of using data factory, use external data source and it requires creation of master key and database scope credential.
upvoted 2 times
...
TJ0071
4 years ago
The question says does this meet the goal? The solution provided might not be the optimized solution, but does this meet the goal? Please answer.
upvoted 2 times
hello_there_
3 years, 10 months ago
No, the target table doesn't exist so insert statement won't work.
upvoted 2 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago