Oracle Business Intelligence Foundation Suite 11g Essentials

Here you have the best Oracle 1z0-591 practice exam questions

  • You have 120 total questions to study from
  • Each page has 5 questions, making a total of 24 pages
  • You can navigate through the pages using the buttons at the bottom
  • This questions were last updated on October 27, 2025
  • This site is not affiliated with or endorsed by Oracle.
Question 1 of 120
Which installation option is used to install into an existing Fusion Middleware Home?
    Correct Answer: A

Question 2 of 120
What are the two methodologies that are followed within an OBIEE implementation?
    Correct Answer: B, C

Question 3 of 120
Which option describes how OBIEE Integrates with Planning?
    Correct Answer: A, B

Question 4 of 120
What is an example of a Session Variable?
    Correct Answer: B

Question 5 of 120
Which option is used to enter the rank function when creating a new rank measure?
    Correct Answer: B
    Example (see step 4 and 5 below): Getting Top-N Sales Reps for Year and Year-1
    1. Under the "Business Model and Mapping" Layer, right click the "F1 Revenue" and select "New Object" -> "Logical Column…"
    2. In the "Logical Column" Window give for Name: Year Ago Revenue as seen below:
    Exam 1z0-591: Question 5 - Image 1
    3. Goto the "Column Source" Tab and select "Derived from existing columns using an expression" radio button then click on the "Edit Expression" icon.
    4. Enter the following expression in the "Expression Builder" Window by selecting "Functions" in the "Category:" list, "Time Series Functions" in the "Functions:" list then "Ago" "Time Series Functions:" section.
    5. Select the "<<Measure>>" in the "Ago( )" function, then select "Logical Tables" in the "Category:" list, "F1 Revenue" in the "Logical Tables:" list, then double click the "Revenue" in the "Columns:" list.
    Etc. B