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?
Server components are responsible to run OBIEE system and client components interact with user to create reports and dashboards.
Q 2 - In OBIEE architecture, which of the following component is used to star and stop all components of BI system and is managed and controlled by Fusion Middleware Controller?
Oracle Process Manager and Notification Server (OPMN) −
OPMN is used to star and stop all components of BI system. It is managed and controlled by Fusion Middleware Controller.
Q 3 - It is recommended to use Physical join in physical layer and complex join in BMM layer as much as possible to keep Repository design simple. Only when there is an actual need for a different join, then use Physical join in BMM layer?
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
To build the Business Model and Mapping layer of a repository, below are the steps −
Q 5 - Cardinality relation one to many means?
Q 6 - Which of the following can be used for performance optimization when table size is too large?
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?
To improve query performance, we disable BI server cache option
Q 8 - In the current version of OBIEE (11g), java component used is:
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?
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 is most recommended way of assigning permissions and privileges?
To application roles − Most recommended way of assigning permissions and privileges.
To individual users − This is difficult to manage where you can assign permissions and privileges to specific users.
To Catalog groups − It was used in previous releases for backward compatibility maintenance.