70-466 Question #26: Real Exam Question with Answer & Explanation

The correct answer is A: Register the assembly on the SSAS server instance.. SSAS supports extending MDX with custom .NET assemblies (stored procedures). To make such an assembly available for use in MDX calculations, it must be registered with the SSAS instance - either at the server level (available to all databases) or at the database level. This regis

Build an analysis services database

Question

You develop a SQL Server Analysis Services (SSAS) stored procedure. You need to ensure that developers can create Multidimensional Expressions (MDX) calculations that use the stored procedure. What should you do?

Options

ARegister the assembly on the SSAS server instance.
BCopy the assembly to the SSAS installation directory and register it by using the CREATE ASSEMBLY T-SQL command.
CRegister the assembly on the SSAS server by using regedit.exe.
DRegister the assembly on the SharePoint server by using regedit.exe.

Explanation

SSAS supports extending MDX with custom .NET assemblies (stored procedures). To make such an assembly available for use in MDX calculations, it must be registered with the SSAS instance - either at the server level (available to all databases) or at the database level. This registration is performed through SQL Server Management Studio by navigating to the SSAS instance or database, right-clicking Assemblies, and adding the .NET or COM assembly. Option B is wrong because CREATE ASSEMBLY is a T-SQL command for the SQL Server relational engine (CLR integration), not for SSAS. Options C and D are wrong because regedit.exe manages the Windows registry, which has no role in making assemblies available to SSAS or MDX - and SharePoint is entirely unrelated to this scenario.

Topics

#SSAS assembly#stored procedures#MDX calculations#server registration

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice