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

Explanation

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

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 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 - Dimensions derived from fact table and doesnt 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

Explanation

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

Answer : B

Explanation

To improve query performance, we disable BI server cache option

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 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 - Which of the following can be used to create a new user in OBIEE?

A - Repository

B - WebLogic Server Admin console

C - OBIEE Dashboard

D - Scheduler

Answer : B

Explanation

To create a new user, log on to the WebLogic Server admin console → Security Realms from the Fusion Middleware Control menu.

obiee_questions_answers.htm
Advertisements