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 1 - In OBIEE architecture, Scheduler is part of which of the following component?

A - Server Components

B - Client Components

C - Business Layer Components

D - All of the above

Answer : A

Explanation

OBIEE Server Components −

  • Oracle BI (OBIEE) Server
  • Oracle Presentation Server
  • Application Server
  • Scheduler
  • Cluster Controller

Q 2 - Which of the following contains all metadata of the BI Server and is managed through the administration tool?

A -Oracle BI Java Host

B - OBIEE Repositories

C - BI Presentation Server

D - Oracle BI Server

Answer : B

Q 3 - Which of the following layer of OBIEE repository contains information about data sources and is responsible for importing metadata from databases?

A - Physical Layer

B - BMM Layer

C - Presentation Layer

D - All of the above

Answer : A

Q 4 - To open the Logical Table Source dialog box in BMM layer, you have to double click on?

A - Logical table source

B - Logical table

C - Both

Answer : A

Q 5 - When you drag the tables from Physical layer to BMM layer, it also preserves the joins and keys automatically?

A - True

B - False

Answer : A

Q 6 - Which of the following Aggregate functions you can use?

A - Sum

B - Average

C - Count

D - Max

E - All of these

Answer : E

Explanation

There are various Aggregate functions that can be used like Sum, Average, Count, Max, Min, etc.

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 - In a normal scenario, what is the logging level for users?

A - 0

B - 1

C - 2

D - 3

Answer : A

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