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 2 - Which of the following components are not managed in OBIEE repository?

A - Jobs

B - Catalog

C - Variables

D - Keys

Answer : B

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 - Dimensions derived from fact table and doesn’t include in dimension table are known as?

A - Slowly Changing Dimension

B - Rapidly changing Dimension

C - Degenerate Dimension

D - None of these

Answer : C

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 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


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 7 - To improve query performance, BI server cache option should be?

A - Enabled

B - Disabled

C - Doesn’t Matter

Answer : B


To improve query performance, we disable BI server cache option

Q 8 - In a normal scenario, what is the logging level for Administrators?

A - 0

B - 1

C - 2

D - 3

Answer : C


User has a logging level set to 0 and Administrator has a logging level set to 2.

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

A - 1

B - 2

C - 3

D - 4

E - 5

Answer : B


There are two types of Repository variables −

  • Static Repository Variables
  • Dynamic Repository Variables

Q 10 - If you are not able to view data of a Physical table, which of the following can be used?

A - Uncache the table

B - Alias the table

C - Update connection pool properties

D - All of the above

Answer : C