Analysis Services Interview Preparation Guide
Enhance your Analysis Services interview preparation with our set of 22 carefully chosen questions. Each question is crafted to challenge your understanding and proficiency in Analysis Services. Suitable for all skill levels, these questions are essential for effective preparation. Get the free PDF download to access all 22 questions and excel in your Analysis Services interview. This comprehensive guide is essential for effective study and confidence building.22 Analysis Services Questions and Answers:
1 :: Tell Me which are the OLAP tools available that are supported by Oracle?
Supported by Oracle not owned well Cognos, Microstrategies, Business Objects and they have Hyperion Essbase 9 & 11, plus Oracle reports, Discover plus... their new version is packaged as a BI suite I forget the acronym they seem to change it daily :) Oh essbase supports MDX but doesn't generate MDX code like MS report services does
2 :: Explain discuss the problems of using semaphores in a distributed system?
Please share your answers.
3 :: Tell Me what is the difference between Business Requirement Document and Use case Document. What is the difference?
BRD Describes the business information of the client.once we are clear abt BRD of the client then only we can create more acurate solutions.this is the initial document that helps to create Business models in Cognos and ReportNet.Actually this information we are getting by KT(Knowledge Transfer) session.
Usecase Document helps to create test case document during unit testing ,actually use case document contains testcase id and i/p values that should use during testing , we are using this id only in Test case document instead of specifying all these i/p values and some other ,that id itself describing all that.so we can say use case is the foundation document for test case document.
Usecase Document helps to create test case document during unit testing ,actually use case document contains testcase id and i/p values that should use during testing , we are using this id only in Test case document instead of specifying all these i/p values and some other ,that id itself describing all that.so we can say use case is the foundation document for test case document.
4 :: What is difference in DSS and OLTP?
The DSS is (Decision Support System) used for the decision making purposes, not for day-2 day issues.by the top level/ sr/middle level managments people in a established company.
but the OLTP SYSTEMS handles the day-day transactions, data entries, billing etc issues .
The DSS WILL be handled by only a few users , especially
top poeple in the corporate ladder hence The number of users who are making use of DSS are less.
but in OLTP(ONLINE TRANSACTION PROCESSING) the number of the users are high, since no such kind of decision making is entailed.
but the OLTP SYSTEMS handles the day-day transactions, data entries, billing etc issues .
The DSS WILL be handled by only a few users , especially
top poeple in the corporate ladder hence The number of users who are making use of DSS are less.
but in OLTP(ONLINE TRANSACTION PROCESSING) the number of the users are high, since no such kind of decision making is entailed.
5 :: What is Re-engineering of an organization?
Reengineering is a fundamental rethinking and radical redesign of business processes to achieve dramatic improvements in cost, quality, speed, and service, this is the same process while Re-engineering an Organization.
6 :: How To determine that a Use Case is needed?
Please share your experience.
7 :: Explain what are the main important differences between olap and oltp?
olap:online analytical processing is that which describes procesing at warehouses.
oltp:online transactional processing is that which describes at the operational sites..
oltp olap
1.Mb-tb of data 1.gb-tb of data
2.mostly updates 2.mostly reads
3.many small transactions 3.summerized and consolidated data
4.raw data which is updated frequently 4.users are decision makers and analyts
5.consistency recoverability is critical
6.clerical users
oltp:online transactional processing is that which describes at the operational sites..
oltp olap
1.Mb-tb of data 1.gb-tb of data
2.mostly updates 2.mostly reads
3.many small transactions 3.summerized and consolidated data
4.raw data which is updated frequently 4.users are decision makers and analyts
5.consistency recoverability is critical
6.clerical users
8 :: Webservcies Architecture was used for Service Request(what exactly does this mean?
Please share your answers.
9 :: Oracle Database is connected through JDBC by using Java Programming (Why Oracle database was used?
Please share your views.
10 :: Explain what are the key things for BA from Requirement Definition?
Please share your experience.