nerdexam
Microsoft

70-332 · Question #130

You are the administrator of your company's SharePoint environment. The company plans to use Excel Services. A file share is designed 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, the New-SPExcelDataConnectionLibrary PowerShell cmdlet is used to create the new entry.

Configure and manage service applications

Question

You are the administrator of your company's SharePoint environment. The company plans to use Excel Services. A file share is designed 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

(23 responses)
  • B
    91% (21)
  • C
    4% (1)
  • D
    4% (1)

Why each option

To register a file share as a trusted data connection library for Excel Services, the New-SPExcelDataConnectionLibrary PowerShell cmdlet is used to create the new entry.

AAdd a user-defined function assembly on the Manage Excel Services Application page.

Adding a user-defined function assembly registers a custom calculation DLL for use in workbooks, not a file share path for data connections.

BUse the New-SPExcelDataConnectionLibrary Windows PowerShell cmdlet.Correct

The New-SPExcelDataConnectionLibrary cmdlet creates a new trusted data connection library entry in Excel Services, allowing a UNC file share path to be registered so Excel Services can locate and access ODC/UDC data connection files stored there. This is the correct PowerShell approach for adding a file share as a trusted data connection source in Excel Services. Without this registration, Excel Services will not know to look at that file share for connection data.

CAdd a trusted file location on the Manage Excel Services Application page.

Adding a trusted file location configures where Excel workbooks themselves are trusted to load from, not where data connection files stored on a file share are registered.

DUse the Set-SPExcelDataConnectionLibrary Windows PowerShell cmdlet.

Set-SPExcelDataConnectionLibrary modifies properties of an already-existing data connection library entry rather than creating a new one for a new file share.

Concept tested: Registering Excel Services trusted data connection library via PowerShell

Source: https://learn.microsoft.com/en-us/powershell/module/sharepoint-server/new-spexceldataconnectionlibrary

Topics

#Excel Services#data connection library#file share#trusted file location

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-332 Practice