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 export and import of BACPAC files
B. SQL Server Integration Services (SSIS)
C. SQL Server backup and restore
D. SQL Server snapshot replication
You manage an on-premises data warehouse that uses Microsoft SQL Server. The data warehouse contains 100 TB of data. The
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
You manage an on-premises data warehouse that uses Microsoft SQL Server. The data warehouse contains 100 TB of data. The
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!