070-332 Free Dumps Study Materials
Question 1: DRAG DROP
You need to meet the content access requirements during the upgrade process.
What should you do? (To answer, drag the appropriate terms to the correct location or locations in
the answer area.
Each term may be used once, more than once, or not at all. You may need to drag the split bar
between panes or scroll to view content.)
Correct Answer:Box 1: SQL Server Management Studio
Box 2: State
Box 3: True
Box 4: Content
Note:
* From scenario:
/ All content databases within the production farm must be set to read-only when patching and
upgrading the farm.
* SQL Server Management Studio (ssms) is a software application first launched with the Microsoft
SQL Server 2005
that is used for configuring, managing, and administering all components within Microsoft SQL
Server.
* A farm is considered read-only if one of the following is true:
All content databases are set to read-only.
Service application databases are set to read-only.
* To set content databases to read-only by using SQL Server
Verify that the user account that is performing this procedure is a member of the db_owner fixed
database role in each database.
Start SQL Server Management Studio.
Right-click the content database that you want to make read-only, and then click Properties.
Select the Options page, and, in the Other options list, scroll to the State section.
In the Database Read-Only row, click the arrow next to False, select True, and then click OK.
Repeat for all other content databases.
Reference: Run a farm that uses read-only databases in SharePoint 2013