You are a database administrator for a Microsoft SQL Server instance. You need to ensure that data can be migrated from
Posted: Mon Oct 17, 2022 4:48 pm
You are a database administrator for a Microsoft SQL Server instance.
You need to ensure that data can be migrated from a production server to two reporting servers with minimal data latency. You also need to ensure that data on the reporting server is always accessible.
A. Database Snapshot
B. Log Shipping
C. Availability Groups
D. Change Data Capture
You need to ensure that data can be migrated from a production server to two reporting servers with minimal data latency. You also need to ensure that data on the reporting server is always accessible.
A. Database Snapshot
B. Log Shipping
C. Availability Groups
D. Change Data Capture