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 takes the request from users via browser and pass all requests to OBIEE server?

A - OBIEE Presentation Server

B - OBIEE Application Server

C - OBIEE Scheduler

D - Oracle BI Server

Answer : A

Explanation

OBIEE Presentation Server

It takes the request from users via browser and pass all requests to OBIEE server.

Q 2 - While creating a new repository, which of the following meta types you can import?

A - Foreign Keys

B - System tables

C - Synonyms

D - Alias

E - All of the above

Answer : E

Explanation

Accept the meta types you want to import → You can select Tables, Keys, Foreign Keys, System tables, Synonyms, Alias, Views, etc.

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

A - Logical Joins

B - Sub Query

C - Derived Table

D - Complex Joins

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 - Which of the following is most suitable for cache management?

A - Setting Event Pooling Table

B - Cache Seeding

C - Cache Pruning

D - None of the above

Answer : A

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