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?
A.
Database mirroring
B.
Log shipping
C.
AlwaysOn Availability Groups
D.
Snapshot
Explanation:
With log shipping, you back up the transaction logs from a primary database to a secondary
database on a separate instance of SQL Server.
Log shipping enables you to automatically send transaction log files for databases from a primary
database server instance to a secondary database server instance.Configure log shipping in SharePoint 2013
https://technet.microsoft.com/en-us/library/dd890507(v=office.12).aspx
I believe this answer is correct. 🙂
I would go for D: snapshot.
https://technet.microsoft.com/en-us/library/ff191199.aspx#Anchor_2
If you have an Enterprise version of SQL Server, the Create Upgrade Evaluation Site Collections job timer takes a snapshot of the database and reads the data from the snapshot to a destination database (with the source database being the default target). This doesn’t affect the read-only status of the source site throughout the whole process.
I won’t go for the snapshot, beacause the question ask for a feature, snapshot is not a feature to enable.