PrepAway - Latest Free Exam Questions & Answers

What should you use to move the data from DW1 to DB1, a…

HOTSPOT
You have a Microsoft Azure SQL data warehouse named DW1.
A department in your company creates an Azure SQL database named DB1. DB1 is a data mart.
Each night, you need to insert new rows into 9.000 tables in DB1 from changed data in DW1. The solution must
minimize costs.
What should you use to move the data from DW1 to DB1, and then to import the changed data to DB1? To
answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

PrepAway - Latest Free Exam Questions & Answers

Answer:

Explanation:
Box 1: Azure Data Factory
Use the Copy Activity in Azure Data Factory to move data to/from Azure SQL Data Warehouse.
Box 2: The BULK INSERT statement
https://docs.microsoft.com/en-us/azure/data-factory/data-factory-azure-sql-data-warehouseconnector

One Comment on “What should you use to move the data from DW1 to DB1, a…


Leave a Reply