You have a SharePoint Server 2010 server farm that contains a Web Application named WebApp1.
WebApp1 has a single content database. You need to prevent users from modifying the content in
WebApp1. Users must be able to view the content in WebApp1. What should you do?
A.
From Central Administration, change the database status.
B.
From Central Administration, modify the Web Application General Settings.
C.
From Microsoft SQL Server Management Studio, configure the database to be Road Only.
D.
From the SharePoint 2010 Management Shell, run the set-spwebApplication cmdlet.
Explanation:
Since users need to be restricted from modifying content in SharePoint, the database needs to be
set to readonly mode through SQL Server Management Studio. Setting the database to read-only is a
common practice in SharePoint Administration to prevent users from modifying content especially
during maintenance windows or during an upgrade.
Content database is Read-Only – Event 4971 (SharePoint 2010 Products)
http://technet.microsoft.com/en-us/library/ff182793.aspx
Attach databases and upgrade to SharePoint Server 2010
http://technet.microsoft.com/en-us/library/cc263299.aspx#readonly
Run a farm that uses read-only databases (SharePoint Foundation 2010)
http://technet.microsoft.com/en-us/library/ee517785.aspx