nerdexam
Microsoft

70-332 · Question #98

You have a SharePoint Server 2013 server farm that has Excel Web Services deployed. A user has a Microsoft Excel spreadsheet that uses a dynamic-link library (DLL) to perform custom calculations…

The correct answer is B. The DLL to the global assembly cache. Excel Services can only load custom DLL assemblies that reside in the Global Assembly Cache (GAC), which provides the required trust level for executing user-defined functions.

Configure and manage service applications

Question

You have a SharePoint Server 2013 server farm that has Excel Web Services deployed. A user has a Microsoft Excel spreadsheet that uses a dynamic-link library (DLL) to perform custom calculations. The user plans to upload the spreadsheet to the farm. You need to ensure that when the spreadsheet is rendered by Excel Web Services, the custom calculations are performed. What should you add?

Exhibit

70-332 question #98 exhibit

Options

  • AA new trust relationship
  • BThe DLL to the global assembly cache
  • CA trusted data provider
  • DA user-defined function assembly

How the community answered

(19 responses)
  • A
    16% (3)
  • B
    74% (14)
  • C
    5% (1)
  • D
    5% (1)

Why each option

Excel Services can only load custom DLL assemblies that reside in the Global Assembly Cache (GAC), which provides the required trust level for executing user-defined functions.

AA new trust relationship

A trust relationship in SharePoint governs inter-farm server authentication and has no bearing on whether Excel Services can load and execute a custom calculation DLL.

BThe DLL to the global assembly cacheCorrect

Excel Services in SharePoint 2013 enforces a security requirement that user-defined function (UDF) assemblies must be deployed to the Global Assembly Cache before they can be loaded and executed. The GAC grants the assembly full trust under the .NET Code Access Security model, which is required for Excel Services to invoke the custom calculation logic contained in the DLL when rendering the spreadsheet.

CA trusted data provider

A trusted data provider configures Excel Services to connect to external data sources such as SQL Server or OLE DB providers, but does not enable execution of custom code from a DLL.

DA user-defined function assembly

Registering a user-defined function assembly entry in Excel Services Central Administration settings is a necessary configuration step, but it cannot succeed without the DLL first being deployed to the GAC - making the GAC deployment the enabling prerequisite.

Concept tested: Excel Services UDF assembly deployment to Global Assembly Cache

Source: https://learn.microsoft.com/en-us/sharepoint/dev/general-development/how-to-deploy-udfs-using-sharepoint-foundation-solutions

Topics

#Excel Web Services#user-defined functions#global assembly cache#DLL deployment

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-332 Practice