Microsoft
70-458 · Question #59
You administer all the deployments of Microsoft SQL Server 2012 in your company. You need to ensure that data changes are sent to a non-SQL Server database server in near real time. You also need to…
The correct answer is A. SQL Server that includes an application database configured to perform transactional. See the full explanation below for the reasoning.
Question
You administer all the deployments of Microsoft SQL Server 2012 in your company. You need to ensure that data changes are sent to a non-SQL Server database server in near real time. You also need to ensure that data on the primary server is unaffected. Which configuration should you use?
Options
- ASQL Server that includes an application database configured to perform transactional
- BTwo servers configured in different data centers
- CTwo servers configured in different data centers
- DSQL Server that includes an application database configured to perform snapshot
- ETwo servers configured in the same data center
- FTwo servers configured on the same subnet
- GTwo servers configured in a Windows Failover Cluster in the same data center
- HTwo servers configured in the same data center
How the community answered
(43 responses)- A77% (33)
- B2% (1)
- C2% (1)
- E12% (5)
- H7% (3)
Community Discussion
No community discussion yet for this question.