DRAG DROP
You manage a SharePoint farm.
The sales team would like to evaluate the Microsoft SQL Server 2012 Reporting Services (SSRS)
Power View feature.
You need to install Reporting Services for SharePoint to support Power View.
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.)

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