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 1 - OBIEE Application Server helps to work on client components and Oracle provides Oracle10g Application server with OBIEE suite?

A - True

B - False

Answer : A

Q 2 - In OBIEE architecture, which of the following component is used to star and stop all components of BI system and is managed and controlled by Fusion Middleware Controller?

A - Web Logic Server

B - Node Manager

C - Oracle Process Manager and Notification Server

D - None of these

Answer : C

Explanation

Oracle Process Manager and Notification Server (OPMN)

OPMN is used to star and stop all components of BI system. It is managed and controlled by Fusion Middleware Controller.

Q 3 - Which of the following doesn’t represent a measure column in table?

A - Additive

B - Semi-additive

C - Count-additive

D - Non-additive

Answer : D

Q 4 - While Creating Business Model and Mapping Layer of a Repository, arrange the following in correct order in normal scenario −

1.Create a Business Model

2.Creating Measures (Aggregations)

3.Examine Logical Joins

4.Rename Logical Table Objects Using the Rename Wizard and Deleting Unnecessary Logical Objects.

5.Rename Logical Table Objects Manually

A - 1,2,3,4,5

B - 1,3,4,5,2

C - 1,3,5,4,2

D - 1,4,5,3,2

Answer : C

Explanation

To build the Business Model and Mapping layer of a repository, below are the steps −

  • Create a Business Model
  • Examine Logical Joins
  • Examine Logical Columns
  • Examine Logical Table Sources
  • Rename Logical Table Objects Manually
  • Rename Logical Table Objects Using the Rename Wizard and Deleting Unnecessary Logical Objects
  • Creating Measures (Aggregations)

Answer : A

Answer : A

Explanation

Presentation Column dialog box appears → to use the name of the logical column, select the Use Logical Column check box.

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