70-331 Exam - Core Solutions of Microsoft SharePoint Server 2013 Server

certleader.com

Q1. - (Topic 6) 

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. 

Answer:

Q2. DRAG DROP - (Topic 6) 

You are troubleshooting services in a SharePoint environment. 

The services have the following logging requirements: 

Business Connectivity Services must have only the minimum logging level. 

Word Automation Services must log all errors. 

The Search service logs must log all activity. 

You need to apply the appropriate trace log diagnostic level for each service. 

Which diagnostic level should you apply to each service? (To answer, drag the appropriate levels to the correct service or services in the answer area. Each level 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.) 

Answer:  

Q3. DRAG DROP - (Topic 6) 

A company has a single Active Directory Domain Services (AD DS) forest that contains two domains named tailspintoys.com and wingtiptoys.com. The company has a SharePoint environment in the tailspintoys.com domain. 

You need to ensure that SharePoint search services use SharePoint managed accounts. 

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.) 

Answer:  

Q4. - (Topic 6) 

A SharePoint farm includes two front-end web servers, one application server, and two clustered servers that run Microsoft SQL Server. The SharePoint Foundation Web Application service is not running on the application server. 

You plan to configure the SharePoint farm to receive and store email messages and email message attachments in libraries. 

You need to ensure that users can send email messages and attachments directly to libraries across the entire farm. You must accomplish this goal by using the least amount of effort. 

Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.) 

A. Install and configure the Simple Mail Transfer Protocol (SMTP) service on each application server. 

B. Install and configure the Simple Mail Transfer Protocol (SMTP) service on each front-end web server. 

C. Enable and start the SharePoint Foundation Web Application service on each application server. 

D. Enable incoming email by using the Automatic settings mode. 

E. Enable and start the SharePoint Foundation Web Application service on each front-end web server. 

F. Enable incoming email by using the Advanced settings mode. 

Answer: B,F 

Explanation: B (not A): 

* Incoming email for SharePoint 2013 uses the SMTP service. You can use the SMTP service in one of two ways. You can install the SMTP service on one or more servers in the farm, or administrators can provide an email drop folder for email that is forwarded from the service on another server. 

* If you are not using a drop folder for email, the SMTP service must be installed on every front-end web server in the farm that you want to configure for incoming email. 

F (not D): 

* The basic scenario applies to a single-server farm environment and is recommended if you want to use default settings. The advanced scenario applies to a single-server farm or a multiple-server farm and contains several advanced options from which to choose 

* To configure incoming email in an advanced scenario 

. Verify that the user account that is performing this procedure is a member of the Administrators group on the server that is running the SharePoint Central Administration website. 

. In Central Administration, clickSystem Settings. 

. On the System Settings page, in theE-Mail and Text Messages (SMS)section, clickConfigure incoming e-mail settings. 

. If you want to enable sites on this server to receive email, on the Configure Incoming E-mail Settings page, in theEnable Incoming E-Mailsection, clickYes. 

. Select theAdvancedsettings mode. etc. 

Not C, not E: The SharePoint Foundation Web Application service is not running on the application server. 

Reference: Configure incoming email for a SharePoint 2013 farm 

Q5. - (Topic 6) 

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 master database to a RAID 10 volume. 

B. Set the maximum degree of parallelism for SQL Server instances to 0. 

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 1. 

Answer:

Q6. - (Topic 3) 

Each training video file can be up to 10 GB in size. 

You need to ensure that content authors can upload training video files. 

Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.) 

A. Compress large video files so that they do not exceed 2 GB each. 

B. Set the size limit of the content database to unlimited. 

C. Divide large video files into multiple files that do not exceed 50 MB each. 

D. Utilize Remote BLOB Storage. 

Answer: A,D 

Explanation: A: 

* Will the maximum file size limit change in SharePoint Server 2013? No, the maximum file size that can be uploaded to SharePoint will remain at 2GB. 

* The maximum file size limit for storing file content through SharePoint is 2 GB regardless of whether or not you are using RBS. 

D: In SharePoint 2013, a binary large object (BLOB) is a file, such as a Office 2013 document or a video file. By default, these BLOBs, also named unstructured data, are stored online in the SharePoint content database together with the metadata, or structured data. Because BLOBs can be very large, it can be helpful to move BLOB data out of the SQL Server database, and onto commodity or content addressable storage. To do this, you can use RBS (Remote BLOB Storage). 

Note: 

* From Scenario (not C): Individual training videos must be in single files 

* RBS stands for Remote Blob Storage. The premise of RBS is that it is much faster to render large BLOBs( Binary Large Objects) from a file system rather than from a database (such as the SharePoint Content Database). Therefore, by moving this content out of the SharePoint Content Database, you not only shrink the overall size of your content database, you are able to also move that content on external file stores such as SAN, NAS or DAS. 

Reference: Plan for RBS in SharePoint 2013 

Q7. - (Topic 6) 

You are managing a SharePoint farm in an Active Directory Domain Services (AD DS) forest. 

The forest contains two domains named americas.contoso.com and europe.contoso.com. A single SharePoint farm is located in the americas.contoso.com domain and uses Kerberos authentication. 

Users in the europe.contoso.com domain cannot access the Excel Services application in the americas.contoso.com domain when using an external data source. 

You need to ensure that users in the europe.contoso.com domain can use the Excel Services application with external data sources. 

What should you do? 

A. Deploy a SharePoint farm in the europe.contoso.com domain. 

B. Configure Kerberos constrained delegation. 

C. Configure basic Kerberos delegation. 

D. Configure anonymous access in the SharePoint farm. 

Answer:

Q8. HOTSPOT - (Topic 6) 

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 open documents or save documents to their computers. 

How should you configure the antivirus settings? (To answer, select the appropriate check boxes in the answer area.) 

Answer:  

Q9. - (Topic 6) 

You have a SharePoint Server 2013 server farm. 

Active Directory attributes are imported to user profiles. 

You need to ensure that if users change the mobile phone number in their SharePoint user 

profile, the new information will be copied to their Active Directory user account. 

Which Active Directory permission should you assign to the synchronization account? 

A. Read All Properties 

B. Manage Replication Topology 

C. Write All Properties 

D. Replicate Directory Changes 

Answer:

Explanation: The synchronization account for a connection to Active Directory Domain 

Services (AD DS) must have the following permissions: 

It must have Replicate Directory Changes permission on the domain with which you'll 

synchronize. 

Note: The Replicate Directory Changes permission enables the synchronization account to read AD DS objects and to discover AD DS objects that have been changed in the domain. The Grant Replicate Directory Changes permission does not enable an account to create, modify or delete AD DS objects. 

Q10. - (Topic 6) 

Contoso, Ltd., has an on-premises SharePoint 2013 implementation. It plans to migrate the sales department to SharePoint Online. Additional departments will be migrated in the future. 

The sales department currently has a dedicated site collection for collaboration and document sharing. 

The sales department site collection uses the managed path https://sales.contoso.com. 

Contoso's SharePoint Online environment is accessible by using the URL https://contoso.sharepoint.com. 

Sales team employees must be able to connect to SharePoint Online by using a simple managed path. 

You need to configure SharePoint Online. 

Which managed path should you use? 

A. https://sales.contoso.com 

B. https://contoso-my.sharepoint.com 

C. https://contoso.sharepoint.com/sites/sales/ 

D. https://teams.contoso.com/sites/sales/ 

Answer:

Explanation: Define managed paths in SharePoint Server 2013 

An explicitly named path (for example, http://server/sites/team) is used for a single site collection. In this case the managed path would be https://contoso.sharepoint.com/sites/sales/ as SharePoint online uses https://contoso.sharepoint.com and we want to provide a managed path for the Sales department's site collection. 

Reference: https://technet.microsoft.com/library/cc261845(v=office.15).aspx