Valid 70-414 Dumps shared by ExamDiscuss.com for Helping Passing 70-414 Exam! ExamDiscuss.com now offer the newest 70-414 exam dumps, the ExamDiscuss.com 70-414 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 70-414 dumps with Test Engine here:
Your network contains a main data center and a disaster recovery data center. Each data center contains a Storage Area Network (SAN). The main data center contains a two-node failover cluster named Cluster1 that hosts a Microsoft SQL Server 2012 database named DB1. The database files in DB1 are stored on the SAN in the main office. The disaster recovery data center contains a server that runs SQL Server 2012. You need to recommend a disaster recovery solution for the SQL Server database. The solution must ensure that the database remains available if the main data center fails. What should you recommend? More than one answer choice may achieve the goal. Select the BEST answer.
Correct Answer: D
Explanation/Reference: Explanation: Replication is a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency. Using replication, you can distribute data to different locations and to remote or mobile users over local and wide area networks, dial-up connections, wireless connections, and the Internet. Transactional replication is typically used in server-to-server scenarios that require high throughput, including: improving scalability and availability; data warehousing and reporting; integrating data from multiple sites; integrating heterogeneous data; and offloading batch processing. Merge replication is primarily designed for mobile applications or distributed server applications that have possible data conflicts. Common scenarios include: exchanging data with mobile users; consumer point of sale (POS) applications; and integration of data from multiple sites. Snapshot replication is used to provide the initial data set for transactional and merge replication: it can also be used when complete refreshes of data are appropriate. With these three types of replication, SQL Server provides a powerful and flexible system for synchronizing data across your enterprise.