DRAG DROP
You are designing a SQL Server Analysis Services (SSAS) data model on a very large data
warehouse.
The fact tables in the data warehouse contain terabytes of data in tens of billions of rows.
You must support the following features:
Complex attribute/column relationships
Advanced calculations in the data model definition
Advanced calculations using logic deployed in a custom assembly
You need to choose the correct SSAS design strategy.
What should you do?
To answer, drag the appropriate term or terms to the correct location or locations in the
answer area. (Answer choices may be used once, more than once, or not all.)
Explanation:
Note:
Box 1:
The primary reason for building an Analysis Services multidimensional model is to achieve
fast performance of ad hoc queries against business data. A multidimensional model is
composed of cubes and dimensions that can be annotated and extended to support complex
query constructions.
Box 2:
A partition is a container for a portion of the measure group data. Partitions are not seen
from MDX queries; all queries reflect the whole content of the measure group, regardless of
how many partitions are defined for the measure group. The data content of a partition is
defined by the query bindings of the partition, and by the slicing expression.
Box 3:
Multidimensional Expressions (MDX) is the query language that you use to work with and
retrieve multidimensional data in Microsoft SQL Server 2005 Analysis Services (SSAS).
Last box should be C#.
Question says: Advanced calculations using logic deployed in a custom assembly
Reference: https://msdn.microsoft.com/en-us/library/ms175398.aspx
Dude, in your link, it says you can use MDX Expressions to call functions from a custom assembly, so your answer is incorrect. See this:
https://msdn.microsoft.com/en-us/library/ms145486(v=sql.110).aspx
My vote goes for MDX for last box.
It sounds to me logic is there in assembly, all we need is to use MDX to use them.