DP-200 Exam - Question 61

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 an external data source pointing to the Azure storage account

2. Create a workload group using the Azure storage account name as the pool name

3. Load the data using the INSERT`¦SELECT statement

Does the solution meet the goal?

Examice · Accepted Answer

The solution does not meet the goal. To load data from an Azure Data Lake Gen 2 storage account into an Azure Synapse Analytics data warehouse, you need to first create an external data source pointing to the Azure storage account, followed by creating an external file format and an external table using the external data source. The data is then loaded using the CREATE TABLE AS SELECT statement, not the INSERT SELECT statement. Therefore, the provided steps in the solution are incomplete and incorrect for achieving the stated goal.

certstowinirl · Answer

This is correct, please refer to: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-load-from-azure-data-lake-store

DP-200 Exam - Question 61

Discussion