Free Oracle 1Z1-591 Exam Dumps Questions & Answers

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

The Oracle BI office plug-in allows you to import the results of an OBI request into which two MS applications?

• A.  MS Visio
• B.  MS Excel
• C.  MS Word
• D.  MS Project

Cache in OBIEE is used to_____. Select the two correct answers.

• A.  improve performance of Dashboards and Analysis
• B.  eliminate Write Back Capabilities
• C.  create Aggregate tables
• D.  decrease query response time
• E.  improve Analysis data quality

When designing a Star Schema, which option does not apply?

• A.  The facts are quantifiable.
• B.  Dimensional tables are normalized.
• C.  Dimensional tables have one attribute primary key as Product_ID for products.
• D.  Fact table is joined to the related dimensional tables.
• E.  The fact has several foreign keys that are primary keys in the dimensional table

Which of the following characteristics pertain to a "ragged" hierarchy?

• A.  It creates multiple levels of hierarchy in the database table.
• B.  All values can have a maximum of six levels.
• C.  A branch of the hierarchy may have a different number of levels than other branches.
• D.  It can only be stored in an XML structure.