Friday, 30 January 2015

MSBI Part4 Interview Questions and Answers

16. What is UDM? Its significance in SSAS?
The role of a Unified Dimensional Model (UDM) is to provide a bridge between the user and the data sources. A UDM is constructed over one or more physical data sources, and then the end user issues queries against the UDM using one of a variety of client tools, such as Microsoft Excel. At a minimum, when the UDM is constructed merely as a thin layer over the data source, the advantages to the end user are a simpler, more readily understood model of the data, isolation from heterogeneous backend data sources, and improved performance for summary type queries. In some scenarios a simple UDM like this is constructed totally automatically. With greater investment in the construction of the UDM, additional benefits accrue from the richness of metadata that the model can provide.
The UDM provides the following benefits: 
• Allows the user model to be greatly enriched.
• Provides high performance queries supporting interactive analysis, even over huge data volumes.
• Allows business rules to be captured in the model to support richer analysis.

17. What is the need for SSAS component?
? Analysis Services is the only component in SQL Server using which we can perform Analysis and Forecast operations.
? SSAS is very easy to use and interactive.
? Faster Analysis and Troubleshooting.
? Ability to create and manage Data warehouses.
? Apply efficient Security Principles.

18. 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.

19. What are the components of SSAS?
? An OLAP Engine is used for enabling fast ad hoc queries by end users. A user can interactively explore data by drilling, slicing or pivoting.
? Drilling refers to the process of exploring details of the data.
? Slicing refers to the process of placing data in rows and columns.
? Pivoting refers to switching categories of data between rows and columns.
? In OLAP, we will be using what are called as Dimensional Databases.

20. What is FASMI ?
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.
More Questions & Answers :-
Part1  Part2  Part3  Part4  Part5  Part6  Part7  Part8

No comments:

Post a Comment