DP-200 Exam - Question 78

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. Create a remote service binding pointing to the Azure Data Lake Gen 2 storage account

2. Create an external file format and external table using the external data source

3. Load the data using the CREATE TABLE AS SELECT statement

Does the solution meet the goal?

Examice · Accepted Answer

To load data from an Azure Data Lake Gen 2 storage account into Azure Synapse Analytics, one needs to create an external data source pointing to the Azure Data Lake Gen 2 storage account. The steps mentioned in the solution, which include creating a remote service binding, creating an external file format and external table, and finally loading data using the CREATE TABLE AS SELECT statement, are correct and align with best practices for such data ingestion processes. Therefore, the solution meets the goal.

Ankush1994 · Answer

A
Answer is correct

niwe · Answer

This should be the correct answer

wxlf23 · Answer

1. Create an external data source pointing to the Azure Data Lake Gen 2 storage account
vs
1. Create a remote service binding pointing to the Azure Data Lake Gen 2 storage account

Which is correct?

DP-200 Exam - Question 78

Discussion