HOTSPOT
You are developing a SQL Server Analysis Services (SSAS) cube that contains the data for
a running team.
The data warehouse used by the cube contains the time durations of taps run by each
runner on the team. The time durations are stored in seconds as an integer.
You need to build the following two measures in the cube:
A measure named Measure1 that must contain the average time duration of the laps run by
each runner.
A measure named Measure2 that must contain the lap-time duration and the name of the
runner who ran the fastest lap.
What should you do? To answer, select the appropriate Aggregation Function property for
each measure in the answer area.
You need to build the following two measures in the cube: A measure named Measure1 that must contain the average time duration of the laps run by each runner
HOTSPOT
You are developing a SQL Server Analysis Services (SSAS) cube that contains the data for
a running team.
The data warehouse used by the cube contains the time durations of taps run by each
runner on the team. The time durations are stored in seconds as an integer.
You need to build the following two measures in the cube:
A measure named Measure1 that must contain the average time duration of the laps run by
each runner.
A measure named Measure2 that must contain the lap-time duration and the name of the
runner who ran the fastest lap.
What should you do? To answer, select the appropriate Aggregation Function property for
each measure in the answer area.
Answer :
http://www.200-120exam.com/wp-content/uploads/2015/02/clip_image01116.jpg
Measure1: AverageOfChildren
Measure2: Min
avg/min