SQL Server 2008 R2 Analysis Services Assessment


SQL Server 2008 R2 Analysis Services Assessment

Skills Assessment

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.


What Am I Buying?
When you purchase an assessment with Talevation, you will receive a credit for our online assessment portal. To access your purchase, you must head to our Login page found in the top right corner. There, you may redeem your credit and generate a link which will be sent to the candidate of your choosing.

How does it work?
Total Questions 39
Question Types Multiple Choice
Competencies Tested Basic Concepts
Tasks Tested Horizontal and Vertical Partitions
Processing Options
KPI State
Process Data Option
SSAS Object Population
Dropped Object Data
Multiple Data Sources
Analysis Services Objects in an Online Mode
Multidimensional Data Analyzed by Pivot Tables
Organize Data
Role Permission to Access Cube Data
Cube Browsing
Action Target Type
Action Type
Viewable Subset of a Cubes
Action Invocation Setting
Read Cell Permission
Dimension Hierarchy Types
Dimension Designer
Hierarchy Sorting
Grouping Attributes
HideMemberIf Regular Property
Attribute Column Bindings
Ragged and Parent-Child Hierarchies
Defining an All Level
Semi-Additive Measure Dimensions
Dimension Relationships
Semi-Additive Measures
Measure Groups
Query and Slicer Axis
Calculated Members
MDX Actions
Required Calculated Members for an MDX Query
Named Set Return