Oracle Business Intelligence Foundation Suite 11g Essentials - 1Z1-591 Exam Practice Test

A. Logical Column Name B. Implicit Fact Column C. Logical Key D. Alias E. Custom Display Name

A. Planning is not a supported OBIEE source. B. OBIEE provides complete access to all Planning data through the Analytic Data Model (ADM) layer. C. OBIEE integrates with Planning directly through relational database access. D. OBIEE primarily accesses Planning using standard Essbase integration techniques.

A. Create a Logical Table that is sourced from the time key in the fact table. B. Create a physical time table in your database. C. Create a Logical Table that is sourced from a time field in one of your dimension tables. D. Create an "Opaque View" in the physical layer that contains the time columns from the fact and map it into your physical model. E. Create a time table that is joined through a intervening Table so there is no foreign key relationship.

A. Create a dedicated Connection Pool B. Test the Aggregate table by using Analysis C. Use Job Manager to run the Aggregate script D. Specify the Fact table that you want to aggregate

A. Control runaway queries B. Control User Authentication C. Limit Queries by maximum run time D. Control aggregation E. Control Write Back Capabilities

A. By contacting the administrator B. By downloading it from the Database Server C. By downloading it from the BI Server D. By downloading it from Microsoft Server

A. Query Analyzer B. Table Builder C. Expression Builder D. Aggregate Persistence Wizard

A. When the customer is not prepared to spend budget on data-warehousing B. When it is not possible to query against a transactional system C. When the customer needs near real-time data to support decision making in a fast changing environment D. When the complexity of operational schema does not allow modeling in the BI repository