OBIEE Online Quiz


Advertisements


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 - 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 - 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 - To open the Logical Table Source dialog box in BMM layer, you have to double click on?

A - Logical table source

B - Logical table

C - Both

Answer : A

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 should be used to overcome the issue of changing dimensions performance?

A - Junk Dimension

B - Degenerate Dimension

C - Mini Dimension

D - None of these

Answer : C

Answer : A

Explanation

In the left side, expand Business Intelligence → coreapplication → Capacity Management tab → Performance

Q 8 - In the current version of OBIEE (11g), java component used is:

A - oc4j

B - Fusion Middleware

C - Weblogic server

D - None of these

Answer : C

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