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 - Physical join is recommended to be used in?

A - Physical Layer

B - BMM Layer

C - Presentation Layer

D - All of the above

Answer : A

Q 4 - Logical and Complex joins are used in?

A - Physical Layer

B - BMM Layer

C - Presentation Layer

D - All of the above

Answer : B

Explanation

Joins in this layer are Logical joins. It doesn’t show expressions and tells the type of join between tables. It helps Oracle BI Server to understand the relationships between the various pieces of the business model.

Q 6 - Which of the following should be used to overcome the issue of changing dimensions performance?

A - Junk Dimension

B - Degenerate Dimension

C - Mini Dimension

D - None of these

Answer : C

Q 7 - Which of the following is most suitable for cache management?

A - Setting Event Pooling Table

B - Cache Seeding

C - Cache Pruning

D - None of the above

Answer : A

Q 8 - Logging level can have values starting from Level 0 to level 5 and Level 0 means maximum logging and Level 5 means no logging level information?

A - True

B - False

Answer : B

Explanation

Level 0 means no logging and Level 5 means maximum logging level information.

Q 9 - Which of the following are used for query performance optimization while running the reports and eliminates the time taken by query to run the calculations and delivers the results at fast speed?

A - Level Based Measure

B - Dimension Hierarchies

C - Aggregates

D - Variables

Answer : C

Explanation

Aggregations are used to implement query performance optimization while running the reports. This eliminates the time taken by query to run the calculations and delivers the results at fast speed. Aggregate tables has less number of rows as compared to a normal table.

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