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 - Which of the following component types are responsible to run OBIEE system as compared to components used for creating interactive dashboards?

A - Client Components

B - Server Components

C - Business Layer components

D - All of the above

Answer : B


Server components are responsible to run OBIEE system and client components interact with user to create reports and dashboards.

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


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 - 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 6 - Which of the following Aggregate functions you can use?

A - Sum

B - Average

C - Count

D - Max

E - All of these

Answer : E


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

Q 7 - What is the extension of Repository file?

A - .RXD

B - .RCD

C - .RPD

D - .RLD

Answer : C

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 tool enables end users to run ad-hoc reports and analysis as per business requirement model?

A - Column prompt

B - Variable prompt

C - OBIEE Dashboard

D - Presentation Layer

Answer : C

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