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

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

Identify the two types of storage for Essbase.

  1. Aggregate Storage Option and Block Storage Option

  2. Aggregate Storage and Cell Storage

  3. OLAP Storage and Cell Storage

  4. Aggregate Storage and Hybrid Columnar Compression

Answer: A

Explanation: Oracle Essbase developers creating planning and budgeting applications have been keenly aware of the advantages and disadvantages of the two different storage types available to them:

  • Block storage option (BSO) databases support a wide range of calculations, including forecasts, allocations, and aggregations through procedural calculation scripts. The results of these calculations can be written back to the database, but applications that use BSO storage are limited to about 10 dimensions and member counts in the low hundreds of thousands.

  • Aggregate storage option (ASO) databases can support about 20 dimensions and member counts in the millions. ASO databases use multidimensional functions rather than procedural scripts to perform calculations, but the results of queries cannot be stored back in the database, making ASO unsuitable for most financial management applications.

    Question No: 72

    Where is Cache in OBIEE located?

    1. In relational database

    2. It is local disk-based.

    3. In dynamic aggregate

    4. In memory cache

    Answer: B

    Explanation: In OBIEE cache will be stored as files on the Hard Disk of the OBIEE Server in the form of files.

    Question No: 73

    A customer always wants Aggregate Table l to be looked at first to see if it can answer the query. What should be done to make sure this happens?

    1. Make Aggregate Table 1 the first table in the list of Logical Table Sources.

    2. Do not map the logical level in the Content tab.

    3. Set the Priority Group to 0.

    4. Set the Priority Croup to 5.

    Answer: C

    Explanation: Priority group

    You can set priority group numbers to determine which logical table source should be used for queries for which there is more than one logical table source that can satisfy the requested set of columns.

    For example, you might have user queries that can be fulfilled by both a data warehouse and an OLTP source. Often, access to an operational system is “expensive,” while access to a data warehouse is “cheap.” In this situation, you can assign a higher priority to the data warehouse to ensure that all queries are fulfilled by the data warehouse if possible.

    Note that the priority group of a given logical table source does not always ensure that a particular query will be fulfilled by that source.

    Priority Group Designation

    0 the highest-priority source (the default) 1 a lowest-priority source

    Question No: 74

    Which OBIEE capability enables developers to build Aggregate tables?

    1. Aggregate Persistence Wizard

    2. Expression Builder

    3. Table Builder

    4. Query Analyzer

    Answer: A

    Explanation: Aggregate Persistence Wizard automates the creation and initial population of aggregates, persists them in a back-end database and configures the BI Server metadata layer so that they’re used when appropriate.

    Question No: 75

    When creating a new dimensional hierarchy in the BI Administration tool, right click the dimension, then select quot;New Objectquot; What must be selected next?

    1. Logical Key

    2. Parent Level

    3. Child Level

    4. Dynamic Key

    Answer: B

    Explanation: Steps to Create a Dimension Hierarchy – gt;Create a dimension object.Add a parent-level object.Add child-level objects.Determine number of elements.Specify level columns.Create level keys.Create a level-based measure.Create additional level-based measures.Create share measures.Create rank measures.Add measures to Presentation layer.Test share and rank measures.

    Question No: 76

    What are the two types of Repository Variables?

    1. System

    2. Non System

    3. Static

    4. Dynamic

    Answer: C,D

    Explanation: There are static and dynamic repository variables.


    Variables in the Oracle BI Server can be either repository or session variables, and are defined using the Variable Manager within the Oracle BI Administrator (Manage gt; Variables).

    Ensurepass 2018 PDF and VCE


    This brings up the Variable Manager, that divides variables out into repository and session variables, with a further subdivision into static and dynamic repository ones and system and non-system session ones. You can also define variables at the Presentation Server level, these are scoped to individual dashboards and are used amongst other things for setting dashboard prompt values and integrating the dashboard with BI Publisher parameters. Here’s a screenshot of a typical Variable Manager screen.

    Ensurepass 2018 PDF and VCE


    Question No: 77

    Under what circumstances would you model within the BI environment to include transactional data directly?

    1. When the customer needs near real-time data to support decision making in a fast changing environment

    2. When the customer is not prepared to spend budget on data-warehousing

    3. When the complexity of operational schema does not allow modeling in the BI repository

    4. When it is not possible to query against a transactional system

    Answer: A

    Question No: 78

    What are the two capabilities that users can apply to an Analysis when working within Plug- In for MS Office?

    1. Edit Analysis

    2. Refresh All

    3. Edit Prompts and Levels

    4. Publish

    Answer: B,C

    Explanation: B: Click Refresh All from the Oracle BI menu in PowerPoint to refresh all the refreshable objects in the presentation.

    C: Right-click Table and select Insert as List from the shortcut menu. The Edit Prompts and Levels dialog box appears. Accept the default options and click Insert.

    Ensurepass 2018 PDF and VCE

    http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/biee/r1013/bi_addin/ima ges/t20105a.gif

    Reference: Using Oracle Business Intelligence Office Add-Ins with Oracle Business Intelligence Enterprise Edition ( on Windows

    Question No: 79

    Which three components are part of a cluster server?

    1. Master Server

    2. Repository Publishing Directory

    3. Primary Cluster Controller

    4. Web Server

    5. Server request Controller

    Answer: A,C,D

    Explanation: Oracle BI Cluster Server Components

  • Oracle Business Intelligence Cluster Controller: The Cluster Controller determines which BI Server works in the cluster. It monitors the operation of servers in the cluster. The Cluster Controller is deployed in active-passive mode.

  • Clustered BI Servers: The BI Cluster Server feature supports up to 16 BI Servers in a network domain to act as a single server. BI Servers in the cluster share requests from multiple Oracle BI clients.

  • Master BI Server: A clustered Oracle Business Intelligence Server is designated as the Master BI Server. The Oracle Business Intelligence Administration Tool connects to the master BI Server for online repository changes.

  • Cluster Manager: The Cluster Manager is available in the Administration Tool when a repository is opened in online mode. The Cluster Manager enables Oracle BI Server clustered instances.

  • Question No: 80

    If Security attributes conflict, what happens?

    1. The user or application role is granted the minimum security attribute

    2. The user or application role is granted the maximum security attribute

    3. The user or application role is granted No security attribute

    4. The user or application role is granted the Fully Restrictive security attribute

    Answer: A

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

    security attribute.

    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.