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 takes the request from users via browser and pass all requests to OBIEE server?

A - OBIEE Presentation Server

B - OBIEE Application Server

C - OBIEE Scheduler

D - Oracle BI Server

Answer : A

Explanation

OBIEE Presentation Server

It takes the request from users via browser and pass all requests to OBIEE server.

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 - Logical and Complex joins are used in?

A - Physical Layer

B - BMM Layer

C - Presentation Layer

D - All of the above

Answer : B

Explanation

Joins in this layer are Logical joins. It doesnt show expressions and tells the type of join between tables. It helps Oracle BI Server to understand the relationships between the various pieces of the business model.

Q 5 - Which of the following is faster method of creating Logical tables/objects in BMM layer?

A - Dragging Physical tables to Business Model

B - Creating logical table manually

C - Both

Answer : A

Explanation

Dragging Physical tables to Business Model which is the fastest way of defining Logical tables.

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

A - 0

B - 1

C - 2

D - 3

Answer : C

Explanation

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

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

obiee_questions_answers.htm
Advertisements