Essential Data Warehouse BI Interview Preparation Guide
Download PDF

Data Warehouse BI frequently Asked Questions by expert members with experience in Data Business intelligence. These interview questions and answers on Data Warehouse BI will help you strengthen your technical skills, prepare for the interviews and quickly revise the concepts. So get preparation for the Data Warehouse BI job interview

18 Data Business intelligence Questions and Answers:

Table of Contents:

Essential  Data Business intelligence Job Interview Questions and Answers
Essential Data Business intelligence Job Interview Questions and Answers

1 :: Explain BPMN standard for business process modeling and analysis?

The BPMN specifies a graphical notation for expressing business processes in a Business Process Diagram. Both technical users and business users are supported for business processes using BPMN. BPMN provides a standardized, simple means of process information communication to other business users, customers, suppliers and process implementers.

2 :: Explain Oracle BPEL Process Manager?

Oracle BPEL Process Manager is a BPEL engine. It is a member of Oracle Fusion middleware family of products. Orchestration disparate applications and web services are enabled enterprises by Oracle BPEL Process Manager. Quick building and deploying this processing ability in a standards-based manner delivers critical functionality for developing SOA.

3 :: What is BPEL Orchestration and Choreography?


The control over the web services that are involved and coordinating the execution of different operations on the web services involved in the operation is taken by the central process in orchestration as per the requirements. The involved web services are unaware of this process. With operations that are explicitly defined and the order of invocation of the web services, the orchestration is centralized.


Choreography does not rely on a central coordinator. The web services involved in the choreography is aware exactly the execution of its operations and whom to interact with. Choreography is a collaborative effort. It focuses on messages exchange. The awareness of business process, operations to execute, messages to exchange, and the time of message exchange are needed for all participants of choreography.

4 :: Explain Role of BPEL?

BPEL is a language for relatively simple description of how web services are composed into business processes.

BPEL is the first of its kind. BPEL

Allows abstract and executable processes
Gained support by Majority of companies
Allows software to exist and similar processes can be executed and developed.

5 :: Explain BPEL vs. workflow foundation?

BPEL is process-centric, where as workflow foundation is human centric.
BPEL web services based language for business process behavior which can be used for composite web services, where as workflow foundation is a programming model for quickly building workflow enabled applications which are user interface-centric.

6 :: Explain Business Process Execution Language (BPEL)?

Business Process Execution Language is a language that is executable for interaction specification along with Web services. The processes of BPCL will export and import information by utilizing exclusively web service interfaces.

7 :: What is BOMain.Key?

BOMain.Key is a file that contains repository site information. The address of the repository security domain is available in this file. This file should be distributed to all users of BO who shares universes and documents. This file is stored in a folder by name ‘Business Objects/LOCData’.

8 :: What is Object qualification?

The kind of object is the qualification of object, for determining how to use in multidimensional analysis. For this determination, objects can be qualified as dimension, detailed and measure.

9 :: What is the security level used in BO?

BO security levels are provided at row and column levels. These security levels are handled by the administrator in either supervisor tool or designer tool. These security levels are to restrict the user or user group at row level or at column level.

10 :: Explain slicing and dicing in business objects?

Slicing - The cube is sliced based on its dimension
Dicing – The cube is rotated without the need of the dimension (independent of dimension.

Slicing and Dicing are used for analyzing data in different views and perspectives.

11 :: What is broad cast agent?

A broadcast agent allows automation of emails to be distributed. It allows reports to be sent to different business objects. It also users to choose the report format and send via SMS, fax, pagers etc. broadcast agents allows the flexibility to the users to receive reports periodically or not. They help to manage and schedule the documents.

12 :: Which of the following is/are correct types of data?

a Semi-structured
b unstructured data
Both a and b
Semi data.

13 :: What does a typical BI environment comprise of?

Data warehouse
Data mart
All of the above

14 :: Do you know the concepts and capabilities of Business Intelligence?

Business Intelligence helps to manage data by applying different skills, technologies, security and quality risks. This also helps in achieving a better understanding of data. Business intelligence can be considered as the collective information. It helps in making predictions of business operations using gathered data in a warehouse. Business intelligence application helps to tackle sales, financial, production etc business data. It helps in a better decision making and can be also considered as a decision support system.

15 :: Explain the SQL Server 2005 Business Intelligence components?

SQL Server Integration Services:- Used for data transformation and creation. Used in data acquisition form a source system.
SQL Server Analysis Services: Allows data discovery using data mining. Using business logic it supports data enhancement.
SQL Server Reporting Services:- Used for Data presentation and distribution access.

16 :: Explain SAS Business Intelligence?

SAS business intelligence has analytical capabilities like statistics, reporting, data mining, predictions, forecasting and optimization. They help in getting data in the format desired. It helps in improving quality of data.

17 :: What is Dashboard in the business intelligence?

A dashboard in business intellgence allows huge data and reports to be read in a single graphical interface. They help in making faster decisions by replying on measurable data seen at a glance. They can also be used to get into details of this data to analyze the root cause of any business performance. It represents the business data and business state at a high level. Dashboards can also be used for cost control. Example of need of a dashboard: Banks run thousands of ATM’s. They need to know how much cash is deposited, how much is left etc.

18 :: Explain the concepts and capabilities of Business Object?

A business object can be used to represent entities of the business that are supported in the design. A business object can accommodate data and the behavior of the business associated with the entity. A business object can be any entity of the development environment or a real person, place or process. Business objects are most commonly used and can be used in businesses with volatile needs.
Data Business intelligence Interview Questions and Answers
18 Data Business intelligence Interview Questions and Answers