[Free] 2018(Jan) EnsurePass Examcollection Oracle 1z0-591 Dumps with VCE and PDF 41-50

2018 Jan Oracle Official New Released 1z0-591
100% Free Download! 100% Pass Guaranteed!

Oracle Business Intelligence Foundation Suite 11g Essentials

Question No: 41

Pre Deployment sign-off is a milestone for a OBIEE implementation and is based on successful completion of certain tasks. Which option is not one of them?

  1. Test Environment

  2. System Testing

  3. Performance Tuning

  4. Project initiation and resourcing

  5. Data Validation / Verification

Answer: D

Question No: 42

How will you model a Type II Slowly-Changing Dimension?

  1. Add an additional column to the dimension table to capture a version of change

  2. Overwrite an existing dimension table record with the changed record

  3. Add a new row to the dimension table with a new key for the changed record

  4. Do Nothing

Answer: C

Explanation: Dimensional Modeling – Slowly Changing Dimensions

  • Type 1 – Overwrite Original Value A change does not require tracking

  • Type 2 – Add a new record

    With Type II SCD, a new version of the dimension record (row) is created, and the existing version is marked as history.

    Each row does not correspond to a different instance of an entity but a different “state”, a “snapshot” of the instance at a point in time.

    Note: Tracking changes in dimension is referred in datawarehousing as slowly changing dimensions.

    In the source system a lot of changes are daily made : new customers are added,

    addresses are modified,

    new regional hierarchies are implemented,

    or simply the product descriptions and packaging change.

    These sorts of changes need to be reflected in the dimension tables and in several cases, the history of the changes also needs to be tracked.

    By remembering history, we are then able to look at historical data and compare it to their current situation.

    Question No: 43

    Cache in OBIEE is used to . Select the two correct answers.

    1. improve performance of Dashboards and Analysis

    2. decrease query response time

    3. improve Analysis data quality

    4. eliminate Write Back Capabilities

    5. create Aggregate tables

    Answer: A,B

    Explanation: Decrease query response time which will improve performance for Dashboards and Analysis.

    Question No: 44

    A customer frequently queries multiple dimension tables without a measure. What needs to be defined in the presentation layer?

    1. Logical Key

    2. Implicit Fact Column

    3. Alias

    4. Logical Column Name

    5. Custom Display Name

    Answer: B

    Explanation: Metadata Repository Builder#39;s Guide http://download.oracle.com/docs/cd/E21764_01/bi.1111/e10540/toc.htm http://download.oracle.com/docs/cd/E21764_01/bi.1111/e10540.pdf

    Setting an Implicit Fact Column in the Subject Area

    For each subject area in the Presentation layer, you can set an implicit fact column. The implicit fact column is added to a query when it contains columns from two or more dimension tables and no measures. The column is not visible in the results. It is used

    to specify a default join path between dimension tables when there are several possible alternatives or contexts.

    Question No: 45

    A customer needs to do a cross database join between two tables where, one of the tables has a small number of values and the other has a large number of values. How can you optimize the way the BI Server processes the query?

    1. By specifying a one-to-many join between the tables with the small and large numbers of values

    2. By specifying a driving table

    3. By specifying a many to one join between the tables with the small and large numbers of values

    4. By creating your logical join by using the Joins Manager

    5. By creating your joins by using the Business Model Diagram

    Answer: B

    Explanation: You can specify a Driving table parameter in a complex join.

    Driving tables are for use in optimizing the manner in which the Oracle BI Server processes cross-database joins when one table is very small and the other table is very large.

    The BI Server will query the driving table (the small one) and will get a list of values. The BI Server will then generate a second SQL using a parameterized IN list with the values from the first query.

    Specifying driving tables leads to query optimization only when the number of rows being selected from the driving table is much smaller than the number of rows in the table to which it is being joined.

    Question No: 46

    Why is it necessary to join multiple source tables to a single dimension?

    1. Because transactional source systems are often denormalized

    2. Because transactional source systems are often normalized

    3. Because a single source table often contains all the dimensions needed

    4. Because the dimensions tables are built in the transactional systems

    Answer: B

    Explanation: Denormalized data in the transactional system could be divided into different tables to increase performance.

    Question No: 47

    Query Limits are used to manage Query environment in the repository for users and roles and can .

    1. Control runaway queries

    2. Limit Queries by maximum run time

    3. Control aggregation

    4. Control User Authentication

    5. Control Write Back Capabilities

    Answer: B

    Explanation: Query Limits. You can limit queries by the number of rows received, by maximum run time, and by restricting to particular time periods. You can also allow or disallow direct database requests or the Populate privilege.

    See figure below.

    Ensurepass 2018 PDF and VCE


    Question No: 48

    A derived measure is never used to .

    1. Calculate share measures

    2. Add two logical columns together

    3. Calculate a variance between two measures

    4. Calculate the rank dimension values

    5. Input data

    Answer: E

    Question No: 49

    What are the two types of Session Variables?

    1. System

    2. Non System

    3. Static

    4. Dynamic

    Answer: A,B

    Explanation: There are two types of session variables:

    System – A session variable that the Oracle BI Server and Oracle BI Presentation Services use for specific purposes.

    System session variables have reserved names that cannot be used for other kinds of variables (such as static or dynamic repository variables and non-system session variables).

    Non-system – A system variable that the administrator creates and names. For example, the administrator might create a SalesRegion non-system variable that initializes the name of a user#39;s sales region.

    The administrator creates non-system session variables using the Oracle BI Administration Tool.

    Note: Session Variables

    A session variable is a variable that is initialized at login time for each user. When a user begins a session, the Oracle BI Server creates a new instance of a session variable and initializes it.

    There are as many instances of a session variable as there are active sessions on the Oracle BI Server. Each instance of a session variable could be initialized to a different value.

    Question No: 50

    Content that is saved in personal and shared folders can be browsed by using which view?

    1. Catalog

    2. Dashboard

    3. New -gt; Analysis

    4. Home

    5. Favorites

    Answer: A

    Explanation: The Catalog Manager workspace enables you to view and work with catalog objects. It displays the following folders for an open catalog:

    The shared folder- Contains content that is shared among catalog users. This includes the preconfigured dashboards and analyses that are distributed with prebuilt applications, and other objects such as shared filters.

    The system folder – Contains administrative elements of Presentation Services. Some of these elements are distributed with the product, and others are configured by you as the administrator, such as privileges. Avoid modifying any files in this folder. Presentation Services uses these files internally and modifying them might cause unexpected results.

    The users folder – Contains content that catalog users with the appropriate permissions have saved to their personal folders, such as individual analyses.

    Reference: Oracle Fusion Middleware System Administrator#39;s Guide for Oracle Business Intelligence Enterprise Edition, What Does the Catalog Manager Workspace Look Like?

    100% Free Download!
    Download Free Demo:1z0-591 Demo PDF
    100% Pass Guaranteed!
    Download 2018 EnsurePass 1z0-591 Full Exam PDF and VCE

    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

    2018 EnsurePass IT Certification PDF and VCE

  • Leave a Comment


    Your email address will not be published. Required fields are marked *