What should you use?

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?
A. the Azure Import/Export service
B. SQL Server log shipping
C. Azure Data Factory
D. the AzCopy utility

microsoft-exams

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.