OBIEE Beginner Quiz

Posted on: | By: – Comments Off

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Create one RPD with 2 different subject areas out of BI server and provide access to developer[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : to define what data source needs to be connected[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Remove all other filters except the chosen one[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : All above[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : It provides flexibility in selecting filter criteria[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : It is not possible to open OBIEE server admin in offline mode[/bg_collapse]
 
7
There is not limit on how many rpd files that can be opened offline

  1. True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : True[/bg_collapse]
 
8
At any time, how many rpd files can be opened online?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : 1[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Both logical and physical queries[/bg_collapse]



10
The default view in Answers is

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Compound Layoyt[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : NQSConfig.INI[/bg_collapse]
 
12
Presentation columns are automatically renamed when the corresponding logical object is renamed

  1. True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : True[/bg_collapse]
 
13
While importing data sources, only a subset of tables and columns can be imported

  1. True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : True[/bg_collapse]
 
14
The query activity gets logged in —– file

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : NQQuery.log[/bg_collapse]
 
15
Pivot views are built using

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Answers[/bg_collapse]
 
16
Conditional formatting is set up

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : In Answers[/bg_collapse]
 
17
The RPD can be used to set up

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Both[/bg_collapse]
 
18
Complex joins are used to express relationships that do not involve a primary key-foreign key relationship

  1. True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : True[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Dashboard objects are saved in the repository[/bg_collapse]



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.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Filters are applied on a column-level basis.[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Remove the Hints.[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : It has the DSN information by means of which it connects to the database[/bg_collapse]
 
23
BMM Expression Builder is used for,

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Creating Logical Columns[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Oracle BI Server is running.[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Presentation layer[/bg_collapse]
 
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.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Objects within a presentation catalog can derive from multiple business models.[/bg_collapse]
 
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.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : It guarantees that the business model is correctly built.[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : True[/bg_collapse]
 
29
Does Oracle BI Answer‘s chart has ability to navigate to one or more saved requests or dashboards?

  1. Yes
  2. No

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Yes[/bg_collapse]



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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : apply the same conditions in multiple reports[/bg_collapse]
 
31
The consistency checker can find

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : All of the above[/bg_collapse]
 
32
Which is not one of the possible output type of iBot

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : txt[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : All of the above[/bg_collapse]
 
34
The circular join can be resolved by

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Creating alias[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : add new columns manually in base tables only[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : More than one Logical Table Source[/bg_collapse]
 
37
Which of the following is a component of Oracle BI Server

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Both A & B[/bg_collapse]
 
38
what is the extension of the reporsitory file

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : .RPD[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Presentation Layer[/bg_collapse]



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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : using Function key F9[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : fusion middleware control[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : online mode[/bg_collapse]
 
43
which of the following is not a dashboard prompt

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : constant[/bg_collapse]
 
44
which tab helps in creating master detail report

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : interaction[/bg_collapse]
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : narrative[/bg_collapse]



 
 

Related Articles

Advanced Manufacturing Process Quiz

Web analytics, Adobe Analytics, Google Analytics Quiz

SailPoint Quiz