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.)
You've reached the end of your free preview.
Want to read all 140 pages?
- Spring '16
- Windows Server 2003, SharePoint, Windows SharePoint Services