- OBIEE - Home
- OBIEE - Data Warehouse
- OBIEE - Dimensional Modeling
- OBIEE - Schema
- OBIEE - Basics
- OBIEE - Components
- OBIEE - Architecture
- OBIEE - Repositories
- OBIEE - Business Layer
- OBIEE - Presentation Layer
- OBIEE - Testing Repository
- OBIEE - Multiple Logical Table
- OBIEE - Calculation Measures
- OBIEE - Dimension Hierarchies
- OBIEE - Level-Based Measures
- OBIEE - Aggregates
- OBIEE - Variables
- OBIEE - Dashboards
- OBIEE - Filters
- OBIEE - Views
- OBIEE - Prompts
- OBIEE - Security
- OBIEE - Administration
OBIEE Online Quiz
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 - OBIEE Application Server helps to work on client components and Oracle provides Oracle10g Application server with OBIEE suite?
Answer : A
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?
Answer : C
Explanation
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 - Physical join is recommended to be used in?
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
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 - Dimensions where data changes rapidly are known as?
A - Slowly Changing Dimensions
Answer : A
Q 6 - Which of the following should be used to overcome the issue of changing dimensions performance?
Answer : C
Q 7 - To improve query performance, BI server cache option should be?
Answer : B
Explanation
To improve query performance, we disable BI server cache option
Answer : C
Explanation
User has a logging level set to 0 and Administrator has a logging level set to 2.
Q 9 - Which of the following tool enables end users to run ad-hoc reports and analysis as per business requirement model?
Answer : C
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?