Microsoft
70-332 · Question #7
70-332 Question #7: Real Exam Question with Answer & Explanation
Sign in or unlock 70-332 to reveal the answer and full explanation for question #7. The question stem and answer options stay visible for context.
Maintain a SharePoint environment
Question
QUESTION 8
A SharePoint 2010 environment contains a Microsoft SQL Server 2008 R2 database instance named SP-SQL that hosts the databases for the farm. You are upgrading the farm to SharePoint 2013. You need to ensure that users can access the unmodified farm contents during the upgrade process. What should you do?
Options
- AIn SQL Server Management Studio, locate the SQL Server instance containing the content databases and service application databases you plan to upgrade. Set the Instance Read-Only value to True.
- BRun the following Transact-SQL (T-SQL) statement for each content database and service application you plan to upgrade. ALTER DATABASE <database name>SET READ_ONLY;
- CRun the following command-line tool for each site collection in the content databases you plan to upgrade. Stsadm -o datalock -url<site collection name> -lock readonly
- DSign in to Central Administration in the SharePoint 2010 environment you plan to upgrade. Set each content database and service application database to Read-Only.
Unlock 70-332 to see the answer
You've previewed enough free 70-332 questions. Unlock 70-332 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#database read-only#SharePoint 2013 upgrade#T-SQL#content database