Monday, April 1, 2013

Oracle BI 11g Sample Certification Questions - II


Oracle BI 11g Sample Certification Questions - II


Please find sample oracle BI questions with explanation, Please click on the link for Part -1


 You can view all the questions in the links below  Link 1    Link 2

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.

 2)      Which Oracle Partner is the supplier of map-based content to provide background maps, boundary information, and points of interest?

A. Navteq
B. TeleAtlas
C. Google
D. ESRI

Answer: C
Explanation: There exists an integration between OBIEE and Google Maps.

 3)      The Consistency Checker check is______.

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:
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:
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:
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

Answer: A

Please click on the link for Part -1


 You can view all the questions in the links below  Link 1    Link 2





1 comment:

  1. For latest and updated 1z0-591 certification dumps contact us at completeexamcollection@gmail.com

    ReplyDelete