70-332 · Question #107
You recently upgraded a SharePoint Server 2010 server farm to SharePoint Server 2013. The farm contains many sites. The sites contain frequently updated content. You need to ensure that users can…
The correct answer is B. Log shipping. SQL Server Log Shipping maintains a near-current secondary copy of SharePoint content databases on a separate server, allowing site collection administrators to perform upgrade evaluations without impacting production users.
Question
Options
- ADatabase mirroring
- BLog shipping
- CAlwaysOn Availability Groups
- DSnapshot
How the community answered
(56 responses)- A13% (7)
- B77% (43)
- C4% (2)
- D7% (4)
Why each option
SQL Server Log Shipping maintains a near-current secondary copy of SharePoint content databases on a separate server, allowing site collection administrators to perform upgrade evaluations without impacting production users.
Database mirroring maintains a synchronized standby copy for failover purposes, but the mirror database is not directly accessible for read operations or isolated upgrade testing the way a log shipping secondary database is.
SQL Server Log Shipping continuously ships transaction log backups from the primary SharePoint content database to a secondary server, keeping a close-to-current copy available for read and test operations. Site collection administrators can run upgrade evaluations (demo upgrades) against this secondary copy, placing no additional read or write load on the production database and thus minimizing the impact on users still working in SharePoint 2010 compatibility mode.
AlwaysOn Availability Groups provide high availability and readable secondary replicas, but they are designed for failover and load distribution rather than creating an isolated copy of a content database specifically for upgrade evaluation.
SQL Server Snapshots create a point-in-time read-only copy on the same server instance as the primary database, which would increase I/O resource consumption on the production server and not minimize impact on users.
Concept tested: SQL Server Log Shipping for SharePoint upgrade evaluation
Source: https://learn.microsoft.com/en-us/sharepoint/upgrade-and-update/upgrade-content-databases-2013
Topics
Community Discussion
No community discussion yet for this question.