SSAS Basics Quiz

SQL Server Analysis Services (SSAS) provides both OLAP functionality for multidimensional analysis and data mining capabilities for predictive analytics. The "Both 1 and 2" option correctly identifies that SSAS handles both analytical processing and data mining.

OLAP cubes derive their metadata from dimensional schemas, specifically both star and snowflake schemas which define dimensions, measures, and relationships. While databases store the data, the cube's structure comes from these schema patterns.

OLAP supports business intelligence applications including sales and marketing reporting, budgeting and planning, and forecasting through its multidimensional data analysis capabilities. All the listed options are valid use cases for OLAP technology.

In SQL Server Analysis Services (SSAS), the Cube is the fundamental unit of storage and analysis. It contains measures and dimensions that allow for multi-dimensional data exploration. Dimensions and Facts are components within a cube, but the cube itself is the primary container for the processed data.

A Perspective in SSAS creates a simplified view of a cube by exposing only selected dimensions and measures while hiding others, making it easier for different user groups to work with relevant cube elements. Attributes are properties of dimensions, Dimensions are structural elements, and neither serves to reduce complexity.