- OBIEE Tutorial
- 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 Useful Resources
- OBIEE - Questions Answers
- OBIEE - Quick Guide
- OBIEE - Useful Resources
- OBIEE - Discussion
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 takes the request from users via browser and pass all requests to OBIEE server?
Answer : A
Explanation
OBIEE Presentation Server
It takes the request from users via browser and pass all requests to OBIEE server.
Q 2 - Which of the following contains all metadata of the BI Server and is managed through the administration tool?
Answer : B
Q 3 - Which of the following doesn’t represent a measure column in table?
Answer : D
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 Aggregate functions you can use?
Answer : E
Explanation
There are various Aggregate functions that can be used like Sum, Average, Count, Max, Min, etc.
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 8 - Which of the following dimension hierarchies are possible in OBIEE?
A - Dimensions with level based hierarchies
Answer : C
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 - 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?
To Continue Learning Please Login