- World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions
Our Services
Get 9,000 Interview Questions & Answers in an eBook.

Get it now !!
Send your Resume to 6000 Companies
Analysis services Interview Questions & Answers - Learning Mode

Analysis services Interview Questions & Answers - Learning Mode

Build enterprise-scale solutions. Realize the power of a scalable infrastructure designed to secure superior performance and high developer productivity. Online analytical processing (OLAP) usually refers to specialized tools that make warehouse data easily available. An OLAP cube is a logical structure that defines the metadata. The term cube describes existing measure groups and dimension tables and should not be interpreted as having limited dimensions.

Try Analysis services Interview Questions & Answers - Exam Mode

1 2 Next

Sort By : Latest First | Oldest First | By Rating

Analysis services Interview Questions & Answers - Learning Mode
Try Analysis services Interview Questions & Answers - Exam Mode
Question: What is the difference between a Primary and Secondary Actor in Use Case Modeling?

Answer: Use Case modeling is used to diagrammatically depict a system and those people or processes that interact with it. This system can be a business system (a process) or an application system (computer or web based). To understand the scope of the system under consideration a system boundary is used. Anything depicted within the system boundary is part of the system under consideration, while anything outside of it is not. Use cases are then used to define a group of user-system interactions that t Source:
Question: What is SWOT Analysis?

Answer: SWOT Analysis is a strategic planning technique used to assess the internal and external environment in which a company operates and competes. Internal environmental factors are classified into strengths and weaknesses, while external environmental factors are classified into opportunities and threats. Source:
Question: Have you ever been in a real dilemma at work? What did you do to get out of it?

Answer: You should hear answers that show the job seeker has sound analytical skills to solve any problem analyzes problems in great detail to come up with a solution. Source:
Question: What is analytical or analytic mean?

Answer: If someone is analytical then it means the person is always thinking about things - analyzing, pondering, etc. A person who is analytical will have all of the facts about something before doing it.

Analytical is one of the 4 types of people. The other 3 are Promoters, Supporters and Controllers. Most everyone has a portion of every personality trait, but resembles 1-2 for the majority. Source:
Question: What is the 4 +1 View Model as it relates to system modeling?

Answer: The 4 + 1 View Model is a predefined set of views for organizing the design and architecture of a system. It was developed in 1995 by Philippe Kruchten, formerly the Director of Process Development at Rational Software.

The 4 + 1 View Model gets its name from the 4 primary views and 1 supporting view that are used to capture and communicate different aspects of the system.

The 4 primary views are:

► Logical View: this view describes the functionality of the system in t Source:
Question: Can you tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?

Answer: You should have the character to admit mistakes. Also clarify about your work. Were the steps he took correct? More importantly, has he/she learned from this mistake? Source:
Question: What task is 98% of the required work of a Business Analyst?

Answer: The Yourdon introductory class on data flow diagramming used to (still does?) teach that 98% of the required work in requirements specification revolved around a single task. What is that task? Source:
Question: Can you tell me about a time when you discovered a more efficient way to do a work task?

Answer: You should be able to identify a time where he/she was having difficulty with a work task, found a way to rectify the faults and work more efficiently. Source:
Question: What sort of existing documents should Business Analysts refer to when starting on a new project?

Answer: Few analysts are brought on to a project at the very beginning. For those that are, they will often have a hand in creating some of the important documents that other analysts should reference when they first join.

First, get your hands on the project charter. The project charter, while high level, will provide critical information on the project. Source:
Question: I am loaded with questions as I am an experienced ETL coder, but not an analytical report builder. I am using analysis services to build a cube but am trying to choose the reporting architecture. Can someone please confirm whether or not reporting services (using the business intelligence report) will allow for slicing and dicing, or is it only a static report builder. Also, if I am using the cube browser in analysis services, where can I put the option of NON EMPTY so that I don't see records that are blank.

Answer: Reporting services allows the slicing and dicing functionality. to see the non empty records, i think you have to create a calculated measure,to hide all the non empty rows. Source:
Question: What is a View as it relates to system modeling?

Answer: A view organizes diagrams into logical groups to describe a particular aspect of the system. It is the abstraction of the system organized is such a way as to give a perspective of a related set of concerns.

The purpose of using views as a business analyst is to enable the analyst to comprehend very complex systems, and to organize the problem or solution domain around specific areas of expertise. The audience interested in each view may vary based on their roles and experience. A subject Source:
Question: Tell me about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

Answer: You should be able to explain how they can compile facts and figures for preliminary analysis, derive relevant facts and information from the study of this data. Source:
Question: What is the difference between Business Requirement Document and Use case Document. What is the difference.

I need a good BRD and UC template.

Answer: 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 thi Source:
Question: Tell me about a tricky situation for which you found a very simple solution?

Answer: Your answer should show that they are a problem solver, that they can analyze all the information, and come up with a solution. Source:
Question: Tell me about a task that really tested your analytical abilities?

Answer: You should mention a time where he/she had to use reason and logic to resolve a problem. Job seeker may have analyzed all the relevant information and created a good, effective solution. Source:
Question: What is Cost Benefit Analysis (CBA)?

Answer: Cost Benefit Analysis is a technique used to determine if the financial benefit s of a project outweigh the associated cost of undertaking the project in the first place. For a short term project where the benefit may be an immediate one-time cash windfall this may be as simple as subtracting the total of all the project cost from the total of all of the project benefits. If the total is positive, then the project may be worth completing. Source:
Question: Which are the OLAP tools available that are supported by Oracle?

Answer: Oracle Warehouse Builder is ETL Tool its not OLAP Tool.

The OLAP Tool is Oracle Discoverer the version is 3i and 4i.

Question: what is uv spectro photometer working principles?

Answer: Absorption is directly proportional to the concentration of solute. Source:
Question: What is Data Warehouse

Answer: Data Warehouse

Data from different data sources is stored in a relational database for end use analysis

Data from different data sources is stored in a relational database for end use analysis Data is organized in summarized, aggregated, subject oriented, non volatile patterns.

Data is a data warehouse is consolidated, flexible collection of data Supports analysis of data but does not support online analysis of data.
Question: Is it the job of a business analyst or systems analyst to draw the class diagram?

Answer: It depends, it depends, and it depends!

As for most questions in business analysis, there isn?t only one answer. Whose job is to create a class diagram depends on the purpose of the class diagram.

First of all, the question implies that there is only one class diagram for a given project: ?The Class Diagram?. For the most part, this is not the case. On some projects there may be a multitude of class diagrams while in others there may be none. Source:

1 2 Next

India News Network
Latest 20 Questions
Payment of time- barred debt is: (a) Valid (b) Void (c) Illegal (d) Voidable
Consideration is defined in the Indian Contract Act,1872 in: (a) Section 2(f) (b) Section 2(e) (c) Section 2(g) (d) Section 2(d)
Which of the following is not an exception to the rule, "No consideration, No contract": (a) Natural love and affection (b) Compensation for involuntary services (c) Completed gift (d) Agency
Consideration must move at the desire of: (a) The promisor (b) The promisee (c) The promisor or any other party (d) Both the promisor and the promisee
An offer which is open for acceptance over a period of time is: (a) Cross Offer (b) Counter Offer (c) Standing Offer (d) Implied Offer
Specific offer can be communicated to__________ (a) All the parties of contract (b) General public in universe (c) Specific person (d) None of the above
_________ amounts to rejection of the original offer. (a) Cross offer (b) Special offer (c) Standing offer (d) Counter offer
A advertises to sell his old car by advertising in a newspaper. This offer is caleed: (a) General Offer (b) Special Offer (c) Continuing Offer (d) None of the above
In case a counter offer is made, the original offer stands: (a) Rejected (b) Accepted automatically (c) Accepted subject to certain modifications and variations (d) None of the above
In case of unenforceable contract having some technical defect, parties (a) Can sue upon it (b) Cannot sue upon it (c) Should consider it to be illegal (d) None of the above
If entire specified goods is perished before entering into contract of sale, the contract is (a) Valid (b) Void (c) Voidable (d) Cancelled
______________ contracts are also caled contracts with executed consideration. (a) Unilateral (b) Completed (c) Bilateral (d) Executory
A offers B to supply books @ Rs 100 each but B accepts the same with condition of 10% discount. This is a case of (a) Counter Offer (b) Cross Offer (c) Specific Offer (d) General Offer
_____________ is a game of chance. (a) Conditional Contract (b) Contingent Contract (c) Wagering Contract (d) Quasi Contract
There is no binding contract in case of _______ as one's offer cannot be constructed as acceptance (a) Cross Offer (b) Standing Offer (c) Counter Offer (d) Special Offer
An offer is made with an intention to have negotiation from other party. This type of offer is: (a) Invitation to offer (b) Valid offer (c) Voidable (d) None of the above
When an offer is made to the world at large, it is ____________ offer. (a) Counter (b) Special (c) General (d) None of the above
Implied contract even if not in writing or express words is perfectly _______________ if all the conditions are satisfied:- (a) Void (b) Voidable (c) Valid (d) Illegal
A specific offer can be accepted by ___________. (a) Any person (b) Any friend to offeror (c) The person to whom it is made (d) Any friend of offeree
An agreement toput a fire on a person's car is a ______: (a) Legal (b) Voidable (c) Valid (d) Illegal
Cache = 0.203125 Seconds