Interview Questions on SSAS

What is OLAP? How is it different from OLTP?

What is a Data Source? What are the different data sources supported by SSAS?

What is a Named Calculation? In what scenarios do you use it?

What is a Named Query? In what scenarios do you use it?

What is the purpose of setting Logical Keys and Relationships in DSV?

Is it possible to combine data from multiple data sources in SSAS? If yes, how do you accomplish it?

What is a SQL Server Analysis Services Dimension?

What are Natural Key and Surrogate Key in SQL Server Analysis Services?

What is a Hierarchy in SQL Server Analysis Services? What are the different types of Hierarchies? Explain each one of them.

What is a Slowly Changing Dimension in SQL Server Analysis Services? What are the different types of Slowly Changing Dimensions?

What is a Parent-Child Dimension in SQL Server Analysis Services? Explain with an example.

What is a Role-Playing Dimension in SQL Server Analysis Services? Explain with an example.

What is a Conformed Dimension in SQL Server Analysis Services? Explain with an example.

What is a Degenerate Dimension in SQL Server Analysis Services? In what scenarios do you use it?

refered from mssqltips.com