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.)
Answer: 
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).
I think the last box should be Microsoft C#.
It’s said that “Advanced calculations using logic deployed in a custom assembly”,
so you have to register the assembly and call the custom function from mdx.
0
0
I think Dim is correct, this question came in the exam and I went with MDX, however, after reviewing numerous whitepapers, I would go with C# as the question is quite explicitly saying to use advanced calculation using logic DEPLOYED in a CUSTOM ASSEMBLY
0
0
I don’t think so, you use MDX for advanced calculations in the model.
0
0
Agree with Dim: last box should be Microsoft C#.
0
0
Why? You can use custom assemblies in MDX also (for example ASSP is a custom assembly that extends capabilities of MDX).
Answer from the dump is correct. Last box is “Multidimensional Expressions”.
0
0
https://msdn.microsoft.com/en-us/library/ms175398(v=sql.120).aspx
0
0
the answer is correct
0
0
I think the answer is correct. We can handle assembly call from MDX expression. Also the assembly can be from COM or .NET object, where .net object can be from visual basic too, it is not necessarily have to be visual C#.
0
0