Microsoft
70-776 · Question #2
You manage an on-premises data warehouse that uses Microsoft SQL Server. The data warehouse contains 100 TB of data. The data is partitioned by month. One TB of data is added to the data warehouse…
The correct answer is C. Azure Data Factory. See the full explanation below for the reasoning.
Question
You manage an on-premises data warehouse that uses Microsoft SQL Server. The data warehouse contains 100 TB of data. The data is partitioned by month. One TB of data is added to the data warehouse each month. You create a Microsoft Azure SQL data warehouse and copy the on-premises data to the data warehouse. You need to implement a process to replicate the on-premises data warehouse to the Azure SQL data warehouse. The solution must support daily incremental updates and must provide error handling. What should you use?
Options
- Athe Azure Import/Export service
- BSQL Server log shipping
- CAzure Data Factory
- Dthe AzCopy utility
How the community answered
(61 responses)- A13% (8)
- B2% (1)
- C79% (48)
- D7% (4)
Community Discussion
No community discussion yet for this question.