70-331 Premium Bundle

70-331 Premium Bundle

Core Solutions of Microsoft SharePoint Server 2013 Server Certification Exam

4.5 
(16125 ratings)
0 QuestionsPractice Tests
0 PDFPrint version
November 23, 2024Last update

Microsoft 70-331 Free Practice Questions

Q1. - (Topic 6) 

A company has a SharePoint environment that contains two SharePoint servers and a server that runs Microsoft SQL Server. A web application stores content in a single content database. All three servers are configured to meet or exceed the minimum hardware and software requirements. The SharePoint environment is primarily used for team collaboration and document storage. 

All of the SharePoint Servers must be able to respond to user requests. Web traffic must be assigned to the server with the lowest health threshold value. 

You need to configure the SharePoint farm. 

Which service should you use? 

A. Request Management 

B. Microsoft Network Load Balancer (NLB) 

C. Microsoft SharePoint Foundation Subscription Settings 

D. Document Conversions Load Balancer 

E. Work Management 

Answer:

Explanation: Configure Request Manager in SharePoint Server 2013 Request Manager is functionality in SharePoint Server 2013 that enables administrators to manage incoming requests and determine how SharePoint Server 2013 routes these requests. 

The front-end web server filtering process follows these steps: 

. The routing pool is either the current front-end web server or one or more front-end 

web servers that request routing selects. 

. All matching rules are checked to find the smallest health threshold value. 

. Remove front-end web servers in the routing pool that have health scores greater 

than or equal to the smallest health threshold value. 

Reference: https://technet.microsoft.com/en-us/library/jj712708.aspx 

Q2. HOTSPOT - (Topic 6) 

You are a SharePoint farm administrator. 

When you attempt to navigate to the SharePoint home page, you receive an application error message that includes a correlation ID. The diagnostic logs do not contain the error corresponding to the correlation ID. 

You need to adjust the diagnostic logging level to capture all events. 

Which least critical event should you select? (To answer, select the appropriate event from the drop-down list.) 

Answer:  

Q3. HOTSPOT - (Topic 6) 

You have a SharePoint Server 2013 server farm. 

You need to implement a site mailbox for a site. 

Which link should you use from Site Contents? (To answer, select the appropriate link in 

the answer area.) 

Answer:  

Q4. - (Topic 4) 

You need to configure the antivirus application. 

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

A. Configure scanning to exclude the %Program Files%\Microsoft SQL Server \MSSQL10_50.SHAREPOINT\ folder. 

B. Configure scanning to include the %Program Files%\Microsoft Office Servers\15.0\ folder. 

C. Configure scanning to exclude the %Program Files%\Microsoft Office Servers\15.0\ folder. 

D. Configure scanning to exclude the %Program Files%\Microsoft Office Servers\14.0\ folder. 

E. Configure scanning to include the %Program Files%\Microsoft Office Servers\14.0\ folder. 

F. Configure scanning to exclude the %Program Files%\Common Files\Microsoft shared\Web Server Extensions folder. 

Answer: C,F 

Explanation: From Scenario: 

The antivirus application must not scan SharePoint directories. 

Folders that may have to be excluded from antivirus scanning in SharePoint 

SharePoint Foundation 2013 

You may have to configure your antivirus software to exclude the following folders and 

subfolders from antivirus scanning:.

. Drive:\Program Files\Common Files\Microsoft Shared\Web Server ExtensionsIf you do not want to exclude the whole Web Server Extensions folder from antivirus scanning, you SharePoint Server 2013 

You may have to configure the antivirus software to exclude the.Drive:\Program Files\Microsoft Office Servers folder from antivirus scanning for SharePoint Server 2013. If you do not want to exclude the whole Microsoft Office Servers folder from antivirus scanning, you can exclude only the following folders: 

Drive:\Program Files\Microsoft Office Servers\15.0\Data.(This folder is used for the indexing process. If the index files are configured to be located in a different folder, you also have to exclude that location.) Drive:\Program Files\Microsoft Office Servers\15.0\Logs Drive:\Program Files\Microsoft Office Servers\15.0\Bin Drive:\Program Files\Microsoft Office Servers\15.0\Synchronization Service Any location in which you decided to store the disk-based binary large object (BLOB) cache (for example, C:\Blobcache). 

Note.If you have SharePoint Server 2013, these folders should be excluded in addition to the folders that are listed in the "SharePoint Foundation 2013" section. 

Ref: http://support.microsoft.com/kb/952167 

Q5. DRAG DROP - (Topic 5) 

You need to provide access to the Corporate Projects site collection to remote internal users. 

Which authentication mode and site collection URL should you use? (To answer, drag the appropriate answer choices to the correct location or locations in the answer area. Each answer choice 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:  

Q6. - (Topic 1) 

You need to implement corporate sizing and performance guidelines for general usage scenarios. 

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

A. For the Remote BLOB Storage (RBS) storage subsystem on network attached storage (NAS), limit the maximum time-to-first-byte (TTFB) of any response from the NAS to 100 milliseconds. 

B. Limit the maximum size of each content database to 4 TB. 

C. For the Remote BLOB Storage (RBS) storage subsystem on network attached storage (NAS), limit the maximum time-to-first-byte (TTFB) of any response from the NAS to 20 milliseconds. 

D. Limit the number of documents in each document library to 20 million. 

E. Limit the number of documents in each content database to 10 million. 

F. Limit the maximum size of each content database to 200 GB. 

Answer: C,E,F 

Explanation: C: Network Attached Storage (NAS) is only supported by SharePoint 2013 with iSCSI and if TTFB is less than 20ms. 

E: The largest number of items per content database that has been tested on SharePoint 

Server 2013 is 60 million items, including documents and list items. If you plan to store 

more than 60 million items in SharePoint Server 2013, you must deploy multiple content 

databases. 

F: We strongly recommended limiting the size of content databases to 200 GB, except 

when the circumstances in the following rows in this table apply. 

If you are using Remote BLOB Storage (RBS), the total volume of remote BLOB storage 

and metadata in the content database must not exceed this limit. 

Note: The use of RBS-enabled content databases larger than 4TB with collaboration sites is not supported. 

Reference: Plan for RBS in SharePoint 2013 

Reference: Software boundaries and limits for SharePoint 2013 

Q7. - (Topic 2) 

You need to select the appropriate authentication method for App1. 

What should you do? 

A. Use classic mode authentication and set the authentication type to NTLM. 

B. Use classic mode authentication and set the authentication type to Kerberos. 

C. Use the SharePoint server-to-server security token service (STS). 

D. Use the Open Authorization 2.0 (OAuth 2.0) web authorization protocol. 

Answer:

Q8. DRAG DROP - (Topic 6) 

You are planning the search components for a SharePoint Server 2013 server farm. 

You have a content source named CS1 that contains all of the local SharePoint content. 

You upload a display template named DT1. 

You need to configure searches to meet the following requirements: 

. If a user types a search query that contains the word slidedeck, the search results must include only files that have either the .ppt file extension or the .pptx file extension. 

. The local SharePoint content must be indexed one document at a time. 

. DTI must be used to display results that have the .mp4 file extension. 

Which components should you use to achieve each requirement? (To answer, drag the appropriate components to the correct requirements. Each component 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:  

Q9. DRAG DROP - (Topic 4) 

You need to configure the SQL Server environment. 

Which three actions should you perform in sequence? (To answer, move the actions to the answer area and arrange them in the correct order.) 

Answer:  

Q10. - (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:

Q11. HOTSPOT - (Topic 6) 

You need to implement Community sites and eDiscovery centers in Office 365. 

In the table below, select the Office 365 plan that you should use for each type of site. 

NOTE: Make only one selection in each column. 

Answer:  

Q12. - (Topic 6) 

You administer a SharePoint Online tenant that has a site that contains a document library. Users from the Human Resource (HR) department have Contributor permissions to the site. 

You need to prevent users from the HR department from accessing documents in the library. 

Which permission option should you select? 

A. Stop Inheriting Permissions 

B. Grant Permissions 

C. Manage Parent 

D. Check Permissions 

E. Delete Unique Permissions 

Answer:

Explanation: Select Stop Inheriting Permissions on the document library for the HR department users. This will prevent them for accessing documents in this document library. 

Reference: Edit permissions for a list, library, or individual item 

https://support.office.com/en-us/article/Edit-permissions-for-a-list-library-or-individual-item-02d770f3-59eb-4910-a608-5f84cc297782 

Q13. - (Topic 6) 

A company deploys Enterprise Search for SharePoint Server 2013. The company's Marketing department site is hosted on a local SharePoint farm. The Marketing department launches an anniversary promotional campaign. 

After viewing search analytics reports for the campaign, you observe that search users are not being directed to the Marketing site. 

You need to direct users to the anniversary promotional campaign pages by moving the result to the top of the search results. 

What should you do? 

A. Configure properties of the Search Results Web Part NOT to search People, Conversations., or Video and default to Everything. 

B. Disable Query Rules that do not direct users to the site. 

C. Use a Query Rule to add a Promoted Result. Render the URL as a banner. 

D. Configure properties of the Search Result Web Part to use a Property filter to query content managed properties associated with Marketing. 

Answer:

Explanation: To promote individual results so that they appear towards the top of search results with a Query Rule, click Add Promoted Result . In the Add Promoted Result dialog box, in the Title field, type the name that you want to give this promoted result. In the URL field, type the URL of the result that should be promoted. Render the URL as a banner instead of as a hyperlink. Click Save. 

Reference: Manage query rules in SharePoint Server 2013 

https://technet.microsoft.com/en-us/library/jj871676.aspx 

Q14. - (Topic 6) 

A company has two SharePoint 2007 site collections that each store 200,000 unique documents. The average size of each document is 250 KB. There are two non-current versions for each document. 

There are approximately 600,000 list items in addition to the documents. 

The company plans to upgrade the farm to SharePoint 2013. 

The new farm will use two SQL Server instances that are configured as an AlwaysOn availability group. You use the following formula to estimate the size of the content database: 

Database Size = ((D x V) x S) + (10 KB x (L + (V x D))) 

You need to configure the storage for the content databases. 

What is the minimum amount of storage space that you must allocate? 

A. 101GB 

B. 110 GB 

C. 220 GB 

D. 405 GB 

E. 440 GB 

Answer:

Explanation: Using the formula we make the following calculation (see note below for 

details): 

((200000 x 2) x 250)+ (10 x 1024 x (600000 + (2 x 200000))) which calculates to 

103400000000 bytes, which is 103.4 GB. 

We would need 110 GB. 

Note: Formula to estimate content database storage 

1. Use the following formula to estimate the size of your content databases: Database size = ((D × V) × S) + (10 KB × (L + (V × D))) 

2. Calculate the expected number of documents. This value is known as D in the formula. 

3. Estimate the average size of the documents that you'll be storing. This value is known as S in the formula. 

4. Estimate the number of list items in the environment. This value is known as L in the formula. List items are more difficult to estimate than documents. We generally use an estimate of three times the number of documents (D), but this will vary based on how you expect to use your sites. 

5. Determine the approximate number of versions. Estimate the average number of versions any document in a library will have. This value will usually be much lower than the 

maximum allowed number of versions. This value is known as V in the formula. 

Reference: Storage and SQL Server capacity planning and configuration (SharePoint 

Server 2013) 

https://technet.microsoft.com/en-us/library/cc298801.aspx 

Q15. - (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:

Q16. DRAG DROP - (Topic 6) 

A SharePoint environment includes an enterprise search application. You are configuring the search application crawl schedule for a specific farm. 

You plan to configure the crawl schedule at set intervals of 15 minutes on a continuous basis. The relevant information for the farm is shown in the following graphic. 

You need to ensure that search results are fresh and up-to-date for all SharePoint sites in the environment. 

Which Windows PowerShell cmdlets should you run? (To answer, drag the appropriate cmdlets to the correct variable or variables in the answer area. Each cmdlet 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:  

START 70-331 EXAM