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.

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

Answer : B

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 - Which of the following can be used for performance optimization when table size is too large?

Answer : C

Explanation

You can also define a table as driving table from drop down list in Joining Manager, this is used for performance optimization when table size is too large.

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

Answer : C

Explanation

User has a logging level set to 0 and Administrator has a logging level set to 2.

Q 9 - Which of the following Variable type has a single value at any point of time and are defined using Oracle BI Administration tool?

A - Repository Variable

B - Session Variable

C - Request Variables

D - None of these

Answer : A

Explanation

A Repository variable has a single value at any point of time. Repository variables are defined using Oracle BI Administration tool. Repository variables can be used in place of constants in Expression Builder Wizard.

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?