DRAG DROP
You are configuring an Excel Services service application in a Microsoft SharePoint farm.
Users will deploy Excel workbooks to SharePoint libraries that allow interaction with
PivotTables through Excel Services. PivotTable data is sourced from secured SQL Server
Analysis Services (SSAS) cubes and PowerPivot models inside published workbooks.
You need to ensure that users can refresh the PivotTables from within Excel Services
without a warning message appearing.
What should you do?
To answer, drag the appropriate term or terms to the correct location or locations in the
answer area. (Use only terms that apply.)

Answer: See the explanation.

Explanation:
Box 1:

Box 2:

Box 3: