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 - Designing an OBIEE repository using administration tool is how many layer process?

A - 2

B - 3

C - 4

D - 5

Answer : B

Explanation

It is a three layer process- starting from Physical Layer (Schema Design), Business Model Layer, Presentation Layer.

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

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 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 - 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
E-Books Store