A three-tiered SharePoint farm contains two front-end web servers, one application server, and one enterprise database server. The database server is also used by other critical line-of-business applications. You do not have administrative rights on the database server. The SharePoint content databases are fragmented and are degrading the performance of other databases. You need to access the correct tools for performing maintenance on the SharePoint content databases. Which option should you choose? (To answer, select the appropriate option in the answer area.)
A company has a SharePoint environment that consists of two web applications. The first web application is used as the corporate intranet site, and the second web application hosts several custom apps. The custom apps use Microsoft Business Connectivity Services (BCS) Web Parts to retrieve data from external systems. The home page of the second web application displays information from three custom apps and renders slowly. You need to identify the custom app that is causing the slow response times. Which tool should you use?
A. SharePoint Web Analytics service application
B. SharePoint audit log reports
C. SharePoint Health Analyzer
D. Developer Dashboard
Correct Answer: A
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. Move the SharePoint databases to a RAID 10 volume.
B. Move the SharePoint databases to a RAID 5 volume.
C. Set the maximum degree of parallelism for SQL Server instances to 4.
D. Set the maximum degree of parallelism for SQL Server instances to 0.
Correct Answer: D
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. Full Control
Correct Answer: C
You are managing a SharePoint farm. You need to log Microsoft SQL Server 2012 events that occur in the farm. In Centra1 Administration, which monitoring setting should you configure? (To answer, select the appropriate setting in the answer area.)
You are the administrator of a SharePoint farm that is using a Distributed Cache service cluster. You add memory to a server named CACHE1 in the Distributed Cache service cluster. You need to increase the memory allocation of the Distributed Cache service on CACHE1 and avoid loss of cached data on the server. Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)
Select and Place:
You are managing a SharePoint farm. You need to collect information about the health of a web application. What should you use?
A. SharePoint Health Analyzer
B. Windows Management Instrumentation (WMI)
C. SharePoint Developer Dashboard
D. timer jobs
Correct Answer: D
A company has a SharePoint site located at http://contoso.com. You are creating a managed path named training. You need to ensure that several site collections can be created under the managed path. On the Define Managed Paths page, how should you configure the managed path? (To answer, select the appropriate settings from the drop-down lists in the answer area.
HOTSPOT A company has a SharePoint farm. The environment contains a server-based virus scanner. You need to configure the SharePoint farm to clean infected documents when users save changes to documents on the server. How should you configure the antivirus settings? (To answer, select the appropriate check boxes in the answer area.)
You are the term store manager of a SharePoint environment. You need to make term sets available across the entire farm. You must ensure that users can reuse terms but not edit terms. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
A. Prohibit the use of keywords other than those in a specific term set.
B. Create a global term set.
C. Enable term pinning.
D. Prohibit grid editing in the Datasheet view.
E. Create a local term set.
Correct Answer: AB