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 - Designing an OBIEE repository using administration tool is how many layer process?

A - 2

B - 3

C - 4

D - 5

Answer : B

Explanation

It is a three layer process- starting from Physical Layer (Schema Design), Business Model Layer, Presentation Layer.

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

A - 0

B - 1

C - 2

D - 3

Answer : A

Q 9 - Session variables are similar to dynamic repository variables and that they obtain their values from initialization blocks?

A - True

B - False

Answer : A

Q 10 - Which of the following Prompts enables you to build very specific value prompts to either stand alone on the dashboard or analysis or to expand or refine existing dashboard and analysis filters?

A - Named Prompt

B - Inline Prompt

C - Column Prompt

D - None of the above

Answer : C

Explanation

A column prompt is the most common and flexible prompt type. A column prompt enables you to build very specific value prompts to either stand alone on the dashboard or analysis or to expand or refine existing dashboard and analysis filters. Column prompts can be created for hierarchical, measure, or attribute columns at the analysis or dashboard level.

obiee_questions_answers.htm
Advertisements