OBIEE Online Quiz


Advertisements


Following quiz provides Multiple Choice Questions (MCQs) related to OBIEE. You will have to read all the given answers and click over the correct answer. If you are not sure about the answer then you can check the answer using Show Answer button. You can use Next Quiz button to check new set of questions in the quiz.

Questions and Answers

Q 2 - In OBIEE architecture, which of the following component is used to star and stop all components of BI system and is managed and controlled by Fusion Middleware Controller?

A - Web Logic Server

B - Node Manager

C - Oracle Process Manager and Notification Server

D - None of these

Answer : C

Explanation

Oracle Process Manager and Notification Server (OPMN)

OPMN is used to star and stop all components of BI system. It is managed and controlled by Fusion Middleware Controller.

Q 3 - It is recommended to use Physical join in physical layer and complex join in BMM layer as much as possible to keep Repository design simple. Only when there is an actual need for a different join, then use Physical join in BMM layer?

A - True

B - False

Answer : A

Answer : D

Explanation

When you import tables from schema into RPD Physical Layer, You can also select KEY and FOREIGN KEY along with the table data, then the primary key-foreign key joins are automatically defined, however it is not recommended from performance point of view.

Q 5 - Which of the following functions can’t be performed in Presentation layer?

A - Nesting of folders

B - Set implicit fact column

C - Permission grant to groups/users for security

D - Performing calculations of measures

Answer : D

Q 6 - Which of the following can be used for performance optimization when table size is too large?

A - Logical Joins

B - Sub Query

C - Derived Table

D - Complex Joins

Answer : C

Explanation

You can also define a table as driving table from drop down list in Joining Manager, this is used for performance optimization when table size is too large.

Q 8 - Which of the following dimension hierarchies are possible in OBIEE?

A - Dimensions with level based hierarchies

B - Dimension with Parent-child hierarchies

C - Both

Answer : C

Q 9 - How many types of Repository variables you can create?

A - 1

B - 2

C - 3

D - 4

E - 5

Answer : B

Explanation

There are two types of Repository variables −

  • Static Repository Variables
  • Dynamic Repository Variables

Q 10 - Which of the following is most recommended way of assigning permissions and privileges?

A - Application Roles

B - Individual Users

C - Catalog Groups

D - All of the above

Answer : A

Explanation

To application roles − Most recommended way of assigning permissions and privileges.

To individual users − This is difficult to manage where you can assign permissions and privileges to specific users.

To Catalog groups − It was used in previous releases for backward compatibility maintenance.


obiee_questions_answers.htm

Advertisements