Free Oracle 1z0-591 Exam Dumps Questions & Answers

When creating Aggregate tables in the OBI repository by using the Aggregate Persistence Wizard, which two statements are true?

• A.  Job Manager can be used to run the Aggregate Persistence script.
• B.  The Aggregate Persistence Wizard enables you to automate the creation of physical aggregate tables and their corresponding objects in the repository.
• C.  The analyst must first write DML (Data Manipulation Language) scripts to create the aggregate table.
• D.  The Extraction Transformation and Loading process creates the aggregate tables.

How do you get the BI plug-in for MS Office?

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

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.  Time-based
• B.  Mixed
• C.  Fact-based
• D.  Complex

Initialization Blocks are never used to initialize which option?

• A.  Dynamic Repository Variables
• B.  System Session Variables
• C.  rpd file
• D.  Non System Session Variables

Which language is used by OBIEE to query Essbase?

• A.  MDX
• B.  DMX
• C.  LINQ
• D.  SQL