Implementing an Azure Data Solution (legacy) — Question 19

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?

Answer options

Correct answer: A

Explanation

The solution is correct because it effectively uses Azure Data Factory to handle data conversion and sets up the necessary external data source, file format, and table. These steps are essential for loading data from Azure Data Lake Gen 2 into Azure Synapse Analytics, thus meeting the stated goals.