OBIEE Online Quiz


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 - While creating a new repository, which of the following meta types you can import?

A - Foreign Keys

B - System tables

C - Synonyms

D - Alias

E - All of the above

Answer : E

Explanation

Accept the meta types you want to import → You can select Tables, Keys, Foreign Keys, System tables, Synonyms, Alias, Views, etc.

Q 3 - Which of the following doesn’t represent a measure column in table?

A - Additive

B - Semi-additive

C - Count-additive

D - Non-additive

Answer : D

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

Answer : A

Q 6 - The name of presentation columns are normally different from logical column names in the Business Model and Mapping layer?

A - True

B - False

Answer : B

Q 7 - To improve query performance, BI server cache option should be?

A - Enabled

B - Disabled

C - Doesn’t Matter

Answer : B

Explanation

To improve query performance, we disable BI server cache option

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 - Which of the following Variable type has a single value at any point of time and are defined using Oracle BI Administration tool?

A - Repository Variable

B - Session Variable

C - Request Variables

D - None of these

Answer : A

Explanation

A Repository variable has a single value at any point of time. Repository variables are defined using Oracle BI Administration tool. Repository variables can be used in place of constants in Expression Builder Wizard.

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