Oracle BI 11g Sample Certification Questions - II
Please find sample oracle BI questions with explanation, Please click on the link for Part -1
1) There are two aggregate tables that are
available for query. How would they be mapped into the logical data model so
queries can use them?
A. By creating two new logical tables sources
B. By opening the two logical Table Source dialog boxes
and mapping the appropriate levels in
the Content tab
C. Both A and B
D. By creating one new LogicalTableSource
Answer: B
Explanation:
1.Configure the new source table to have the 'logical
level' under the content set to 'Countries' (the
summarized level)
2.Do the similiar setting for dimension table
Now when user query the data at 'Counties' level, the
query will be redirected to these summary
table instead of the more detail fact table
Note:
Aggregate tables are Physical tables that store Aggregates of measures across
multiple
levels of a Hierarchy.
A. Navteq
B. TeleAtlas
C. Google
D. ESRI
Answer: C
Explanation: There
exists an integration between OBIEE and Google Maps.
A. The validity of objects outside the metadata using the
connection
B. Mappings to the physical objects
C. For objects deleted from the database
D. Syntax errors in derived logical columns
Answer: B
Explanation: Consistency check is one of the
process to check whether a repository is yielding
proper results in Answer reports. It checks whether;
* All logical columns are mapped correctly to physical columns (B).
* All logical
dimension tables have a logical key.
* There are at
least two logical tables in the business model; one is a logical fact table,
the other is logical dimension table with
join condition.
* There are no
circular logical join relationships.
* A presentation
catalog exists for the business model.
4) A company's Database Administrator has
divided the region table into two tables so that the
region
"West" is in one table and all the other regions are in another
single table. What kind of
partition is being
used?
A. Fact-based
B. Time-based
C. Mixed
D. Complex
Answer: C
Explanation: You
have three sort of fragmentation:
Fact-based / Dimension-based fragmentation
Content-based / Value-based fragmentation
Level-based fragmentation / aggregate navigation
You can combine the techniques above to construct
powerful design that are known as Complex
partitioning / fragmentation. When you fragment a
dimension, you are automatically in a complex
fragmentation.
5) Where is Cache in OBIEE located?
A. In relational database
B. It is local disk-based.
C. In dynamic aggregate
D. In memory cache
Answer: B
Explanation: In
OBIEE cache will be stored as files on the Hard Disk of the OBIEE Server in the
form of files.
6) A customer always wants Aggregate Table l to
be looked at first to see if it can answer the query. What should be done
to make sure this happens?
A. Make AggregateTable 1 the first table in the list
ofLogical TableSources.
B. Do not map the logical level in the Content tab.
C. Set the Priority Group to 0.
D. Set the Priority Croup to5.
Answer: C
7) Which OBIEE capability enables developers to
build Aggregate tables?
A. Aggregate Persistence Wizard
B. Expression Builder
C. Table Builder
D. Query Analyzer
Answer: A
Explanation: Aggregate
Persistence Wizard automates the creation and initial population of
aggregates, persists them in a back-end database and
configures the BI Server metadata layer so
that they’re used when appropriate.
8) When creating a new dimensional hierarchy in
the BI Administration tool, right click the dimension, then select "New
Object" What must be selected next?
A. Logical Key
B. ParentLevel
C. ChildLevel
D. Dynamic Key
Answer: B
9) What are the two types of Repository
Variables?
A. System
B. Non System
C. Static
D. Dynamic
Answer: C,D
10) Under what circumstances would you model
within the BI environment to include transactional
data directly?
A. When the customer needs near real-time data to support
decision making in a fast changing
environment
B. When the customer is not prepared to spend budget on
data-warehousing
C. When the complexity of operational schema does not
allow modeling in the BI repository
D. When it is not possible to query against a
transactional system
For latest and updated 1z0-591 certification dumps contact us at completeexamcollection@gmail.com
ReplyDelete