Online Access Free 1Z1-591 Practice Test

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

• A.By creating a derived measure by using the Logical Columns available
• B.By creating a derived metric by using the Calculation Wizard
• C.By creating a derived measure in the Column Mapping dialog box by using the physical table columns.
• D.By creating a derived measure by using Logic Columns available and changing the aggregation type
• E.By creating a derived metric by using the Expression Builder

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

• A.Repository file (rpd)
• B.External directories such as Active Directory using WebLogic and Fusion Middleware's Oracle Platform Security Services framework
• C.BI Presentation Services
• D.Embedded WebLogic LDAP server

Which option describes how OBIEE Integrates with Planning?

• A.OBIEE primarily accesses Planning using standard Essbase integration techniques.
• B.Planning is not a supported OBIEE source.
• C.OBIEE provides complete access to all Planning data through the Analytic Data Model (ADM) layer.
• D.OBIEE integrates with Planning directly through relational database access.

Object Security controls access to Subject Areas, Tables, and Columns in OBIEE and can be implemented by using which method?

• A.External Table Authentication
• B.Single Sign-On (SSO)
• C.Database Authentication
• D.Business Logic Object Security
• E.LDAP Authentication

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

• A.Dimensional tables have one attribute primary key as Product_ID for products.
• B.The facts are quantifiable.
• C.The fact has several foreign keys that are primary keys in the dimensional table
• D.Dimensional tables are normalized.
• E.Fact table is joined to the related dimensional tables.