OBIEE Beginner Quiz

1
In case you need to build analytical application for both HR and Finance, which one will be preferred appraoch

1. Create 2 different RPD out of BI server and provide access to developer
2. Create one RPD with 2 different subject areas out of BI server and provide access to developer
3. Create one RPD out of BI server and provide access to developer
4. None of the above

Show Answer

 
2
Connection Pool is required

1. to define what report needs to be connected
2. to define what data source needs to be connected
3. to define what BMM layer to be connected
4. None of the above

Show Answer

 
3
What is true about “Clear all existing filter before applying”

1. Clear all value selection in filter
2. Clear all filters and reset filters again
3. Remove all other filters except the chosen one
4. None of the above

Show Answer

 
4
In Answers module, which statement is true

1. XML defines query
2. SQL defines content of query
3. Modification of XML representation can be done
4. All above

Show Answer

 
5
Which statement is correct about Dashboard Prompt

1. It provides flexibility in selecting filter criteria
2. will only work for ‘is equal to’ option
3. will only work for ‘is in’ option
4. None of the above

Show Answer

 
6
Which is incorrect statement for OBIEE

1. Java host service is explicitly required to be restared in Windows environment to see chart on dashboard
2. LRU concept used for purging cache
3. expression builder helps to create SQL expression
4. It is not possible to open OBIEE server admin in offline mode

Show Answer

 
7
There is not limit on how many rpd files that can be opened offline

1. True
2. FALSE

Show Answer

 
8
At any time, how many rpd files can be opened online?

1. 0
2. 1
3. 2
4. Any number of rpd files

Show Answer

 
9
When a report is run, BI Server generates

1. Logical query
2. Physical query
3. Both logical and physical queries
4. None of the above

Show Answer

10
The default view in Answers is

1. Table & Title
2. Chart
3. Compound Layoyt
4. None of the above

Show Answer

 
11
The —- file contains Db. configuration and tuning parameters for the Oracle BI Server

1. INI
2. ora
3. NQSConfig.INI
4. None of the above

Show Answer

 
12
Presentation columns are automatically renamed when the corresponding logical object is renamed

1. True
2. FALSE

Show Answer

 
13
While importing data sources, only a subset of tables and columns can be imported

1. True
2. FALSE

Show Answer

 
14
The query activity gets logged in —– file

1. log
2. log
3. NQQuery.log
4. log

Show Answer

 
15
Pivot views are built using

1. Answers
2. Delivers
3. Ibots
4. none of the above

Show Answer

 
16
Conditional formatting is set up

1. on the Dashboard
2. In Answers
3. Both
4. none of the above

Show Answer

 
17
The RPD can be used to set up

1. Authentication
2. Authorization
3. Both
4. none of the above

Show Answer

 
18
Complex joins are used to express relationships that do not involve a primary key-foreign key relationship

1. True
2. FALSE

Show Answer

 
19
Which of the following is NOT true of the Intelligence Dashboards?

1. They can provide personalized views and preconfigured views
2. Dashboard objects are saved in the repository
3. They can be created base on a user’s permission
4. Users with common responsibilities or job functions can share a dashboard

Show Answer

20
Which statements are TRUE of Filters?

1. Filters are applied on a column-level basis.
2. Table level filters prompts can be added to a request
3. The SQL within a specific request cannot be edited.
4. Saved requests can not be used as filters.

Show Answer

 
21
Which of the following is NOT true to improve the report performance?
 

1. Remove the unwanted joins
2. Remove the unwanted columns from Reports
3. Remove the Hints.
4. None of the Above

Show Answer

 
22
function of connection pool in OBIEE is:

1. It has the DSN information by means of which it connects to the database
2. It helps in creating joins
3. it helps in defining variables
4. None of the above

Show Answer

 
23
BMM Expression Builder is used for,

1. Creating Constraints
2. Creating Aggregations
3. Creating Logical Columns
4. Creating Joins

Show Answer

 
24
When double-clicking sales.rpd in the OracleBI/Repository directory, the OBI Server architect gets the message The repository ‘sales.rpd’ can only be opened as Read-Only. Do you want to open it? What does that message indicates?

1. Oracle BI Server is running.
2. Presentation Service is running
3. rpd is a default repository specified in the instanceconfig.xml
4. rpd is a special repository that can only be opened in online mode

Show Answer

 
25
Which layer of Oracle BI Administration Tool corresponds to the Oracle BI Answer’s Subject Area?

1. Presentation layer
2. Business Model and Mapping layer
3. Physical layer
4. None of the Above

Show Answer

 
26
Which of the following is NOT true of the OBIEE repository?

1. Physical layers can have multiple data sources.
2. By default, a presentation column uses the same name as its logical column in the Business Model and
3. Mapping layer.
4. Objects within a presentation catalog can derive from multiple business models.
5. Business Model and Mapping layer can have multiple data sources.

Show Answer

 
27
Which of the following statement is NOT true of consistency check ?

1. It guarantees that the business model is correctly built.
2. You can check the whole repository’s consistency or just a business model’s consistency.
3. It finds logical columns that are not mapped to physical sources.
4. It checks for undefined logical join conditions.

Show Answer

 
28
Any changes made during online mode of RPD to a business model in the BMM layer will purge all cache entries for that business model.

1. True
2. FALSE

Show Answer

 
29
Does Oracle BI Answer‘s chart has ability to navigate to one or more saved requests or dashboards?

1. Yes
2. No

Show Answer

30
The advantage of save filter is

1. apply the same conditions in multiple reports
2. Change the condition dynamically
3. All of the above
4. None of the above

Show Answer

 
31
The consistency checker can find

1. Errors
2. Warnings
3. Best Practices
4. All of the above

Show Answer

 
32
Which is not one of the possible output type of iBot

1. HTML
2. PDF
3. txt
4. None of the above

Show Answer

 
33
The functionality of Presentation Services is

1. Pass the request to BI Server
2. Security & Session Management
3. Cache Services & Connection Management
4. All of the above

Show Answer

 
34
The circular join can be resolved by

1. Creating alias
2. Creating complex join
3. Creating Initialization block
4. Creating physical join

Show Answer

 
35
In RPD we have a database table and alias in physical layer. How to add new columns in RPD which are available in database tables

1. add new columns manually in base tables only
2. add new columns manually alias tables wherever required
3. add new columns in base table and alias tables manually
4. delete the existing table and import

Show Answer

 
36
A logical column can be mapped to

1. Only one Logical Table Source
2. More than one Logical Table Source
3. All the logical table Source in the logical table
4. None of the above

Show Answer

 
37
Which of the following is a component of Oracle BI Server

1. Repository file
2. Cache
3. Only A
4. Both A & B

Show Answer

 
38
what is the extension of the reporsitory file

1. .RDP
2. .RPD
3. .REP
4. .REX

Show Answer

 
39
which layer provides a way to present a customized view of a business model to users

1. physical layer
2. Business Model and Mapping layer
3. Presentation Layer
4. none of the above

Show Answer

40
consistency check option cannot be accessed from

1. the file menu
2. tools menu
3. by right clicking the object
4. using Function key F9

Show Answer

 
41
publishing the repository is done using

1. fusion middleware control
2. by right clicking the presentation layer object in BI ADMIN tool
3. once presentation layer object is created, its automatically published
4. all options are correct

Show Answer

 
42
Logging levels are set after opening the repository in

1. offline mode
2. online mode
3. Either of the mode
4. none of the mode

Show Answer

 
43
which of the following is not a dashboard prompt

1. column
2. currency
3. image
4. constant

Show Answer

 
44
which tab helps in creating master detail report

1. style
2. interaction
3. data format
4. conditional format

Show Answer

 
45
which view provides information such as context, explanatory text, or extended descriptions along with column values for an analysis

1. column selector
2. view selector
3. narrative
4. none of the above

Show Answer