70-339 · Question #132
You are the administrator of your company's SharePoint environment. The company plans to use Excel Services. A file share is designated to contain all the files that are used by Excel Services. You…
The correct answer is B. Use the New-SPExcelDataConnectionLibrary Windows PowerShell cmdlet. To register a file share as a trusted data connection library for Excel Services, use the New-SPExcelDataConnectionLibrary PowerShell cmdlet to add the file share location.
Question
You are the administrator of your company's SharePoint environment. The company plans to use Excel Services. A file share is designated to contain all the files that are used by Excel Services. You need to configure Excel Services to use the file share. What should you do?
Options
- AAdd a user-defined function assembly on the Manage Excel Services Application page.
- BUse the New-SPExcelDataConnectionLibrary Windows PowerShell cmdlet.
- CAdd a trusted file location on the Manage Excel Services Application page.
- DUse the Set-SPExcelDataConnectionLibrary Windows PowerShell cmdlet.
How the community answered
(43 responses)- A2% (1)
- B88% (38)
- C2% (1)
- D7% (3)
Why each option
To register a file share as a trusted data connection library for Excel Services, use the New-SPExcelDataConnectionLibrary PowerShell cmdlet to add the file share location.
A user-defined function assembly entry extends Excel Services with custom .NET code, and has no role in registering a file share as a data connection source.
The New-SPExcelDataConnectionLibrary cmdlet creates a new trusted data connection library entry in Excel Services, registering the file share path so the service can locate and load ODC or BICHOST connection files stored there. This is the PowerShell approach to pointing Excel Services at a file share that hosts connection definitions used during workbook processing.
Adding a trusted file location specifies where Excel Services can open workbook files from, not where it retrieves data connection files stored on a separate file share.
Set-SPExcelDataConnectionLibrary modifies properties of an existing registered data connection library rather than creating a new entry for the designated file share.
Concept tested: Excel Services trusted data connection library PowerShell registration
Source: https://learn.microsoft.com/en-us/powershell/module/sharepoint-server/new-spexceldataconnectionlibrary
Topics
Community Discussion
No community discussion yet for this question.