Developing SSAS solutions by using BIDS

Posted on
Like what you see? Share it.Share on Google+Share on LinkedInShare on FacebookShare on RedditTweet about this on TwitterEmail this to someone

Questions derived from the 70-445 – TS: Microsoft SQL Server 2005 Business Intelligence – Implementation and Maintenance Microsoft Self-Test Software Practice Test.

 

Objective: Developing SSAS solutions by using BIDS
SubObjective: Create and maintain measure groups and partitions

 

Item Number: 70-445.3.4.5
Single Answer, Multiple Choice

 

You are a database administrator for your company. You have created a measure group named FutureSales. You want to specify a default initial name for all the partitions created for the FutureSales measure group.

 

Which property should you modify to specify a default initial name for the partitions?

 

 

  1. Name property
  2. AggregationPrefix property
  3. FormatString property
  4. AggregationFunction property

 

Answer:
B. AggregationPrefix property

 

Tutorial:
You should change the value of the AggregationPrefix property to specify a default initial name for all the partitions created for the FutureSales measure group. The AggregationPrefix property is used to specify the default prefix value for new partitions created for a measure group. A measure group is a group of fact tables used to associate dimensions with measures. You can create a measure group by right-clicking on the Measures pane and then clicking on the New Measure Group option.

 

You should not change the Name property to specify a default initial name for all partitions created for the FutureSales measure group. The Name property is not a valid property of the measure group. The Name property is used to change the name of an object.

 

You should not change the FormatString property to specify a default initial name for all partitions created for the FutureSales measure group. The FormatString property is not a valid property for a measure group. The FormatString property is used for measures in a measure group, to specify the display format for the measure value.

 

You should not change the AggregationFunction property to specify a default initial name for the partitions created for the FutureSales measure group. The AggregationFunction property is not a valid property for the measure group. The AggregationFunction property of the measure in a measure group is used to specify the aggregation function for the measure value.

 

Reference:
Measures and Measure Groups
http://msdn2.microsoft.com/en-us/library/ms174792.aspx

 

Configuring Measure Group Properties
http://msdn2.microsoft.com/en-us/library/ms365411.aspx

Like what you see? Share it.Share on Google+Share on LinkedInShare on FacebookShare on RedditTweet about this on TwitterEmail this to someone
cmadmin

ABOUT THE AUTHOR

Posted in Archive|

Comment: