Microsoft
70-458 · Question #104
You are a database administrator for a Microsoft SQL Server 2012 instance. You need to ensure that data can be migrated from a production server to two reporting servers with minimal data latency…
The correct answer is C. Availability Groups. See the full explanation below for the reasoning.
Question
You are a database administrator for a Microsoft SQL Server 2012 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. Which solution should you use?
Options
- AChange Data Capture
- BDatabase snapshot
- CAvailability Groups
- DLog Shipping
How the community answered
(30 responses)- A7% (2)
- B17% (5)
- C70% (21)
- D7% (2)
Community Discussion
No community discussion yet for this question.