Câu 10: 70-776: Perform Big Data Engineering on Microsoft Cloud Services
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…
Nội dung câu hỏi
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?
Các lựa chọn
Đáp án được giữ gọn theo nhãn A, B, C, D trong phần bình chọn tương tác.
- A. the export and import of BACPAC files
- B. SQL Server Integration Services (SSIS) — đáp án hiện tại
- C. SQL Server backup and restore
- D. SQL Server snapshot replication
Cộng đồng
0 bình luận công khai. Tên thành viên được ẩn một phần.