DRAG DROP
You provision and configure a new SharePoint farm. The content databases are stored in Microsoft SQL
Server 2012.
You need to configure the databases for high availability.
Which four 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.)

HOTSPOT
An organization has an Active Directory Domain Services (AD DS) domain that includes a security group
named SPAdmins. Employees use SharePoint to connect to external business systems.
In Central Administration, you select Manage Service Applications.You need to configure the Secure Store service application to ensure that members of the SPAdmins
group can create new Secure Store target applications.
Which button should you click to begin the process? (To answer, select the appropriate button in the
answer area.)

Members of the Sales team store Microsoft Excel workbooks and other files on a SharePoint team site.
The workbooks do not access external data.
When Sales team members attempt to open workbooks from the team site, they receive an error
message stating that the workbook cannot be opened.
You need to configure the SharePoint farm to ensure that users can open Excel workbooks.
What should you do?

A company has an Active Directory Domain Services domain that contains a SharePoint farm.
The farm contains a site collection that displays data from an employee information database.
You define a domain user account named HRUsers and configure the account to have read-only
permissions to the database.
You have the following data access requirements for the employee information database:
 Members of the Human Resources department must be able to view data by
using SharePoint, without entering database credentials.
 No other SharePoint users should be able to view the employee data.
You need to meet the requirements.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose
two.)

DRAG DROP
You are deploying a SharePoint farm.
You need to prevent all users from purchasing or installing apps from the SharePoint store.
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.)

You are configuring a SharePoint environment to support workflows.
Workflows must meet the following requirements:
 Display a visual representation of the workflow.
 Display the workflow history.
 Provide access to external lists.
You need to implement the necessary shared services.
Which shared services should you implement? (Each correct answer presents part of the solution.
Choose two.)

A company has two SharePoint farms as described in the following table.

You need to process incoming server requests on HRFarm that originate from FinanceFarm.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

A Sales team creates proposals by using Microsoft Word. Sales team members store and review the
proposal documents in the Sales team site collection.
New proposals are uploaded to the team site for approval.
You need to ensure that approved proposals are automatically converted to PDF format and then routed
to a records center site collection.Which two features should you implement? (Each correct answer presents part of the solution. Choose
two.)

You are migrating a SharePoint Server 2010 My Site site collection to SharePoint Server 2013 by using
the database attach method. You copy the content databases to the SharePoint 2013 farm.
You need to verify that all required objects have been successfully added to the SharePoint 2013 farm
before upgrading the content database.
What should you do?

You are a SharePoint administrator at Litware, Inc.
Excel Services is not currently able to load workbooks on the SharePoint site. The Unified Logging
Service (ULS) log contains the following error message:
System.Data.SqICIient.SqIException: Cannot open database “WSS_Content_Portal_Content_Database”
requested by the login. The login failed. Login failed for user ‘LITWARE\\svcExcelService’.
You need to grant only the minimum necessary permissions to the Excel Services account to ensure that
users can open Excel workbooks from within a browser window.
Which Windows PowerShell cmdlet or cmdlets should you run?A. $sa = Get-SPServiceApplication | where {$_.TypeName -eq “Excel Services Application Web Service
Application”} and $sa.GrantContentDatabasePermissions(“WSS_Content_Portal_Content_Database”)