SSAS interview questions


Top 20 SSAS Interview Questions and Answers For Freshers, Experienced


SQL Server Analysis Services (SSAS) is the innovation from the Microsoft Business Intelligence stack, to create Online Analytical Processing (OLAP) arrangements. In basic terms, you can use SSAS to make blocks utilizing information from data stores/information distribution centers for more profound and faster information analytics.

The specialists with the learning relating to Agile testing are in an immense demand these days. In case you are someone who is most likely going to go for an interview in which you would be asked questions based on SSAS then please experience the list of questions which have been written in this blog. These are the most generally asked questions that have been doing the rounds in various meeting sessions on SSAS. We are cheerful that these questions would help you in an astoundingly significant way.

SSAS Interview Questions and Answers for Freshers

For any person who is foreseeing to go to n interview session subject to SSAS at any point in the near future, here are the most well-known questions and their responses to help you in the correct way for your imminent interview session. In the wake of taking insights from various understudies who have appeared in SSAS interviews as of late, we have organized a once-over of the most normally asked questions by the hiring managers along with their answers to invigorate the fresher and the accomplished individuals for their interview sessions.

Q1). Define the SQL Server Analysis Services (SSAS)?

SQL Server Analysis Services (SSAS) is the On-Line Analytical Processing (OLAP) Component of SQL Server. SSAS enables you to manufacture multidimensional structures called Cubes to pre-compute and store complex conglomerations, and furthermore to construct mining models to perform information examination to recognize profitable data like patterns, designs, connections and so forth inside the information utilizing Data Mining capacities of SSAS, which generally could be extremely hard to decide without Data Mining abilities.

Q2). What do you understand by OLAP?

OLAP is the abbreviation for On-Line Analytical Processing. It is a capacity or an arrangement of devices which empowers the end clients to effortlessly and successfully get to the information distribution center’s data utilizing an extensive variety of instruments like Microsoft Excel, Reporting Services, and numerous other outsider business intelligence apparatuses.

Q3). How is OLAP different from OLTP?

OLAP is utilized for investigation purposes to help everyday business choices and is described by less continuous information refreshes and contains verifiable information. Though, OLTP (On-Line Transactional Processing) is utilized to help everyday business tasks and is described by continuous information updates and contains the latest information alongside restricted authentic information, dependent on the maintenance approach driven by business needs.

Q4). What is a Data Source?

A Data Source contains the association data utilized by SSAS to interface with the hidden database to stack the information into SSAS during the preparing. A Data Source basically contains the accompanying data (aside from different properties like Query timeout, Isolation and so on.

Q5). What are the different data sources supported by SSAS?

SSAS Supports both.Net and OLE DB Providers. Following are a portion of the significant sources bolstered by SSAS: SQL Server, MS Access, Oracle, Teradata, IBM DB2, and other social databases with the fitting OLE DB supplier.

Q6). What do you understand by Impersonation?

Impersonation is the process that enables SSAS to expect the personality/security setting of the customer application which is utilized by SSAS to play out the server side information tasks like information access, preparing and so forth.

Q7). What is a Data Source View?

A Data Source View (DSV) is a consistent perspective of the hidden database pattern and offers a layer of deliberation for the fundamental database mapping. This layer goes about as a hotspot for SSAS and catches the blueprint related data from the basic database.

Q8). What does the schematic information present in DSV include?

The schematic information present in DSV includes the following points:

Q9). What is a Named Calculation in SSAS?

A Named Calculation is another segment added to a Table in DSV and depends on an articulation. This capacity enables you to include an additional section into your DSV which depends on at least one segments from hidden information source Table(s)/View(s) joined together utilizing an articulation without requiring the option of a physical segment in the fundamental database Table(s)/View(s

Q10). What is the objective of setting Logical Keys and Relationships in DSV?

A significant number of the UIs/planners/wizards in BIDS which are a piece of an SSAS venture rely upon the Primary Key and Relationships among Fact and Dimension tables. Thus it is essential to characterize the Primary Key and Relationships in DSV.

SSAS Interview Questions and Answers for Experienced 

Q11). What is a data mart in SSAS?

A data mart is a subset of a hierarchical information store, generally arranged to a particular purpose or real information subject that might be disseminated to help business needs. Data marts are scientific information stores intended to center around particular business capacities for an explicit network inside an association. Information stores are regularly accessed from subsets of information in an information distribution center, however in the base up information stockroom plan strategy, the information stockroom is made from the association of hierarchical data marts.

Q12). What is the dimension table?

A dimension table contains various hierarchal information by which you’d like to condense. A dimension table contains explicit business data, a dimension table that contains the particular name of every individual from the dimension. The name of the dimension part is called a “property”. The key characteristic in the dimension must contain a novel incentive for every individual from the dimension. This key property is designated “essential key section”. The essential key section of each dimension table comparing to the one of the key segment in any related actuality table.

Q13). What is a fact table?

A fact table contains the essential data that you wish to outline. The table that stores the nitty gritty incentives for the measure is called the fact table.

Q14). What is Factless fact table?

The “Factless Fact Table” is a table which is like Fact Table with the exception of having any measure; implying that this table simply has the connections to the measurements. These tables empower you to follow occasions; undoubtedly they are for account occasions. Factless actuality tables are utilized for following a procedure or gathering details. They are called so on the grounds that, the reality table does not have aggregatable numeric qualities or data. They are unimportant key qualities with reference to the measurements from which the details can be gathered.

Q15). What is a Snowflake Schema?

The snowflake mapping is an expansion of the star pattern, where each purpose of the star detonates into more focuses. In a star pattern, each dimension is spoken to by a solitary dimensional table, while in a snowflake construction, that dimensional table is standardized into various query tables, each speaking to a dimension in the dimensional progressive system. In snowdrop mapping, actuality table will be connected straightforwardly and there will be some transitional dimension tables among certainty and dimension tables.

Q16). What is the use of the IsAggregatable property?

In Analysis Service we, for the most part, observe all dimension has All part. This is an immediate result of an IsAggregatable property of the trait. You can set its incentive to false, with the goal that it won’t demonstrate All part. Its default part for that characteristic. If you shroud this part then you should set other ascribe an incentive to default part else it will pick some an incentive as default and this will make perplexity in perusing the information in the event that somebody isn’t known to change in default part.

Q17). What is measure group, measure?

These measure groups can contain distinctive measurements and be at various granularity yet inasmuch as you show your 3D square effectively, your clients will have the capacity to utilize measures from every one of these measure bunches in their questions effortlessly and without agonizing over the fundamental multifaceted nature.

Q18). What is the surrogate key?

A surrogate key is the SQL created a key which acts like another essential key for the table in the database, Data distribution centers normally use a surrogate key to particularly perceive a component. A surrogate isn’t created by the customer yet by the framework. An essential contrast between an essential key and surrogate key in a few databases is that essential key particularly distinguishes a record while a Surrogate key exceptionally recognizes a component.

Q19). What are KPIs and what is its use?

In Analysis Services, a KPI is a gathering of estimations that are related to a measure amass in a 3D square that is utilized to assess business achievement. We utilize KPI to see the business at the specific point, to represent with some graphical things, for example, activity signals, ganze and so on

Q20). What is perspective, have you ever created perspective?

Perspective is an approach to diminish the intricacy of blocks by shrouded components like measure gatherings, measures, measurements, progressive systems and so forth. It’s only cutting off a shape, for example, we are having retail and clinic information and the end client is broughtbought in to see just doctor’s facility information, at that point we can make perspective as per it.