SSAS Interview Questions

Ques. What is a cube?

Ans. The basic unit of storage and analysis in Analysis Services is the cube. A cube is a collection of data that’s been aggregated to allow queries to return data quickly.

Ques. What is Cube dimension?

Ans. A cube dimension is an instance of a database dimension within a cube is called as cube dimension. A database dimension can be used in multiple cubes, and multiple cube dimensions can be based on a single database dimension

Ques. What is dimension table?

Ans. A dimension table contains specific business information, and that table contains the specific name of each member of the dimension.

Ques. What is fact table?

Ans. The table that stores the detailed value for measure is called fact table.

Ques. What is the maximum size of a dimension?

Ans. The maximum size of the dimension is 4 gb.

Post Question