You need to configure Secure Store Service (SSS) for Microsoft Office Excel services…

DRAG DROP
You configure a SharePoint Server 2010 Service Pack 1 (SP1) farm. You need to configure Secure
Store Service (SSS) for Microsoft Office Excel services with an unattended account. What should you
do? (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 configure a SharePoint Server 2010 Service Pack 1 (SP1) farm. You need to configure Secure
Store Service (SSS) for Microsoft Office Excel services with an unattended account. What should you
do? (To answer, move the appropriate actions from the list of actions to the answer area and
arrange them in the correct order.)

Answer:

Explanation:
http://technet.microsoft.com/en-us/library/hh525344.aspx
1. Configure a data access account
2. Configure a Secure Store target application for the unattended service account
3. Configure Excel Services Global Settings
4. Configure a workbook to use the unattended service account
Set-SPExcelUserDefinedFunction
Sets properties of a user-defined function in Excel Services Application.

Set-SPExcelServiceApplication
Sets global properties for Excel Services Application.
Set-SPExcelDataConnectionLibrary
Sets properties of a data connection library for Excel Services Application.



Leave a Reply 0

Your email address will not be published. Required fields are marked *