DRAG DROP
A company has a SharePoint 2013 farm in an Active Directory Domain Services (AD DS)
domain. The company uses a third-party application to process payroll data and view payroll
reports. The third-party application uses SQL Authentication. Payroll administrators currently
use custom credentials to sign in to the payroll application.
You have the following requirements:
Payroll administrators must use Microsoft Excel and Excel Services to access payroll data
and view reports from within SharePoint.
Payroll administrators must not be required to enter credentials when accessing payroll data.
The Secure Store must be configured for high security and high process isolation.
You need to configure the Secure Store to meet the requirements.
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.)

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

You need to ensure that users can install apps from the App Catalog. Which permission or
permissions should you grant to the users?

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?

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

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

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

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