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:

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:

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



Leave a Reply 1

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


masterkey

masterkey

Minimize cost would be SSIS for the first one.