SSAS 2012 Interview Questions with Answers

In this tutorial we will discuss most frequently asked SSAS 2012 (SQL Server Analsysis Services ) Interview Questions with Answers

This interview questions and answers for SSAS 2008/2012 will be helpful in cracking the interview and may get you a good job

1.What is Analysis Services

1.Microsoft SQL Server 2012 Analysis Services (SSAS) delivers online analytical processing (OLAP) and data mining functionality for business intelligence applications. 
2.Analysis Services supports OLAP by letting we design, create, and manage multidimensional structures that contain data aggregated from other data sources, such as relational databases. 
3.For data mining applications, Analysis Services lets we design, create, and visualize data mining models that are constructed from other data sources by using a wide variety of industry-standar data mining algorithms
2.What are the features of Analysis Services
1.Ease of use with a lot of wizards and designers.
2.Flexible data model creation and management
3.Scalable architecture to handle OLAP
4.Provides integration of administration tools, data sources, security, caching,    and reporting etc.
5.Provides extensive support for custom applications
3.What is the need for SSAS 2012 component?
1.Analysis Services is the only component in SQL Server using which we can perform Analysis and Forecast operations
2.Faster Analysis and Troubleshooting.
3.Ability to create and manage Data warehouses
4.Apply efficient Security Principles
4. What languages are used in SSAS 2012
1.Structured Query Language (SQL)
2.Multidimensional Expressions (MDX) - an industry standard query language orientated towards analysis
3.Data Mining Extensions (DMX) - an industry standard query language oriented toward data mining.
4.Analysis Services Scripting Language (ASSL) - used to manage Analysis Services database objects

5.What is the difference between a derived measure and a calculated measure? 
  1. The difference between a derived measure and a calculated measure is when the calculation is performed. 
  2. A derived measure is calculated before aggregations are created, and the values of the derived measure are stored in the cube. 
  3. A calculated measure is calculated after aggregations are created, and the values of a calculated measure aren’t stored in the cube. 
  4. The primary criterion for choosing between a derived measure and a calculated measure is not efficiency, but accuracy
6. What is FASMI ?
A database is called a OLAP Database if the database satisfies the FASMI rules 
  1. Fast Analysis– is defined in the OLAP scenario in five seconds or less.
  2. Shared – Must support access  to data by many users in  the factors of Sensitivity and Write Backs.
  3. Multidimensional – The data inside the OLAP Database must be multidimensional in structure.  
  4. Information – The OLAP database Must support large volumes of data.
    7.What is a partition? 
  1.     A  partition in Analysis Services is the physical location of stored cube data. 
  2.    Every cube has at least one partition by default. Each time we create a measure group, another partition is created. 
  3.   Queries run faster against a partitioned cube because Analysis Services only needs to read data from the partitions that contain the answers to the queries. 
  4.    Queries run even faster when partition also stores aggregations, the pre calculated totals for additive measures. Partitions are a powerful and flexible means of managing cubes, especially large cubes
      8. What are the roles of an Analysis Services Information Worker?
      The role of an Analysis Services information worker is the traditional "domain expert" role in business intelligence (BI) someone who understands the data employed by a solution and is able to translate the data into business information.The role of an Analysis Services information worker often has one of the following job titles: Business Analyst (Report Consumer), Manager (Report Consumer), Technical Trainer, Help Desk/Operation, or Network Administrator

   9.Explain the TWO-Tier Architecture of SSAS?  
  1.   SSAS uses both server and client components to supply OLAP and data mining functionality BI Applications.
  2.   The server component is implemented as a Microsoft Windows service. Each instance of Analysis Services implemented as a separate instance of the Windows service.
  3.   Clients communicate with Analysis Services using the standard the XMLA (XML For Analysis) , protocol for issuing commands and receiving responses, exposed as a web service  
    10. How many types of dimension are possible in SSAS?
  1.    Bill of Materials
  2.    Currency
  3.    Channel
  4.    Customer
  5.    Geography
  6.    Organizations
  7.    Products
  8.    promotion
  9.    Regular
  10.    Scenario
  11.    Time
  12.     Unary
  13.    Accounts


  1. Great Blog Thanks.

    Here You Can Find Your First Round Intreview question For Job .

    SSRS interview questions