You need to choose the correct SSAS design strategy

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.)

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).



Leave a Reply 4

Your email address will not be published. Required fields are marked *


SZ

SZ

“Advanced calculations using logic deployed in a custom assembly”
Last box should be Microsoft Visual C#, shouldn’t be?

Manu

Manu

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”.