In 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. Run the following Transact-SQL (T-SQL) statement for each content database and service application you plan to upgrade: ALTER DATABASE SET READ_ONLY. Run the following command-line tool for each site collection in the content databases you plan to upgrade. Stsadm -o setsitelock -urKsite collection name> -lock readonly Sign in to Central Administration in the SharePoint 2010 environment you plan to upgrade. Set each content database and service application database to Read-Only. What should you do?

B. Set the Instance Read-Only value to True.

Microsoft

70-332 · Question #83

70-332 Question #83: Real Exam Question with Answer & Explanation

Sign in or unlock 70-332 to reveal the answer and full explanation for question #83. The question stem and answer options stay visible for context.

Maintain a SharePoint environment

Question

In 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. Run 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. Run the following command-line tool for each site collection in the content databases you plan to upgrade. Stsadm -o setsitelock -urKsite collection name> -lock readonly Sign in to Central Administration in the SharePoint 2010 environment you plan to upgrade. Set each content database and service application database to Read-Only. 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.
BSet the Instance Read-Only value to True.
CRun 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.
DRun the following command-line tool for each site collection in the content databases you plan to upgrade. Stsadm -o setsitelock -urKsite collection name> -lock readonly

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.

Unlock 70-332 - $49.99 / 30 days Sign in

Topics

#database upgrade#SQL Server read-only#SharePoint upgrade#T-SQL

Full 70-332 Practice