Exit 70-457 Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012, Part 1
Question 2 of 5
0% complete
Q2 Single choice

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?

  • A

    - SQL Server that includes an application database configured to perform transactional replication

  • B

    - Two servers configured in different data centers
    - SQL Server Availability Group configured in Asynchronous-Commit Availability Mode

  • C

    - Two servers configured in different data centers
    - SQL Server Availability Group configured in Synchronous-Commit Availability Mode - One server
    configured as an Active Secondary

  • D

    - SQL Server that includes an application database configured to perform snapshot replication

  • E

    - Two servers configured in the same data center
    - SQL Server Availability Group configured in Asynchronous-Commit Availability Mode - One server
    configured as an Active Secondary

  • F

    - Two servers configured on the same subnet
    - SQL Server Availability Group configured in Synchronous-Commit Availability Mode

  • G

    - Two servers configured in a Windows Failover Cluster in the same data center - SQL Server
    configured as a clustered instance

  • H

    - Two servers configured in the same data center
    - A primary server configured to perform log-shipping every 10 minutes - A backup server configured as
    a warm standby

Previous Next