1z0-591 Sample Questions

1z0-591 Sample Questions & Answers

Repository development with dimensional hierarchies and metadata carries the largest share, alongside OBIEE security through authentication and query governing, architecture, installation, the user interface, performance tuning and caching, and Office integration.

Launch the full 1z0-591 simulator →

Showing 6 of 12 free samples.

  1. Question 1

    If Security attributes conflict, what happens?

    Show answer & explanation

    Correct answer: A

    Explanation:
    If security attributes conflict, a user or group is granted the least restrictive security attribute.

  2. Question 2

    Initialization Blocks are never used to initialize which option?

    Show answer & explanation

    Correct answer: D

    Explanation:
    Initialization blocks are used to initialize dynamic repository variables, system session variables, and nonsystem session variables.

  3. Question 3Select 2

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

    Show answer & explanation

    Correct answers: B, D

    B, D -- Explanation:
    Oracle Business Intelligence Office Plug-In is a Windows application that is an optional feature under the Oracle Business Intelligence Presentation Services. The Plug-In provides a way to browse the Analytics catalog, select a report, and then drop that report into Microsoft Word or Excel.
    Reference: Oracle Business Intelligence Infrastructure Installation and Configuration Guide > Installing Individual Oracle Bl Components installing Oracle Bl Office Plug-In

    B, D -- Explanation:
    Oracle Business Intelligence Office Plug-In is a Windows application that is an optional feature under the Oracle Business Intelligence Presentation Services. The Plug-In provides a way to browse the Analytics catalog, select a report, and then drop that report into Microsoft Word or Excel.
    Reference: Oracle Business Intelligence Infrastructure Installation and Configuration Guide > Installing Individual Oracle Bl Components installing Oracle Bl Office Plug-In

  4. Question 4

    The Consistency Checker checks _________.

    Show answer & explanation

    Correct 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.

  5. Question 5

    One of the initial phases in OBIEE implementation is the Discovery phase where the project team focuses on a few activities. Which option is not one of them?

    Show answer & explanation

    Correct answer: B

    Incorrect answers:
    D: Testing is present within the Discovery phase.

  6. Question 6

    Which option describes how OBIEE natively integrates with HFM?

    Show answer & explanation

    Correct answer: A

    Explanation:
    Bl EE uses the ADM driver to extract the data from HFM.
    Note: HFM (Hyperion Financial Management)
    Example: 1 EE connects to HFM through JavaHost. So, the setup for configuring the connectivity is to basically make the EPM environment variables available for access to Bl EE. Before making the changes, there are a couple of things to be aware of

    1. Ensure that DCOM is enabled on the Bl Server machine. This is needed for HFM client to work/connect properly with HFM Server.
    2. Ensure that HFM Client is installed.
      The above assumes EPM 11.1,2.x version. If you are on Hyperion 9.3.3, then you need to have the ADM drivers installed manually. All of this is documented clearly. So, rather than re-iterating that i will just point to the link here. Ensure that you follow all the steps mentioned in the docs else you will have issues in the connectivity. Once all the pre-requisite steps are done, we start off with the metadata import process.

Ready for the real thing?

The full 1z0-591 simulator has every exam-style question, timed mode, and instant scoring.