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

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: 11

One of the most common uses of Dynamic Repository Variables is to setup filters for use in reporting. Which variable below is a valid example of a Dynamic Repository Variable?

  1. Year

  2. Month

  3. Quarter

  4. CurrentMonth

Answer: D

Explanation: 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

    Ensurepass 2018 PDF and VCE


    Click on “Edit Data Source” button and provide the sql to be used for the variable, e.g. select lower(sys_context(#39;USERENV#39;,#39;SESSION_USER#39;))||

    #39;@#39;|| lower(sys_context(#39;USERENV#39;,#39;DB_NAME#39;)) from dual;

    Question No: 12

    WLS Embedded LDAP Server is managed by the Admin Server Console and supports which three options?

    1. Creating and Maintaining Users

    2. Authentication and Authorization

    3. Basic Directory for storing user details

    4. Subject area and row-level security, connection pool passwords

    5. Application of Session Variables as Data Filters

    Answer: A,B,C

    Question No: 13

    Point-and-click generation of case statement logic can be accessed via which option?

    1. Column Formula -gt; Bins tab

    2. Compound Layout

    3. Column Properties -gt; Conditional Format tab

    4. Advanced Tab

    5. Subject Area metrics

    Answer: A

    Explanation: The “Edit Column Formula” dialog box has a second, very tiny tab called, “Bins.” You can use this tab to have OBIEE build a CASE statement for you in a formula (you can also create

    a CASE statement yourself by using one of the functions that appears under “Expressions” if you want). A CASE statement is a lot like an IF-THEN-ELSE statement, except that it’s a little easier to read when you have multiple options. Basically, it puts values in different buckets that you define.

    Note: Figure:

    Ensurepass 2018 PDF and VCE

    Question No: 14

    Which task can be performed after the Administrator link has been reached through logging into OBIEE?

    1. Associate map layers to columns

    2. Manage access to Subject Areas

    3. SSO enablement

    4. Start or Stop BI Managed Servers

    Answer: A

    Explanation: It is asking for Which task (NOT Which Tasks).

    Using Administration (not Administrator) link in OBIEE you can go to #39;Manage Map Data#39; and manage map components.

    Ensurepass 2018 PDF and VCE

    Question No: 15

    Which three techniques are applied to support Failover?

    1. WebLogic Clustering

    2. Universal Installer gt; Scale Out BI System option

    3. OBIEE Clustering

    4. Vertical Scaleout

    Answer: A,B,C

    Explanation: A: OBIEE 11g is centred on WebLogic Server as the underlying application server architecture.

    B: If you want to scale out this infrastructure, you would typically run the OBIEE 11g installer on a second server, and instead of choosing to do a new install, you’d choose to instead scale out the existing BI domain.

    Ensurepass 2018 PDF and VCE


    C: OBIEE Clustering – Approach of Oracle BI Server Load balancing/Failover

    Question No: 16

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

    1. MS Visio

    2. MS Excel

    3. MS Project

    4. MS Word

    Answer: 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

    gt; Installing Individual Oracle BI Components gt;Installing Oracle BI Office Plug-In

    Question No: 17

    A user#39;s BI Home page provides one-click access to which three options?

    1. Create new content

    2. Oracle BI online documentation

    3. Catalog search functionality

    4. Dashboard layout editor

    5. Business model metadata

    Answer: A,B,C

    Explanation: See BI Home Page screenshot below:

    Ensurepass 2018 PDF and VCE

    Note: The BI Home page contains the BI content catalog. Fusion Apps will use OBIEE web catalog to store all shipped reporting and analytics content.

    From the BI home page users can browse and view the entire BI content. The BI catalog

    folder structure will match the Fusion Apps main menu structure. Folder structure would be content driven not technology driven which would enable ease of navigation for fusion Apps users.

    Following content will be available under the BI catalog structure: BI Publisher Reports (regardless of data source)

    OTBI reports amp; dashboards OBIA dashboards amp; scorecards Financial Reporting

    Also, users can do some additional actions from the BI Home page like: Access personal and shared reports, View/ edit BI publisher report schedules, Launch BI tools for advanced actions and create new reports with report wizard.

    New reports created can be saved in BI catalog and added as embedded content within Fusion applications screens or links added to reporting pane. This enables users to extend the prebuilt embedded analytics within Fusion Applications.

    Question No: 18

    A customer needs to have a calculation done prior to aggregating the data. How would you accomplish this?

    1. By creating a derived measure by using the Logical Columns available

    2. By creating a derived measure in the Column Mapping dialog box by using the physical table columns.

    3. By creating a derived measure by using Logic Columns available and changing the aggregation type

    4. By creating a derived metric by using the Expression Builder

    5. By creating a derived metric by using the Calculation Wizard

    Answer: B Explanation:

    Note 1: OBIEE offers two calculation types for measure in the repository: logical


    You can define calculations in either of the following ways:

    • Before the aggregation, in the logical table source.

    • After the aggregation, in a logical column derived from two other logical columns. For example: sum(col A) * sum(col B)

      Note 2: A measure column is a column unlike the baseline column that has a default aggregation rule defined in the Aggregation tab of the Logical Column dialog in the repository.

      Measure columns always calculate the aggregation with which they are defined. Measures need to be defined in a logical fact. Any column with an aggregation rule is a measure.

      Ensurepass 2018 PDF and VCE


      Question No: 19

      Which resource identifies the OBIEE Web Catalog (webcat)?

      1. instanceconfig.xml

      2. RCU Schema

      3. Identity Store

      4. nqsconfig.ini

      5. Admin Server

      Answer: A

      Question No: 20

      The ODBC DSN is never used for .

      1. Initial import of the physical layer metadata on a Windows server

      2. Query execution and data access on a Windows server

      3. Initial import of the physical layer metadata, query execution, and data access on a Windows Server

      4. Changing passwords

      5. Comparing RPDs

      Answer: E

      Explanation: You do not use ODBC DSN to compare repositories.

      Note: When an ODBC based application connects to a database, it connects to a logical name, the Data Source Name (DSN), which identifies the datasource to which it wants to connect.

      Some external repository of configuration information holds the various DSN values that are available, together with the necessary configuration and control information needed by the ODBC driver to establish a connection and manage usage of the data source.

      The DSN (data source name) is a data structure that contains the information about a specific data source (database, …), typically used by an ODBC driver to be able to connect to it.

      The DSN contains information about the data source such as:

      the name, the directory,

      and the driver.

      On Windows, the DSN also specifies the ODBC driver to be used to access the database.

      100% Ensurepass Free Download!
      Download Free Demo:1z0-591 Demo PDF
      100% Ensurepass Free Guaranteed!
      1z0-591 Dumps

      EnsurePass ExamCollection Testking
      Lowest Price Guarantee Yes No No
      Up-to-Dated Yes No No
      Real Questions Yes No No
      Explanation Yes No No
      PDF VCE Yes No No
      Free VCE Simulator Yes No No
      Instant Download Yes No No

Leave a Reply

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