Valid DP-200 Dumps shared by PrepAwayExam.com for Helping Passing DP-200 Exam! PrepAwayExam.com now offer the newest DP-200 exam dumps, the PrepAwayExam.com DP-200 exam questions have been updated and answers have been corrected get the newest PrepAwayExam.com DP-200 dumps with Test Engine here:
Note: This question is part of series of questions that present the same scenario. Each question in the series contain 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 a workload group using the Azure storage account name as the pool name 3. Load the data using the INSERT...SELECTstatement Does the solution meet the goal?
Correct Answer: B
Explanation/Reference: Explanation: You need to create an external file format and external table using the external data source. You then load the data using the CREATE TABLE AS SELECT statement. References: https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-load-from-azure-data- lake-store