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.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
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
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
2.Faster Analysis and Troubleshooting.
3.Ability to create and manage Data warehouses
4.Apply efficient Security Principles
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
- The difference between a derived measure and a calculated measure is when the calculation is performed.
- A derived measure is calculated before aggregations are created, and the values of the derived measure are stored in the cube.
- A calculated measure is calculated after aggregations are created, and the values of a calculated measure aren’t stored in the cube.
- The primary criterion for choosing between a derived measure and a calculated measure is not efficiency, but accuracy
A database is called a OLAP Database if the database satisfies the FASMI rules
- Fast Analysis– is defined in the OLAP scenario in five seconds or less.
- Shared – Must support access to data by many users in the factors of Sensitivity and Write Backs.
- Multidimensional – The data inside the OLAP Database must be multidimensional in structure.
- Information – The OLAP database Must support large volumes of data.
7.What is a partition?
- A partition in Analysis Services is the physical location of stored cube data.
- Every cube has at least one partition by default. Each time we create a measure group, another partition is created.
- 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.
- 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?
- SSAS uses both server and client components to supply OLAP and data mining functionality BI Applications.
- The server component is implemented as a Microsoft Windows service. Each instance of Analysis Services implemented as a separate instance of the Windows service.
- 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?
- Bill of Materials
- Currency
- Channel
- Customer
- Geography
- Organizations
- Products
- promotion
- Regular
- Scenario
- Time
- Unary
- Accounts
ReplyDeleteGreat Blog Thanks.
Here You Can Find Your First Round Intreview question For Job .
SSRS interview questions