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 - Which of the following contains all metadata of the BI Server and is managed through the administration tool?

A -Oracle BI Java Host

B - OBIEE Repositories

C - BI Presentation Server

D - Oracle BI Server

Answer : B

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

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

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

A - 0

B - 1

C - 2

D - 3

Answer : A

Q 9 - Which of the following are used for query performance optimization while running the reports and eliminates the time taken by query to run the calculations and delivers the results at fast speed?

A - Level Based Measure

B - Dimension Hierarchies

C - Aggregates

D - Variables

Answer : C

Explanation

Aggregations are used to implement query performance optimization while running the reports. This eliminates the time taken by query to run the calculations and delivers the results at fast speed. Aggregate tables has less number of rows as compared to a normal table.

Q 10 - Which of the following can be used to create a new user in OBIEE?

A - Repository

B - WebLogic Server Admin console

C - OBIEE Dashboard

D - Scheduler

Answer : B

Explanation

To create a new user, log on to the WebLogic Server admin console → Security Realms from the Fusion Middleware Control menu.

obiee_questions_answers.htm
Advertisements