Example question 93 you are managing a sharepoint

* Example:

QUESTION: 93
You are managing a SharePoint farm. The SharePoint databases are configured to run
on a dedicated instance of Microsoft SQL Server 2008 R2 Service Pack 1. You need
to optimize query executions. What should you do?

A. Set the maximum degree of parallelism for SQL Server instances to 4.
B. Set the maximum degree of parallelism for SQL Server instances to 1.
C. Move the master database to a RAID 5 volume.
D. Set the maximum degree of parallelism for SQL Server instances to 32.
Answer: B
Explanation:
The read performance will double with a RAID 10 volume.
Incorrect:
not A, not D: The master database records all the system-level information for a SQL
Server system. This includes instance-wide metadata such as logon accounts,
endpoints, linked servers, and system configuration settings.
Not C: This is already the default settings.
* By default, the Max Degree Of Parallelism setting has a value of 0, which means
that the maximum number of processors used for parallel processing is controlled
automatically. Essentially, SQL Server uses the actual number of available
processors, depending on the workload. To limit the number of processors used for
parallel processing to a set amount (up to the maximum supported by SQL Server),
change the Max Degree Of Parallelism setting to a value greater than 1. A value of 1
tells SQL Server not to use parallel processing.
QUESTION: 94
You are managing a site collection in a SharePoint farm. You need to configure the
minimum level of permissions necessary for users to manage lists in the site
collection. What permission level should you configure?
A. View Only
B. Edit
C. Full Control
D. Read
Answer: C
QUESTION: 95
You are managing a SharePoint environment. All SharePoint databases reside on
servers that run Microsoft SQL Server 2012. You observe an increase in the
consumption of disk space by the SharePoint configuration database. You need to
minimize disk space usage. Which recovery model should you set?
A. Transactional

B. Full
C. Bulk-logged
D. Simple
Answer: D
QUESTION: 96
A SharePoint environment contains a single web application at .
You create a site collection under the web application. The site collection has the
URL
.
You need to ensure that the site collection is also accessible at
. What should you do?
A. Add intranet.contoso.com as an alternate access mapping for the web application.
B. Extend the web application and add intranet.contoso.com to the Intranet Zone.
C. Run the Set-SPSiteUrl Windows PowerShell cmdlet.
D. Run the New-SPSite Windows PowerShell cmdlet.
Answer: C
QUESTION: 97
HOTSPOT
You are managing multiple SharePoint sites. All users can access the home page on
the root SharePoint site. When users try to access a subsite, they receive an error
message stating that the site has not been shared with them. You need to allow users
to request access to the subsite. Which site setting should you configure? (To answer,
select the appropriate site setting in the answer area.)