Microsoft
70-457 · Question #106
You administer all the deployments of Microsoft SQL Server 2012 in your company. You need to ensure that an OLTP database that uses a storage area network (SAN) remains available if any of the…
The correct answer is H. Two servers configured in a Windows Failover Cluster in the same data center. 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 an OLTP database that uses a storage area network (SAN) remains available if any of the servers fail. You also need to minimize the amount of storage used by the database. Which configuration should you use?
Options
- ATwo servers configured in different data centers
- BSQL Server that includes an application database configured to perform transactional replication
- CTwo servers configured in the same data center
- DTwo servers configured in different data centers
- ETwo servers configured in the same data center
- FTwo servers configured on the same subnet
- GSQL Server that includes an application database configured to perform snapshot replication
- HTwo servers configured in a Windows Failover Cluster in the same data center
How the community answered
(62 responses)- C3% (2)
- E3% (2)
- F2% (1)
- G8% (5)
- H84% (52)
Community Discussion
No community discussion yet for this question.