This SQL Server 2008 R2 Analysis Services (SSAS) test is designed to assess the knowledge of test takers concerning Analysis Services in relation to SQL Server. The topics covered include basic concepts and terminology, data sources and views, cubes, dimensions, MDX, and measures. It is appropriate to administer this assessment to SSAS users who have a year or more of experience. Total Questions 39 Question Types Multiple Choice Competencies Tested Basic ConceptsCubesDimensionsMeasuresMDX Tasks Tested Horizontal and Vertical PartitionsKPIProcessing OptionsKPI StateProcess Data OptionPartitionsSSAS Object PopulationDropped Object DataMultiple Data SourcesAnalysis Services Objects in an Online ModeMultidimensional Data Analyzed by Pivot TablesOrganize DataRole Permission to Access Cube DataCube BrowsingAction Target TypeAction TypePerspectivesTranslationsViewable Subset of a CubesAction Invocation SettingRead Cell PermissionDimension Hierarchy TypesDimensionsDimension DesignerHierarchy SortingGrouping AttributesHideMemberIf Regular PropertyAttribute Column BindingsRagged and Parent-Child HierarchiesDefining an All LevelSemi-Additive Measure DimensionsDimension RelationshipsSemi-Additive MeasuresMeasure GroupsQuery and Slicer AxisCalculated MembersMDX ActionsRequired Calculated Members for an MDX QueryNamed Set Return
