Free Oracle 1Z1-591 Exam Dumps Questions & Answers

A customer wants to analyze the efficiency of his/her order fulfillment process. If the customer has a dimensional model, which option is the fact table?

• A.Stores
• B.Products
• C.Orders
• D.Time

Oracle BI Server cache setup information is configured by using Enterprise Manager Fusion Middleware control. Which component stores the configuration Information?

• A.Instanceconfig.xml
• B.Web Catalogue
• C.Cache table in OBIEE repository
• D.NQSConfig.ini

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

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

WLS Embedded LDAP Server is managed by the Admin Server Console and supports which three options?

• A.Authentication and Authorization
• B.Application of Session Variables as Data Filters
• C.Basic Directory for storing user details
• D.Subject area and row-level security, connection pool passwords
• E.Creating and Maintaining Users

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

• A.Because transactional source systems are often denormalized
• B.Because the dimensions tables are built in the transactional systems
• C.Because transactional source systems are often normalized
• D.Because a single source table often contains all the dimensions needed