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.)
A.
Configure the Secure Store service application for the Excel workbook.
B.
Embed the data connection information directly in the Excel workbook.
C.
Create a trusted data connection library and add a data connection file.
D.
Add the document library containing the Excel workbook to the Trusted File Locations list.
E.
Create a Group Policy Object that adds the SharePoint URL to the Trusted Sites zone in
Windows Internet Explorer.
Explanation:
To configure Excel Services data access to use embedded data connections,
you use the following process:
Configure a data access account
(A) Create a Secure Store target application
(B) Configure a workbook to use an embedded data connection
A: You must create a target application in Secure Store that contains the credentials that you
created for data access. This target application can then be specified in dataconnected
Excel workbooks and will be used by Excel Services when it refreshes data in the workbook.
B: Configure a workbook to use an embedded data connection You must configure the Excel
Services Authentication Settings in the workbook before you publish it to SharePoint Server
2013. Doing so enables the workbook to use a Secure Store target application to refresh
data that is rendered using Excel Services. Use the following procedure to configure the
authentication settings.
Note:
* Excel Services in SharePoint Server 2013 provides three methods of using Secure Store
Service to refresh the external data source in a workbook:/ You can use an unattended service account.
/ You can specify a Secure Store target application in a workbook. (This is known as an
embedded connection.)
/ You can use an Office Data Connection (ODC) file that specifies a Secure Store target
application. This article describes how to do this.
Reference: Configure Excel Services data refresh by using external data connections in
SharePoint Server 2013