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 layer in OBIEE supports single data source in a single repository and you need to create multiple repositories to use multiple data sources?

A - True

B - False

Answer : A

Explanation

Physical layer in OBIEE supports multiple data sources in a single repository - i.e. data sets from 2 different data sources can be performed in OBIEE.

Q 4 - Logical and Complex joins are used in?

A - Physical Layer

B - BMM Layer

C - Presentation Layer

D - All of the above

Answer : B

Explanation

Joins in this layer are Logical joins. It doesn’t show expressions and tells the type of join between tables. It helps Oracle BI Server to understand the relationships between the various pieces of the business model.

Answer : A

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 - 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 - Which of the following dimension hierarchies are possible in OBIEE?

A - Dimensions with level based hierarchies

B - Dimension with Parent-child hierarchies

C - Both

Answer : C

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 - If you are not able to view data of a Physical table, which of the following can be used?

A - Uncache the table

B - Alias the table

C - Update connection pool properties

D - All of the above

Answer : C

obiee_questions_answers.htm
Advertisements