nerdexam
Microsoft

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.

Maintain a SharePoint environment

Question

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 perform demo upgrades of the sites. The solution must minimize the impact on the users. Which feature should you enable in Microsoft SQL Server?

Options

  • ADatabase mirroring
  • BLog shipping
  • CAlwaysOn Availability Groups
  • DSnapshot

How the community answered

(56 responses)
  • A
    13% (7)
  • B
    77% (43)
  • C
    4% (2)
  • D
    7% (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.

ADatabase mirroring

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.

BLog shippingCorrect

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.

CAlwaysOn Availability Groups

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.

DSnapshot

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

#site upgrade#log shipping#SQL Server#demo upgrade

Community Discussion

No community discussion yet for this question.

Full 70-332 Practice