FAQ OBIEE
Section-A (Repository Administration)
1-
Which of them is/are not OBIEE Services to be
started?
a)
Java Host
b)
Server
c)
Presentation
d)
Cache
2-
Which of them is/are not managed in Repository?
a)
Jobs
b)
Joins
c)
Catalog
d)
Variables
3-
Which of the Tools Utilities is not valid?
a)
LTS Column / Table Replacement
b)
Externalize String
c)
Updating Row Count
d)
Repository Documentation
4-
Type of Isolation Level including default are :
a)
4
b)
5
c)
6
d)
7
5-
Which of the Statement is/are incorrect:
a)
Repository Import to be activated from utilities
b)
Query Repository available in tools
c)
Projects to be allotted for MultiUser
Development
d)
All are correct
6-
What is/are not type of measure column?
a)
Additive
b)
Semi-additive
c)
Count-additive
d)
Non-additive
7-
This is/are
a dimension where data changes rapidly
a)
Rapidly Changing Dimension
b)
Slowly Changing Dimension
c)
Junk Dimension
d)
Degenerate Dimension
8-
Dimension
that is/are derived from fact table and does not have its own dimension table
a)
Rapidly Changing Dimension
b)
Slowly Changing Dimension
c)
Junk Dimension
d)
Degenerate Dimension
9-
To overcome changing dimensions performance
issue, we must create?
a)
Mini Dimension
b)
Segregate Dimension
c)
Incident Dimension
d)
Snapshot Dimension
10-
Best option for cache management is?
a)
Cache Seeding
b)
Cache Pruning
c)
Setting Event Pooling Table
d)
Programmatic cache management
11-
Which of them is/are not Time Series Function?
a)
Ago()
b)
Todate()
c)
Period()
d)
PeriodRolling()
12- What
cannot be done in presentation layer of Repository?
a) Nesting
of folders
b) Set
implicit fact column
c) Permission
grant to groups/users for security
d) Performing
calculations of measures
13-
We can set Bridge table from
a)
Properties of Physical Tables
b)
Properties of Logical Table
c)
Properties of LTS
d)
Properties of Presentation Table
14-
For moving your shared dashboard and reports
from dev to QA or Production you should:
a)
paste dev catalog to qa / prod environment
b)
paste only updated atr files to qa/prod
c)
merge catalog changes through catalog manager
d) paste files and associated atr files to qa/prod
15-
You can apply restriction/ filtration to data in
metadata repository in:
a)
Physical Layer Alias Table
b)
Logical Table
c)
Logical Table Source
d)
Presentation Table
16-
Which of these is not Hierarchy type?
a)
Skipped Hierarchy
b)
Composite Hierarchy
c)
Parent Child Hierarchy
d)
Ragged Hierarchy
17-
Cache can be disabled from?
a)
Capacity Management Tab of Fusion MiddleWare
b)
Diagnostics Tab of Fusion MiddleWare
c)
Overview Tab of Fusion MiddleWare
d)
Deployment Tab of Fusion MiddleWare
18-
Repository can be uploaded/ updated from?
a)
Capacity Management Tab of Fusion MiddleWare
b)
Diagnostics Tab of Fusion MiddleWare
c)
Overview Tab of Fusion MiddleWare
d)
Deployment Tab of Fusion MiddleWare
19-
Log messages can be verified from?
a)
Capacity Management Tab of Fusion MiddleWare
b)
Diagnostics Tab of Fusion MiddleWare
c)
Overview Tab of Fusion MiddleWare
d)
Deployment Tab of Fusion MiddleWare
20-
You can start all BI services from fusion
middleware from:
a)
Capacity Management Tab of Fusion MiddleWare
b)
Diagnostics Tab of Fusion MiddleWare
c)
Overview Tab of Fusion MiddleWare
d)
Deployment Tab of Fusion MiddleWare
21-
Calculations in logical columns are performed
from which tab of logical tables?
a)
General Tab
b)
Column Source
c)
Aggregation Tab
d)
Levels Tab
22-
Sorting of Month_Name or non lexicographic column data is done from:
a)
General Tab - Sort Order Column
b)
Column Source - Sort Order Column
c)
Logical Table Source - Sort Order Column
d)
General Tab - Descriptor ID Column
23-
In the current version of OBIEE (11g), java component
used is:
a)
rcu
b)
oc4j
c)
Fusion Middleware
d)
Weblogic server
24-
If you cannot view data of some physical table
you should:
a)
Uncache the table
b)
Alias the table
c)
Update connection pool properties
d)
All of the above
25-
Which statement is true?
a)
If presentation column is renamed, logical
column will get auto renamed
b)
If presentation column is renamed, physical
column will get auto renamed
c)
If Logical column is renamed, presentation
column will get auto renamed
d)
If Logical column is renamed, physical column
will get auto renamed
-----------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------
Answers :
Section-A
Answers
1-(d): cache is managed from rpd.
2-(c): Catalog is managed from obiee presentation server not within rpd
3-(c): Row Count Updation is not utilities part
4-(b)
5-(a): Available in options not utilities
6-(c)
7-(a)
8-(d)
9-(a)
10-(c)
11-(c)
12-(d)
13-(b)
14-(d)
15-(c): Through LTS, content tab's Fragmentation & where clause content
16-(b)
17-(a)
18-(d)
19-(b)
20-(c)
21-(b): Column Source - derived from existing column expression.
22-(a)
23-(d)
24-(c)
25-(c)
Answers
1-(d): cache is managed from rpd.
2-(c): Catalog is managed from obiee presentation server not within rpd
3-(c): Row Count Updation is not utilities part
4-(b)
5-(a): Available in options not utilities
6-(c)
7-(a)
8-(d)
9-(a)
10-(c)
11-(c)
12-(d)
13-(b)
14-(d)
15-(c): Through LTS, content tab's Fragmentation & where clause content
16-(b)
17-(a)
18-(d)
19-(b)
20-(c)
21-(b): Column Source - derived from existing column expression.
22-(a)
23-(d)
24-(c)
25-(c)
