- 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 - Which of the following component types are responsible to run OBIEE system as compared to components used for creating interactive dashboards?
Answer : B
Explanation
Server components are responsible to run OBIEE system and client components interact with user to create reports and dashboards.
Q 2 - While creating a new repository, which of the following meta types you can import?
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?
Answer : A
Q 4 - Dimensions derived from fact table and doesnt include in dimension table are known as?
Answer : C
Q 5 - Dimensions where data changes rapidly are known as?
A - Slowly Changing Dimensions
Answer : A
Q 6 - Which of the following can be used for performance optimization when table size is too large?
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 - You can disable the cache option from?
A - Capacity Management Tab of Fusion MiddleWare
B - Diagnostics Tab of Fusion MiddleWare
Answer : A
Explanation
In the left side, expand Business Intelligence → coreapplication → Capacity Management tab → Performance
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?
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 - If you are not able to view data of a Physical table, which of the following can be used?