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 2 - Which of the following components are not managed in OBIEE repository?

A - Jobs

B - Catalog

C - Variables

D - Keys

Answer : B

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

A - Sum

B - Average

C - Count

D - Max

E - All of these

Answer : E

Explanation

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

Q 8 - Which of the following dimension hierarchies are possible in OBIEE?

A - Dimensions with level based hierarchies

B - Dimension with Parent-child hierarchies

C - Both

Answer : C

Q 9 - How many types of Repository variables you can create?

A - 1

B - 2

C - 3

D - 4

E - 5

Answer : B

Explanation

There are two types of Repository variables −

  • Static Repository Variables
  • Dynamic Repository Variables

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