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

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

Identify the two Object level security functions that are done on the repository by using the BI Admin tool.

  1. Assign users to a web catalog group

  2. Create a new repository group

  3. Create a new user in the repository

  4. Create a web catalog group

  5. Define permissions for Dashboard

Answer: B,C

Explanation: The Oracle Business Intelligence (BI) Administration Tool can be used to build, modify, enhance, and manage an Oracle BI repository.

C: To add a new user to a repository

  1. Open a repository in the Administration Tool.

  2. Display the security manager by selecting Manage gt; Security. 3 Select Action gt; New gt; User to open the User dialog box.

  1. Type a name and password for the user.

  2. If you want to log queries for this user in the query log, change the query logging level to 1 or 2.

  3. Click OK.

This creates a new user with default rights granted to it.

Note: What is Oracle BI Admin Tool/Oracle Business Intelligence Administration Tool?

Oracle Business Intelligence Administration Tool is Used to manage OBIEE server Available only for Windows operating systems.

A Windows application that allows the BI Server administrator to create amp; edit repositories. Can edit repositories in either online or offline mode.

Having a session manager and a cache manager in online mode.

Question No: 52

OBIEE 11g authentication of users is performed by which two components listed below?

  1. Repository file (rpd)

  2. Embedded WebLogic LDAP server

  3. External directories such as Active Directory using WebLogic and Fusion Middleware#39;s Oracle Platform Security Services framework

  4. BI Presentation Services

Answer: B,C

Reference: Oracle Product Lifecycle Analytics, Security Guide , Configuring and Using


Question No: 53

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?

  1. Business Requirements Definition

  2. Technical Requirements Definition

  3. Data Quality Assessment

  4. Dashboard Testing

Answer: B

Question No: 54

Identify the two true statements about alias tables.

  1. Alias tables are set up to avoid triangular or circular joins.

  2. Alias tables are set up to include best practice naming conventions for physical table names.

  3. Alias tables are set up to create another physical copy of the data.

  4. Alias tables are set up to create a copy of the data with a filter applied to it.

Answer: A,B

Explanation: It is a best practice to create aliases for all tables. Aliases are created in the Physical Layer of the repository. Some of the benefits of using aliases are given below:

  1. * An alias is used to avoid circular joins and to configure self joins.

  • You can create a join relationship which is different than the actual foreign key relationship in the database. This helps in defining relationships to meet business model criteria.

  • Aliases can function in numerous ways to define business model e.g. a table can act both as a dimension and a fact using aliases.

    1. * You can rename aliases to make physical and business model easier to understand.

    Question No: 55

    DSNs are set up for access to which data sources?

    1. ODBC Data Sources

    2. Oracle Data Sources

    3. IBM Data Sources

    4. Teradata Data Sources

    Answer: A

    Explanation: The principal connection to an OBI Server inside the Oracle BI System is made through an Odbc Connection.

    OBI Server can handle multiple repository but you can connect to only one at the same time by DSN Odbc Connection. Therefore, you must set up an ODBC connection for each repository.

    Question No: 56

    You do not have a physical time table in your database but would like to use the time series functions that OBIEE offers. What two options do you have?

    1. Create a physical time table in your database.

    2. Create a Logical Table that is sourced from the time key in the fact table.

    3. Create an quot;Opaque Viewquot; in the physical layer that contains the time columns from the fact and map it into your physical model.

    4. Create a Logical Table that is sourced from a time field in one of your dimension tables.

    5. Create a time table that is joined through a intervening Table so there is no foreign key relationship.

    Answer: A,D

    Explanation: Modeling Time Series Function in OBIEE

    Modeling Time Series Data

    Time series functions provide the ability to compare business performance with previous time periods, allowing you to analyze data that spans multiple time periods. For example, time series functions enable comparisons between current sales and sales a year ago, a month ago, and so on.

    Because SQL does not provide a direct way to make time comparisons, you must model time series data in the Oracle BI repository. First, set up time dimensions based on the period table in your data warehouse. Then, you can define measures that take advantage of this time dimension to use the AGO, TODATE, and PERIODROLLING functions.

    Question No: 57

    Identity the three advantages of the BI Server metadata repository.

    1. Mapping of federated data sources to one logical object

    2. Ability to change physical sources without losing reports

    3. Little changes in the physical layer to shift from development to production environment

    4. Three layers support the highest level of security

    Answer: A,C,D

    Explanation: A: OBIEE Federated Repository

    Instead of moving data in to a single database, OBIEE – BI Administration can access multiple databases and create a single federated repository.OBIEE BI Answer uses this federated repository and build the ad-hoc reports and dashboards.

    D: Repository Metadata Consists of 3 Layers

    • The Physical Layer (Schema)

    • The Business Model and Mapping Layer

    • The Presentation Layer


    Ensurepass 2018 PDF and VCE

    star schema

    Question No: 58

    The WebLogic Console will allow you to perform which of the following functions in the BI Managed Server?

    1. Start and Stop BI Services

    2. Build Aggregate Queries

    3. Create Summary Tables

    4. Manage user logins

    Answer: A

    Explanation: Screenshot below.

    Ensurepass 2018 PDF and VCE


    Question No: 59

    The Time Dimension hierarchy is a good example of a .

    1. Level-based Time Dimension hierarchy

    2. Ragged Hierarchy

    3. Skip Level Hierarchy

    4. Value-based Hierarchy

    Answer: A

    Explanation: Level-based Hierarchy

    Level-based hierarchy is the first type of hierarchy in OBIEE.

    Consists of an ordered set of two or more levels. For example, a Time hierarchy might have three levels for Year, Quarter, and Month. Level-based hierarchies can also contain parent-child relationships.

    Dimension hierarchy levels allow :

    Leave a Reply

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