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.

Ques. What is AMO?

Ans. The full form of AMO is Analysis Management Objects. This is used to create or alter cubes from .NET code.

Ques. What are Aggregations and its use?

Ans. Aggregations provide performance improvements by allowing Microsoft SQL Server

Ques. What are KPIs and what is its use?

Ans. In Analysis Services, a KPI is a collection of calculations that are associated with a measure group in a cube that are used to evaluate business success. We use KPI to see the business at the particular point, this is represents with some graphical items such as traffic signals etc

Post Question