70-331 Premium Bundle

70-331 Premium Bundle

Core Solutions of Microsoft SharePoint Server 2013 Server Certification Exam

4.5 
(11640 ratings)
0 QuestionsPractice Tests
0 PDFPrint version
November 21, 2024Last update

Microsoft 70-331 Free Practice Questions

Q1. - (Topic 4) 

You need to prepare the web servers for a SharePoint installation in the new farm. 

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

A. Save the PrerequisiteInstaller.Arguments file in the same directory as the prerequisite installer. 

B. Define the installation arguments in a file named PrerequisiteInstaller.Arguments.txt 

C. Install Windows Server 2012 on SERVER02. 

D. Define the installation arguments in a file named PrerequisiteInstaller.Arguments.cfg. 

E. Save the PrerequisiteInstaller.Arguments file in the SharePoint installation directory. 

F. Install Windows Server 2012 on a virtual machine. 

Answer: A,B,F 

Explanation: A, B: Using a text editor, create a new text document named PrerequisiteInstaller.Arguments.txt. Save this file to the same location as PrerequisiteInstaller.exe. 

F: From Scenario: All servers must be virtualized unless otherwise specified 

Note: From scenario (but applies to the database server, not the web servers): The database servers must be physical machines running Windows Server 2012 with direct access to storage. 

Reference: Install prerequisites for SharePoint 2013 from a network share 

Q2. DRAG DROP - (Topic 3) 

You need to configure the environment for confidential documents. 

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:  

Q3. - (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. Set the maximum degree of parallelism for SQL Server instances to 0. 

B. Move the master database to a RAID 10 volume. 

C. Set the maximum degree of parallelism for SQL Server instances to 1. 

D. Set the maximum degree of parallelism for SQL Server instances to 32. 

Answer:

Explanation: 

Set max degree of parallelism (MAXDOP) to 1 for instances of SQL Server that host 

SharePoint databases to make sure that a single SQL Server process serves each request. 

Important: 

Setting the max degree of parallelism to any other number can cause a less optimal query 

plan to be used that will decrease SharePoint Server 2013 performance. 

Ref: http://technet.microsoft.com/en-us/library/hh292622(v=office.15).aspx 

Q4. - (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 

Q5. - (Topic 1) 

You need to import employee photos into SharePoint user profiles by using the least amount of administrative effort. 

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

A. Define a mapping for the thumbnailPhoto attribute of the Picture user profile property. 

B. Run the Update-SPUserSolution Windows PowerShell cmdlet. 

C. Run an incremental synchronization of the User Profile Synchronization service. 

D. Run a full synchronization of the User Profile Synchronization service. 

E. Run the Update-SPProfilePhotoStore Windows PowerShell cmdlet. 

F. Define a mapping for the photo attribute of the Picture user profile property. 

Answer: A,D,E 

Explanation: A: Step 3 below. 

D: Step 5 below. 

E: Step 6 below. 

Note: Importing Images into SharePoint User Profiles My Sites 

To make the user images that we have uploaded into the thumbnail Photo attribute in Active Directory available in SharePoint we will first need to map it to the Picture property in the User Profile Service Application. 

Firstly you will need to go into theUser Profile Service Application. 

1. Central Admin > Application Management > Service Applications > Manage Service Applications > User Profile Service Application 2.Then you will need to go into theManage User Propertiessection and edit thePicture property. 

3. Next we will map the Active Directory propertythumbnail Phototo thePictureproperty in SharePoint 

4.Once the mapping has been applied theManage User Propertiespage will look like this. 5.Now we will need to run aFull User Profile Synchronizationjob so that SharePoint can import theuser images from Active Directory Synchronization > Start Profile Synchronization > Start Full Synchronization 

6. Lastly we will need to force SharePoint to update the User Profile Database – This will 

create the thumbnails that are used in My Sites and the User Profile Service. 

This will need to be run in the SharePoint PowerShell Console with the appropriate My Site 

permissions. 

Reference: IMPORTING USER PROFILE PICTURES INTO ACTIVE DIRECTORY, EXCHANGE 2010 & SHAREPOINT 2010 – COMPLETE GUIDE 

Q6. DRAG DROP - (Topic 6) 

Contoso, Ltd. Recently merged with Fabrikam, Inc. Each company has an Active Directory Domain Services (AD RS) domain. You are managing the SharePoint environment in each domain. 

You need to enable users in the Fabrikam.com domain to access the Contoso SharePoint farm but prevent users in the Contoso.com domain from accessing resources in the Fabrikam SharePoint farm event if they have been explicitly granted access to a site. 

Answer:  

Q7. - (Topic 6) 

A company's SharePoint environment contains three web applications. The root site collections of the web applications host the company intranet site, My Sites, and a Document Center. 

SharePoint is configured to restrict the default file types, which prevents users from uploading Microsoft Outlook Personal Folder (.pst) files. 

The company plans to require employees to maintain copies of their .pst files in their My Site libraries. 

You need to ensure that employees can upload .pst files to My Site libraries. 

In which location should you remove .pst files from the blocked file types? 

A. The File Types area of the Search service application section of Central Administration 

B. The General Security page in the site settings for the site collection 

C. The Blocked File Types page in the site settings for the site collection 

D. The General Security section of the Security page of Central Administration 

Answer:

Q8. DRAG DROP - (Topic 6) 

A company plans to make Office Web Apps available for all users. The company deploys a multi-server, load-balanced Office Web Apps server farm. 

You install and configure SSL certificates. 

The SharePoint farm operates in both internal and external zones. 

You have the following requirements: 

. Servers must connect to both zones. 

. The Office Web apps farm must communicate securely with SharePoint Servers. 

You need to configure the environment. 

How should you complete the relevant Windows PowerShell commands? To answer, drag the appropriate Windows PowerShell segments to the correct location. Each Windows PowerShell segment 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. - (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:

Q10. - (Topic 6) 

You are the farm administrator for a single-server SharePoint 2010 Foundation environment. 

The company plans to upgrade to SharePoint 2013 Foundation. 

You need to ensure that the existing server meets the minimum requirements. 

Which three requirements must you meet? (Each correct answer presents part of the solution. Choose three.) 

A. 64-bit edition of Windows Server 2008 SP2 

B. 64-bit processor 

C. 8 GB of RAM 

D. 80 GB of free disk space for the system drive 

E. 64-bit edition of SQL Server 2008 

Answer: B,C,D 

Explanation: Installation Scenario Single server with a built-in database or single server that uses SQL Server Development or evaluation installation of SharePoint Server 2013 or SharePoint Foundation 2013 with the minimum recommended services for development environments. Requirement: 

B: 64-bit, 4 cores Processor 

C: 8 GB RAM 

D: 80 GB for system drive 

Incorrect: 

Not A: Minimum requirements for a single server with built-in database: 

The 64-bit edition of Windows Server 2008 R2 Service Pack 1 (SP1) Standard, Enterprise, 

or Datacenter or the 64-bit edition of Windows Server 2012 Standard or Datacenter 

Note: no need of a SQL server (can use the builtinSharepoint database server) 

Reference: Hardware and software requirements for SharePoint 2013 

Q11. DRAG DROP - (Topic 6) 

A company has a SharePoint environment that contains one front-end web server and one database server. 

The company would like to ensure that employees can send email messages to document libraries. 

You need to configure the environment to receive email messages. 

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:  

Q12. HOTSPOT - (Topic 6) 

You are managing a SharePoint farm. All users in the farm have access to a document library app. 

You need to begin the process of enabling managed terms for the app. 

Which option should you select? (To answer, select the appropriate option in the answer area.) 

Answer:  

Q13. - (Topic 5) 

You need to meet the requirements for the projects.contoso.com site. 

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

A. Add the Site Mailbox app to the site. 

B. Create a distribution list, and add the project team members to the distribution list. 

C. Add all the project team members to the Members group of the site. 

D. Create an AD security group, and add all the project team members to the security group. 

E. Email-enable a document library app on the site. 

Answer: A,C 

Explanation: 

* From scenario: Users of the Partner Projects site collection must be able to share content from their Microsoft Outlook clients and receive content from external users who send email directly to the site 

A Site Mailbox is a shared inbox in Exchange Online that all the members of a SharePoint Online site can access..It is implemented in SharePoint Online Preview as what is known as an.app. An app is best described as.a solution that carries a light footprint and uses standards-based technologies such as HTML5, JavaScript, and OAuth. The Site Mailbox is.accessible from the site in which it is created..It allow access to users who are individually listed in the Owners and Members groups of the site - security groups or distribution lists are not supported by Site Mailboxes. The email address of the site mailbox will be generated automatically from the name of the site. Site mailboxes are surfaced in Outlook 2013 and give you easy access to the emails and documents for the projects you care about..Site Mailboxes are.listed in the Folder Explorer in Outlook 2013 (the rich client), letting you file.emails or documents into the shared project space.simply by.dragging the email, document, or attachment into the site mailbox. 

Ref: http://blogs.technet.com/b/lystavlen/archive/2012/08/18/new-feature-site-mailboxes-in-sharepoint-online.aspx 

Q14. DRAG DROP - (Topic 4) 

You need to configure the SharePoint environment for App1. 

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:  

Q15. - (Topic 6) 

A SharePoint environment contains a single web application at http://app1. Users access a site collection under the web application by using the URL http://portal.contoso.com. 

You need to ensure that the site collection is also accessible at http://collaboration.contoso.com. 

What should you do? 

A. Run the New-SPSite Windows PowerShell cmdlet. 

B. Run the Set-SPSiteUrl Windows PowerShell cmdlet. 

C. Add collaboration.contoso.com as an alternate access mapping for the web application. 

D. Extend the web application and add collaboration.contoso.com to the Intranet Zone. 

Answer:

Explanation: The.Set-SPSiteUrl.cmdlet adds or changes an URL mapping for the site. The.Set-SPSiteUrl.cmdlet only applies to the root site collection for a host name that is, http://www.contoso.com. This cmdlet cannot be directly run against a managed path site collection underneath the root that is, http://www.contoso.com/sites/test. 

Q16. HOTSPOT - (Topic 2) 

You are configuring the IIS website settings for a SharePoint application in the Create New Web Application wizard. 

You need to ensure that the settings meet the technical requirements. 

Which configuration option should you change? (To answer, select the appropriate option in the answer area.) 

Answer:  

START 70-331 EXAM