Loading Data from Azure Data Lake Gen 2 to Azure Synapse Analytics
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 CREATE TABLE AS SELECT statement
Does the solution meet the goal?
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B.B
Use the Azure Data Lake Gen 2 storage account.
https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-load-from-azure-data-lake-storeThe solution presented in this scenario appears to be correct and should meet the goal of loading data from an Azure Data Lake Gen 2 storage account into an enterprise data warehouse in Azure Synapse Analytics.
Here's a more detailed explanation of each step in the solution:
Creating an external data source: An external data source is a definition that represents a location of an external resource such as Azure Data Lake Gen2 storage account. By creating an external data source pointing to the Azure storage account, it will allow us to read data from the storage account into Synapse Analytics.
Creating a workload group: A workload group is a logical container for a set of sessions that have similar resource requirements. By creating a workload group using the Azure storage account name as the pool name, we can isolate the processing of data from this external data source, which helps optimize resources and performance.
Load data using the CREATE TABLE AS SELECT statement: The CREATE TABLE AS SELECT statement is used to create a new table in the data warehouse that contains data from an existing table or view. In this case, it's used to load the data from the external data source into the data warehouse.
Overall, the solution appears to be well-designed and meets the stated goal of loading data from an Azure Data Lake Gen 2 storage account into an enterprise data warehouse in Azure Synapse Analytics. Therefore, the answer is A. Yes.
