Microsoft SharePoint Certification 70-331 Real Questions Online

1. Topic 1, Large Company

Background

You are the SharePoint administrator for a large company. You are responsible for installing and configuring a multi-server SharePoint environment that will be used for information management and collaboration.

The company has an Active Directory Domain Services (AD DS) domain. User-specific contact information, including employee photos, is stored and managed in Active Directory. All employees are located in the ActiveUsers organizational unit (OU).

The User Profile Synchronization service runs on a server named SERVER1.

Business Requirements

The SharePoint environment must meet the following business requirements:

・ Ensure that users can connect to the portal by using the same URL from any location.

・ Ensure that users can access corporate information from outside the network without using a VPN connection.

・ Allow users to configure notifications for content changes.

・ Allow users to follow content creators.

・ Limit the number of sites and people each user can follow to 100.

・ Allow content authors to upload documents, large image files, and large video files for consumption by internal and external users.

・ Allow administrators to promote search query results across the entire company.

・ Utilize My Sites to share content.

・ Provide opportunities for social interaction.

Technical Requirements

You must meet the following technical requirements for the SharePoint environment:

・ Do not exceed the minimum hardware specifications.

・ Install the minimum supported versions of all software on the servers.

・ Control the growth of storage utilization.

・ Maximize existing content database usage before creating new content databases.

・ Store large files on network attached storage (NAS).

・ Ensure that all web applications, site collections, files, databases, and components stay within the supported limits.

・ Configure the User Profile Synchronization service to import user profile data from Active Directory.

・ Grant the User Profile service account the least permissions necessary to read data.

・ Ensure that current and future SharePoint environments include the most recent software updates.

・ Use predefined database naming conventions.

・ Create individual user sites by using the https://contoso.com/personal/path.

You create a User Profile Synchronization connection.

You need to grant the necessary permissions to the synchronization account.

What should you do?

2. HOTSPOT

You need to ensure that user-selected subscription content automatically appear on users' My Sites.

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

3. You need to ensure that content authors can publish the specified files.

What should you do?

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

5. DRAG DROP

You need to install the appropriate versions of Windows Server, Microsoft SQL Server, and Microsoft .NET Framework in the server environment.

Which operating system and applications should you install? (To answer, drag the appropriate operating systems and applications to the correct server layers in the answer area. Each operating system or application 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.)

6. You copy the content of the SharePoint installation media and software updates to your hard drive.

You need to meet the setup requirements for future SharePoint server installations.

What should you do?

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

8. HOTSPOT

You are setting up individual user sites.

You need to ensure that site addresses follow corporate guidelines.

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

9. You need to ensure that service applications meet the technical requirements by using the least amount of administrative effort.

What should you do?

10. HOTSPOT

You need to ensure that corporate search guidelines are followed.

What rule should you create? (To answer, select the appropriate option from each drop-down list in the answer area.)

11. Topic 2, Photo Processing

Background

General Background

You are a SharePoint administrator for an online photo-processing company named Contoso, Ltd. Contoso's primary customers are professional photographers.

The Contoso SharePoint 2013 environment includes the sites described in the following table.

The intranet site includes a document library for each employee in which the employee stores photos.

Technical Background

The SharePoint environment contains five front-end web servers that use Windows Network Load Balancing (NLB) with NLB affinity set to None. The company maintains all processed photos in the SharePoint content database. The content database uses RAID 5 storage. Photo files that are more than one year old are rarely viewed. Employees actively use the default self-service site creation feature.

The network infrastructure contains an Active Directory Domain Services (AD DS) environment. All servers run Windows Server 2008 R2. The internal AD DS domain is named contoso.com. Active Directory Federation Services (AD FS) is deployed in the LAN. Two AD FS proxy servers are deployed in the perimeter network. Users log on to client computers by using the syntax [email protected].

Contoso has a lab environment that includes a dedicated AD DS environment and SharePoint 2013. The main lab SharePoint site is located at lab.intranet.contoso.com. A test site for a project named Project2 exists under lab.intranet.contoso.com/corp. The default self-service site creation feature is enabled for the test site.

Contoso has a development team that maintains the public website, maintains the intranet site, and creates SharePoint apps. The development team recently created a SharePoint-hosted app named App1 that converts .tif files to .png files.

Future Development

・ Contoso is forming a new corporation named Proseware, Inc. that will sell SharePoint apps. The company has acquired the proseware.com domain name.

・ Contoso is preparing to federate with Microsoft Office 365 and will use the proseware.com domain for Office 365 services.

Technical Requirements

You must meet the following technical requirements:

・ App1 must have access to each employee's photo document library.

・ App1 must use Windows Authentication.

・ Each front-end web server must use a single IP address for all SharePoint sites and apps on that server.

・ All SharePoint sites and apps must listen on port 9000.

・ Office 365 must use single sign-on (SSO).

The company has established the following new monitoring requirements for the production SharePoint environment:

・ Monitor whether a large number of documents are checked out.

・ Monitor whether a large number of unpublished items are being requested.

The company has established the following new monitoring requirements for Project2:

・ Monitor changes to a value in a specific registry key.

・ Monitor the SharePoint cache hit ratios.

・ Perform monitoring only from 9:00

12. DRAG DROP

You need to design a SharePoint storage architecture to resolve the existing storage issues.

Which storage architecture should you use? (To answer, drag the appropriate storage types to the correct location or locations in the answer area. Each storage type 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.)

13. You need to create a new site collection while maintaining the ability for users to create their own sites.

What should you do?

14. You need to meet the Project2 monitoring requirements.

What should you do?

15. HOTSPOT

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

16. You need to configure a managed path to support Project2.

What should you do?

17. You need to implement Office 365 authentication.

What should you do?

18. You need to select the appropriate authentication method for App1.

What should you do?

19. You need to resolve the authentication issue that occurs in the SharePoint environment.

What should you do?

20. DRAG DROP

You are troubleshooting the problems with viewing scanned contracts.

You need to select the appropriate Performance Monitor counters to use.

Which performance counters should you use? (To answer, drag the appropriate counters to the correct location or locations in the answer area. Each counter 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.)

21. You need to implement Office 365 authentication.

What should you do?

22. You need to resolve the authentication issue that occurs in the SharePoint environment.

What should you do?

23. You need to implement Office 365 authentication.

What should you do?

24. You need to resolve the authentication issue that occurs in the SharePoint environment.

What should you do?

25. You need to resolve the authentication issue that occurs in the SharePoint environment.

What should you do?

26. Topic 3, Blue Yonder Airlines

Background

General Background

You are the SharePoint administrator for Blue Yonder Airlines. The company currently has a SharePoint 2010 environment. It is your responsibility to install and configure a SharePoint 2013 environment that will be used for information management and collaboration, both internally and with external partners. You must also migrate the existing SharePoint environment to SharePoint 2013.

Blue Yonder works with several external partners, including those described in the following table.

Blue Yonder collaborates with Wingtip Toys and Tailspin Toys to design, manufacture, and sell airline-related toys to customers. The Blue Yonder board of directors expects the collaborative design process to become more effective as a result of implementing SharePoint 2013.

Technical Background

All existing servers run Windows Server 2008 R2. The network infrastructure contains an Active Directory Domain Services (AD DS) environment. The internal AD DS domain is named blueyonderairlines.com. User-specific contact information is stored and managed in AD DS. All employees are located in the ActiveUsers organizational unit (OU). Active Directory Federation Services (AD FS) is deployed in the LAN. Two AD FS proxy servers are deployed in the perimeter network. Users log on to client computers by using the syntax [email protected].

Blue Yonder provides access to the SharePoint environment to partners through individual URLs for each partner company. Each partner company has a dedicated web application and site collection. The following table describes the access URLs.

In preparation for the upgrade you maximize the default upload limits for each web application.

Blue Yonder has an existing managed metadata service containing managed metadata and content types. The content types have workflows. You create a new managed metadata service connection for the Wingtip Toys web application.

A workflow created by Blue Yonder moves information through the product lifecycle. Each access URL specifies a separate web application, site collection, and site.

Business Requirements

The SharePoint environment must meet the following business requirements:

・ Provide an environment where toy design, manufacturing, and sales information can be shared between Blue Yonder and partner companies.

・ Provide a training site for internal and external users.

・ Allow content authors of training materials to upload documents, large image files, and large video files for consumption by internal and external users.

・ Allow users to sort content by category.

・ Ensure that users from Wingtip Toys or Tailspin Toys can access content only in their own areas of the portal.

・ Prevent users from Wingtip Toys and Tailspin Toys from adding terms or creating enterprise keywords.

・ Content types and keywords must be shared between sites, site collections, and web applications.

・ Simplify search processes by collecting unique characteristics and information about each uploaded item.

・ Allow administrators to promote search query results across the entire environment.

・ Allow resource coordinators from Blue Yonder to find temporary staffing options from Margie's Travel contractors and employees.

・ Provide opportunities for social interaction between employees, contractors, and external contacts to promote idea generation and socialization.

・ Utilize site feeds on all collaborative sites.

・ Replicate profile information in the https://blueyonderairlines.com site to partner sites.

・ Ensure that third-party vendors can read and modify documents.

・ For publishing sites, use only friendly URLs that do not contain anything other than the direct address. Avoid URL constructions such as /Lists/Posts/Post.aspx?ID = 568.

Site content must meet the following requirements:

Individual training videos must be in single files, and presented on the training site.

Changes to confidential documents must be logged.

Technical Requirements

You must meet the following technical requirements:

・ Store all large files outside of the SharePoint content database or databases.

・ All servers must run on virtual machines.

・ Ensure that search queries are handled by web servers.

・ Ensure that all lists support multiple content types.

You need to ensure that all required sites can use microblogging features for collaboration.

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

27. DRAG DROP

You need to ensure that profile information about contractors and employees is available in search results.

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

28. DRAG DROP

You need to configure Search to support resource coordinators.

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

29. You need to configure the existing managed metadata service application for term store management.

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

30. You need to specify hardware and software requirements for web servers used by the SharePoint environment.

Which two minimum requirements should you specify? (Each correct answer presents part of the solution Choose two.)

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

32. You need to configure policy settings for the user profile properties in the farm.

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

33. DRAG DROP

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

34. Workflows do not start in the https://wingtiptoys.blueyonder.com location.

You need to ensure that workflows start.

What should you do?

35. You need to configure navigation for publishing sites.

What should you do?

36. Topic 4, A.Datum

Background

General Background

You are a SharePoint administrator for A. Datum Corporation. A. Datum is a large legal firm with offices in Chicago, New York, and London. A. Datum is merging with a smaller legal firm named Fabrikam, Inc.

Technical Background

A. Datum has an Active Directory Domain Services (AD DS) domain named adatum.com. The domain contains an Active Directory Rights Management Services (AD RMS) server.

The A. Datum SharePoint environment includes the sites described in the following table.

The A. Datum SharePoint environment contains two servers that run all SharePoint services. The servers run Windows Server 2012 and are members of the domain. A third-party file-level antivirus application runs on all servers in the domain. The adatum.com farm uses Microsoft SQL Server 2012 for the SharePoint databases.

A. Datum is planning a three-tier SharePoint farm to replace the existing farm. A firewall will be placed between each tier. All servers must be virtualized unless otherwise specified.

The following servers are available for the new SharePoint environment:

All user accounts are stored in and maintained by using Active Directory. The My Site portal and document portal SharePoint sites receive user and group membership information by using Active Directory synchronization. New users often have to wait more than 24 hours before they can view their user profile information.

Fabrikam has an AD DS domain named fabrikam.com and a single-server SharePoint environment.

Web Applications

A new remote web application named App1 will be hosted in the adatum.com domain. App1 will require access to SharePoint resources in the fabrikam.com domain. SharePoint administrators in the fabrikam.com domain must be able to administer App1 by using Windows PowerShell.

Technical Requirements

You must meet the following technical requirements:

・ Fabrikam users must be able to directly access internal SharePoint resources in the adatum.com domain.

・ Datum users must not be able to access resources in the fabrikam.com domain.

・ All documents relating to the merger must contain a barcode, and must be protected from distribution.

・ Authenticated users must not be prompted for credentials when they access App1.

・ Users in the adatum.com domain must be able to access all SharePoint sites the same day they receive their Active Directory account credentials.

・ When a user account is deleted, the user's personal site collection must automatically be removed within 12 hours.

・ The antivirus application must not scan SharePoint directories.

When migrating the SharePoint environment, you must meet the following requirements:

・ The application and database servers must not be accessible from the Internet.

・ The database servers must accept connections only from the SharePoint servers.

・ The database servers must be physical machines running Windows Server 2012 with direct access to storage.

・ The database servers must be configured for redundancy.

・ All database transaction logs must be sent off-site.

・ All SharePoint installation prerequisites must be installed offline.

You need to configure SharePoint for the appropriate protection of merger documents.

What should you do?

37. You need to configure the antivirus application.

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

38. HOTSPOT

You need to ensure that new users have timely access to user profile information.

On the Service Applications page, which service application should you configure? (To answer, select the appropriate service application in the answer area.)

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

40. DRAG DROP

You need to configure cross-forest authentication.

How should you configure the authentication? (To answer, drag the appropriate trust element to the correct target in the answer area. Each trust element 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.)

41. You need to configure permissions for App1 administrators.

What should you do?

42. DRAG DROP

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

43. You need to ensure that the web servers can communicate with service applications after you replace the existing farm.

What should you do?

44. You need to configure SharePoint to remove user account-related data.

Which Windows PowerShell cmdlet should you run?

45. DRAG DROP

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

46. Topic 5, Contoso Ltd

Background

You are the SharePoint server administrator for Contoso, Ltd. Contoso has a SharePoint 2010 environment hosted on SharePoint Online and a separate on-premises SharePoint 2010 farm. You are preparing to upgrade the environments to newer versions of SharePoint. You are also planning to support a hybrid on-premises/cloud deployment that will be available to customers, partners, and third-party vendors.

Contoso collaborates with a partner company, Tailspin Toys, on multiple projects.

Technical Environment

All user groups reside in the existing Active Directory Domain Services (AD DS) domain corp.contoso.com.

The existing SharePoint Online environment is configured as follows:

・ The SharePoint Online URL assigned by Microsoft is http://contoso.sharepoint.com.

・ The SharePoint Online Administration Center URL is https://contoso.admin.sharepoint.com.

・ The user name for the Contoso Office 365 administrator is [email protected].

・ An existing line-of-business application provides an OData service that is hosted in Microsoft Windows Azure SQL Database.

The site collections are described in the following table.

Business Requirements

The upgraded SharePoint environments must meet the following business requirements:

・ All SharePoint 2013 features must be available to all users when connecting from inside or outside of the corporate network.

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

・ The Corporate Projects site collection must be available to internal users who connect from outside of the corporate network and must not require a VPN connection.

・ Third-party vendors must be able to read and modify documents.

Technical Requirements

You must meet the following technical requirements:

・ Before upgrading the Partner Projects site collection, create a duplicate, upgraded copy of the site for review and verification purposes.

・ Use Active Directory Federation Services (AD FS) 2.0 to authenticate Contoso employees, partners, and customers.

・ Automate the sign-in experience by using the local AD FS 2.0 servers for AD FS single sign-on (SSO).

・ Ensure that a web usage report that contains traffic reports, search reports, and inventory reports can be provided for any site.

The upgraded SharePoint environments must meet the following technical requirements:

・ All user profile information that resides in Active Directory must be available in SharePoint Online.

・ All sites must be able to share a mail-enabled document library that resides in the cloud.

・ The existing line-of-business application must be consumed as an external content type by using Microsoft Business Connectivity Services (BCS).

・ The Partner Projects site collection must allow Contoso and Tailspin Toys users to share documents with third-party vendors on an ad-hoc basis, without incurring additional licensing requirements.

You are configuring DNS for SharePoint Online.

You need to create the appropriate type of DNS record.

Which type of DNS record should you create?

47. You need to configure Office 365 to automate the sign-in experience.

What should you do?

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

49. DRAG DROP

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

50. DRAG DROP

You need to configure the environment to allow replication from the existing domain to Office 365.

Which components should you use? (To answer, drag the appropriate products or technologies to the correct location or locations in the answer area. Each product or technology 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.)

51. You are configuring an administration connection to SharePoint Online.

You need to instantiate the connection and authenticate to Office 365.

Which Windows PowerShell cmdlet should you run?

52. You need to display the required web usage report(s) for the projects.contoso.com site.

What should you do?

53. You are preparing to upgrade the Partner Projects site collection.

You need to perform the prerequisite task.

Which Windows PowerShell cmdlet should you run?

54. You plan to set up an external list to work with the existing line-of-business application in the cloud.

You need to upload a configuration file to SharePoint Online to enable communication with the external data.

Which configuration file should you upload?

55. DRAG DROP

You need to enable third-party vendors to access project documentation in the Partner Projects site collection.

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

56. Topic 6, Mix Questions

HOTSPOT

A SharePoint environment was set up by using an automated installation script. Corporate policies prevent the use of wizards for installing and configuring server environments.

You plan to provide navigation based on term sets.

You need to ensure that you can create the term sets.

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

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

You need to configure a service account to use domain credentials.

What should you do first?

58. HOTSPOT

You are managing web applications on a SharePoint site.

You need to begin configuring anonymous access for a SharePoint web application.

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

59. HOTSPOT

You create a SharePoint site for collaboration with external partners. The network team configures the reverse proxy server and publishes the SharePoint site.

Partners cannot sign in to the SharePoint site.

You need to ensure that partners can access the SharePoint site.

In Central Administration, on which page should you configure the settings? (To answer, select the appropriate page in the answer area.)

60. DRAG DROP

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

61. A company named Contoso, Ltd. has a SharePoint farm. The farm has one Search service application configured. The Search service application contains five crawl databases, all of which contain content. Contoso plans to crawl knowledge base content from its partner company Litware, Inc. The knowledge base content must be stored in a dedicated crawl database. You need to configure crawling.

What should you do?

62. HOTSPOT

The application log in the Windows Event Viewer shows object caching errors. You resolve the errors by modifying a web application in the farm.

After you resolve the errors, users are unable to access sites in the web application.

You need to restore user access to the sites.

On the Manage Web Applications page, which option should you configure? (To answer, select the appropriate option in the answer area.)

63. DRAG DROP

You are configuring permission levels for two user groups named Architects and Sales.

You have the following requirements for SharePoint site permissions:

・ Architects must be able to view website usage reports.

・ Sales must be able to edit documents online.

You need to configure the appropriate permission levels for each group.

Which permission levels should you assign? (To answer, drag the appropriate permission levels to the correct group or groups in the answer area. Each permission 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.)