Exam DP-200 topic 2 question 29 discussion

Actual exam question from Microsoft's DP-200

Question #: 29
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. Use Azure Data Factory to convert the parquet files to CSV files
2. Create an external data source pointing to the Azure Data Lake Gen 2 storage account
3. Create an external file format and external table using the external data source
4. Load the data using the CREATE TABLE AS SELECT statement
Does the solution meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: A 🗳️
It is not necessary to convert the parquet files to CSV files.
You need to create an external file format and external table using the external data source.
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 Ash001 at April 3, 2021, 10:56 a.m.

Comments

Submit Cancel

vaseva1

Highly Voted 4 years, 2 months ago

It is not necessary to convert the parquet files to CSV files.--> Answer No

upvoted 9 times

Mily94

4 years, 1 month ago

indeed, it is not necessary to convert parquet to CSV, but the question is if that apporach meet the goal - A: yes

upvoted 14 times

...

FredNo

Most Recent 3 years, 6 months ago

Selected Answer: B

No need to convert to CSV File

upvoted 1 times

...

nishant_678993

4 years ago

why would i convert to csv ..When my further steps are going to read data from ADLS. Explanation says not required and ANSWER says YES.

upvoted 1 times

...

maciejt

4 years ago

You can just use data factory to read parquest and ingest to Synapse with auto creating table, but per se the given solution meets the goal even if in not optimal way

upvoted 1 times

...