Analysis Services Interview Preparation Guide
Download PDF

Analysis Services frequently Asked Questions in various Analysis services related job Interviews by interviewer. Get preparation of Analysis Services job interview questions

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.

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.

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.

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

9 :: Oracle Database is connected through JDBC by using Java Programming (Why Oracle database was used?

Please share your views.