Does the solution meet the goal?

Note: This question-is 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 a Microsoft Azure SQL Data Warehouse. 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 Azure SQL Data Warehouse.
Solution:
1. Create an external data source pointing to the Azure storage account
2. Create an external file format and external table using the external data source
3. Load the data using the INSERT…SELECT statement
Does the solution meet the goal?
A. Yes
B. No

microsoft-exams

One thought on “Does the solution meet the goal?

  1. if you already have a table you want to load the data into, there is nothing holding you back to use a INSERT…SELECT statement here. I do this all the time. I think this solution is valid as well.

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.