DP-200 Exam - Question 87

Question

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?

Examice · Accepted Answer

The proposed solution involves an unnecessary step of converting parquet files to CSV files. Azure Synapse Analytics can directly read parquet files, which are optimized for big data operations. Adding an extra conversion step is not required and introduces additional overhead. Therefore, the proposed solution does not meet the goal efficiently.

vaseva1 · Answer

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

Qrm_1972 · Answer

Correct answer is ( B-------- No )

Ash001 · Answer

It should be No as per the details provided.

KpKo · Answer

The answer should be A: Yes. Since it meets the goal though it is not necessary to change the parquet to csv but you can change it.

Wendy_DK · Answer

Correct Answer is B

maciejt · Answer

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

nishant_678993 · Answer

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.

FredNo · Answer

No need to convert to CSV File

DP-200 Exam - Question 87

Discussion