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

You have a ShafePoint Server 2013 server farm that has Excel Web Services deployed. A user has a Microsoft
Excel spreadsheet that uses a dynamic-link library (DLL) to perform custom calculations.The user plans to upload the spreadsheet to the farm.
You need to ensure that when the spreadsheet is rendered by Excel Web Services, the custom calculations are
performed.
What should you add?

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?

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?

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 company uses a data-connected Microsoft Excel workbook to build reports from external data sources.
Data is not refreshed when the workbook is displayed in a browser.
You need to ensure that users can refresh Excel workbooks that are displayed in a browser.
Which two actions should you perform? (Each correct answer presents a complete solution. Choose two.)

You are configuring a SharePoint environment to support SharePoint apps for Litware, Inc. The SharePoint
servers use a load-balancer for incoming requests. You need to ensure that all connections to the SharePoint
servers are secure and encrypted.
What should you do? (Each correct answer presents a part of the solution. Choose all that apply.)

An organization plans to install apps in its production SharePoint environment hosted at
sharepoint.contoso.com.
The services necessary to host and enable apps have not been configured.
You need to configure the environment to host SharePoint apps. 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.)
Select and Place:

You manage a Microsoft SharePoint 2013 farm for Contoso, Ltd. The farm contains four servers. Two of the
servers receive user requests, and two servers perform back-end processing.
You must forward all requests for www.contoso.com to 192.168.100.31.
You need to configure DNS.
How should you configure the DNS?

You have a SharePoint Server 2013 server farm.
You purchase an app for SharePoint from the Office Store.
You plan to deploy the app to the farm.
You need to recommend which changes must be made to the network infrastructure before you can deploy the
app.
What should you recommend?