Oracle Oracle Certifications 1Z0-591 Questions & Answers

• Question 61:

  When designing a Star Schema, which option does not apply?

  A. The facts are quantifiable.

  B. The fact has several foreign keys that are primary keys in the dimensional table

  C. Fact table is joined to the related dimensional tables.

  D. Dimensional tables are normalized.

  E. Dimensional tables have one attribute primary key as Product_ID for products.

  Correct Answer: D

  Explanation: In a Star Schema the dimensional tables does not need to be normalized. A Snowflake Schema is a modified Star Schema that has normalized the dimensional tables.

• Question 62:

  Identity the three advantages of the BI Server metadata repository.

  A. Mapping of federated data sources to one logical object

  B. Ability to change physical sources without losing reports

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

  D. Three layers support the highest level of security

  Correct Answer: ACD

  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

  Note:

  

• Question 63:

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

  A. Start and Stop BI Services

  B. Build Aggregate Queries

  C. Create Summary Tables

  D. Manage user logins

  Correct Answer: A

  Explanation: Screenshot below.

  

• Question 64:

  The Time Dimension hierarchy is a good example of a__________.

  A. Level-based Time Dimension hierarchy

  B. Ragged Hierarchy

  C. Skip Level Hierarchy

  D. Value-based Hierarchy

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

  *

  to perform aggregate navigation,

  *

  to configure level-based measure calculations,

  *

  users from Dashboard and Answers to drill down from one parent to a child level.

  Special type of level-based dimension are supported:

  *

  Unbalanced (or ragged) and Skip-level hierarchy

  *

  time dimension to provides special functionality for modeling time series data.

• Question 65:

  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?

  A. Business Requirements Definition

  B. Technical Requirements Definition

  C. Data Quality Assessment

  D. Dashboard Testing

  Correct Answer: B

• Question 66:

  Identify the two true statements about alias tables.

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

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

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

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

  Correct Answer: AB

  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:

  (A) * 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.

  (B) * You can rename aliases to make physical and business model easier to understand.

• Question 67:

  DSNs are set up for access to which data sources?

  A. ODBC Data Sources

  B. Oracle Data Sources

  C. IBM Data Sources

  D. Teradata Data Sources

  Correct 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 68:

  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?

  A. Create a physical time table in your database.

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

  C. Create an "Opaque View" in the physical layer that contains the time columns from the fact and map it into your physical model.

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

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

  Correct Answer: AD

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

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

  A. Repository file (rpd)

  B. Embedded WebLogic LDAP server

  C. External directories such as Active Directory using WebLogic and Fusion Middleware's Oracle Platform Security Services framework

  D. BI Presentation Services

  Correct Answer: AB

  Explanation: A: Authentication at the Oracle Business Intelligence Enterprise Edition Layer The Oracle Product Lifecycle Analytics (Oracle PLA) application utilizes the Oracle Business Intelligence Enterprise Edition Layer (OBIEE) layer's platform authentication features. You change the password for the PLMA.RPD repository file using the OBIEE Admin Tool.

  B: LDAP Authentication LDAP authentication is used as an alternative to storing user IDs and passwords in an Oracle BI repository. You can set up the Oracle BI Server to take the user ID and password, and have it then pass the user ID and password to an LDAP server for authentication.

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

• Question 70:

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

  A. Clicking the "Time" option in the Logical Dimension Dialog

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

  C. Clicking the "Time" option in the Logical Table Source Dialog

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

  E. Specifying a sort order in the Logical Table dialog

  Correct Answer: AB

  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:

  *

  At least one level of a time dimension must have a chronological key.

  *

  All time series measures using the AGO, TODATE, and PERIODROLLING functions must be on time levels. AGO, TODATE, and PERIODROLLING aggregates are created as derived logical columns. Reference: Oracle Fusion Middleware Metadata Repository Builder's Guide for Oracle Business Intelligence Enterprise Edition. Working with Logical Dimensions