[Free] 2018(Jan) EnsurePass Testinsides Oracle 1z0-591 Dumps with VCE and PDF 31-40

By | January 25, 2018

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-591
100% Free Download! 100% Pass Guaranteed!

Oracle Business Intelligence Foundation Suite 11g Essentials

Question No: 31

Which option describes how OBIEE natively integrates with HFM?

  1. Through EPM Analytic Data Model (ADM) connectivity

  2. Direct relational database access

  3. Through Essbase connectivity

  4. OBIEE does not support HFM integration

Answer: A

Explanation: BI EE uses the ADM driver to extract the data from HFM. Note: HFM (Hyperion Financial Management)


I 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 BI EE. Before making the changes, there are a couple of things to be aware of

  1. Ensure that DCOM is enabled on the BI 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.

    Ensurepass 2018 PDF and VCE


    Question No: 32

    Select the scenario in which block storage must be used instead of aggregate storage.

    1. Incremental data loading

    2. Top – down planning

    3. Extremely sparse data sets

    4. Millions of members in the outline

Answer: B

Explanation: BSO is preferred to ASO in the following scenarios:

  • Top-down planning and allocation (Sales Forecasting)

  • Cost Allocations across products and customers (Profitability Analysis)

  • Currency conversion, inter-company eliminations(Financial consolidations)

  • Question No: 33

    What would you use to customize the text elements that appear on BI Analysis, Delivers and Dashboard pages?

    1. Cascading Style Sheets

    2. DHML Message files

    3. XML Message Files

    4. BI Presentation services web template

    Answer: A

    Explanation: You can control the way that the interface for Oracle BI EE is displayed to users by creating skins and styles.

    While skins and styles are typically used to customize the look and feel of analyses and dashboards by providing logos, color schemes, fonts, table borders, and other elements, they can also be used to control the position and justification of various elements by including specialized style tags in the relevant style sheet (.css) file.

    You can check the directory skin location with a right click on a OBIEE dashboard page, select show source code and search “custom.css”.

    Question No: 34

    In the Oracle Data Warehouse Reference Architecture, which term is not a layer in the data


    1. Access and Performance Layer

    2. Master Data Layer

    3. Staging Data Layer

    4. Presentation Data Layer

    Answer: D

    Question No: 35

    Which two options are valid Repository Variable names?

    1. USER

    2. CurrentDay

    3. CurrentMonth

    4. Date

    Answer: B,C

    Explanation: CurrentDay and CurrentMonth can be calculated by a sql statement.



  • Initialized when BI server is started

  • Assigned value dynamically based on the result of a query

  • Value is dependent of the sql provided in Initialization Block

  • Create a dynamic variable and provide a Name and Default Initializer.Create a new initialization block by clicking on the New button in the above screen.

    Ensurepass 2018 PDF and VCE

    http://www.adivaconsulting.com/images/blog/OBIEE_Variable_files/image003.jpg Provide Intialization Block variable Name

    Question No: 36

    One benefit of adding a second table source that is joined to the first table source in the Physical Layer by a foreign key relationship is that .

    1. Multiple SQL queries are performed

    2. Two SQL queries are performed to get data from both tables

    3. A single SQL query is performed to get data from both tables

    4. No SQL queries are performed against the source tables

    Answer: C

    Explanation: A single query can be performed accessing data from both tables through a join on the columns in the foreign key relation.

    Question No: 37

    When creating a Security Realm in the WebLogic Console, which object is created?

    1. Groups

    2. Row Level Filters

    3. Server Password

    4. Single Sign On

    Answer: A

    Explanation: Security Realms are an Oracle Platform Security Services concept and bring together sets of users, groups, providers and so on for a WebLogic domain.

    Question No: 38

    Select the correct statement.

    1. Cache provides fast and always up-to-date information.

    2. Cache can increase traffic to back end database.

    3. Cache needs to be purged to refresh data.

    4. Cache can degrade query performance by reading data from the disk instead of the database.

    5. Cache is seeded by manually running PL/SQL at the back end database.

    Answer: C

    Explanation: In a standard OBIEE implementation, we generally want to purge and re- build the cache after every ETL (extract, transform, and load) run.

    Question No: 39

    A customer has a requirement for rolling period calculations. What two additional steps will need to be done to enable this in the repository?

    1. Clicking the quot;Timequot; option in the Logical Dimension Dialog

    2. Designating a chronological key for every level of every dimension hierarchy

    3. Clicking the quot;Timequot; option in the Logical Table Source Dialog

    4. Designating a chronological key for every logical column in the Logical Table Source

    5. Specifying a sort order in the Logical Table dialog

    Answer: A,B

    Explanation: Creating Logical Time Dimensions

    Compared to modeling an ordinary dimension, the time dimension requires just two additional steps: selecting the Time option in the Logical Dimension dialog, and designating a chronological key for every level of every dimension hierarchy.

    Note: Time dimensions and chronological keys. You can identify a dimension as a time dimension. At least one level of a time dimension must have a chronological key. The following is a list of some guidelines you should use when setting up and using time dimensions:

    Leave a Reply

    This site uses Akismet to reduce spam. Learn how your comment data is processed.