SQL Server 2008 R2 Analysis Services Assessment

$16.00

SQL Server 2008 R2 Analysis Services Assessment

$16.00
description

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 Concepts
Cubes
Dimensions
Measures
MDX
Tasks Tested Horizontal and Vertical Partitions
KPI
Processing Options
KPI State
Process Data Option
Partitions
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
Perspectives
Translations
Viewable Subset of a Cubes
Action Invocation Setting
Read Cell Permission
Dimension Hierarchy Types
Dimensions
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