70-332 · Question #54
You need to configure Excel Services. What should you do?
The correct answer is A. Add a trusted file location to the Tailspin360 site. Excel Services must be configured with trusted file locations to allow it to open and render workbooks from specific SharePoint sites.
Question
Exhibit
Options
- AAdd a trusted file location to the Tailspin360 site.
- BAdd each user as a Viewer.
- CAdd each user as a Contributor.
- DAdd a trusted data connection library to the Tailspin360 site.
How the community answered
(54 responses)- A89% (48)
- B4% (2)
- C2% (1)
- D6% (3)
Why each option
Excel Services must be configured with trusted file locations to allow it to open and render workbooks from specific SharePoint sites.
Excel Services uses trusted file locations to define which document libraries, network paths, or SharePoint sites it is permitted to open and render workbooks from. Without adding the Tailspin360 site as a trusted file location, Excel Services will block attempts to render any workbooks stored there. This is the foundational configuration step required to enable Excel Services access for a given site.
Adding users as Viewers is a SharePoint permission assignment, not an Excel Services service-level configuration.
Adding users as Contributors is a SharePoint permission assignment unrelated to configuring Excel Services to access a location.
Trusted data connection libraries allow Excel Services to use external data connections such as ODC files, not to enable rendering of workbooks from a site location.
Concept tested: Excel Services trusted file location configuration
Source: https://learn.microsoft.com/en-us/sharepoint/administration/manage-excel-services-trusted-file-locations
Topics
Community Discussion
No community discussion yet for this question.