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 - Which of the following component types are responsible to run OBIEE system as compared to components used for creating interactive dashboards?

A - Client Components

B - Server Components

C - Business Layer components

D - All of the above

Answer : B

Explanation

Server components are responsible to run OBIEE system and client components interact with user to create reports and dashboards.

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

Answer : D

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 - 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 - 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 - Suppose that an analysis contains the sales totals for a certain region of US in US dollars. However, because the users viewing the analysis reside in the Canada, they want to view data in CAD. Which of the following feature helps?

A - Image Prompt

B - Variable Prompt

C - Currency Prompt

D - Column Prompt

Answer : C


obiee_questions_answers.htm

Advertisements