Prev Next Question 20/24 - DP-200.v2019-06-23

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?

LEAVE A REPLY

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

Question List (24q)
Question 1: You need to process and query ingested Tier 9 data. Which tw...
Question 2: You need to ensure that phone-based poling data can be analy...
Question 3: A company plans to use Azure Storage for file storage purpos...
Question 4: You plan to use Microsoft Azure SQL Database instances with ...
Question 5: Note: This question is part of a series of questions that pr...
Question 6: You develop data engineering solutions for a company. You mu...
Question 7: You develop data engineering solutions for a company. You ne...
Question 8: Each day, company plans to store hundreds of files in Azure ...
Question 9: A company manages several on-premises Microsoft SQL Server d...
Question 10: An application will use Microsoft Azure Cosmos DB as its dat...
Question 11: You need to set up Azure Data Factory pipelines to meet data...
Question 12: You are the data engineer for your company. An application u...
Question 13: You develop data engineering solutions for a company. The co...
Question 14: Note: This question is part of series of questions that pres...
Question 15: A company uses Azure SQL Database to store sales transaction...
Question 16: Note: This question is part of a series of questions that pr...
Question 17: You are a data engineer implementing a lambda architecture o...
Question 18: The data engineering team manages Azure HDInsight clusters. ...
Question 19: A company is designing a hybrid solution to synchronize data...
Question 20: Note: This question is part of series of questions that pres...
Question 21: Note: This question is part of series of questions that pres...
Question 22: A company has a SaaS solution that uses Azure SQL Database w...
Question 23: You are a data architect. The data engineering team needs to...
Question 24: A company plans to use Azure SQL Database to support a missi...