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 - 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 - 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 - Which of the following is faster method of creating Logical tables/objects in BMM layer?
A - Dragging Physical tables to Business Model
Answer : A
Explanation
Dragging Physical tables to Business Model which is the fastest way of defining Logical tables.
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 - Which of the following is most suitable for cache management?
Answer : A
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?
