Q1. 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?
A. Test Environment
B. System Testing
C. Performance Tuning
D. Projectinitiation and resourcing
E. Data Validation / Verification
Answer: D
Q2. Which option describes how OBIEE natively integrates with HFM?
A. Through EPM Analytic Data Model (ADM) connectivity
B. Direct relational database access
C. Through Essbase connectivity
D. OBIEE does not support HFM integration
Answer: A
Q3. Which of the following native features of Essbase are not supported in OBIEE 11g?
A. Member Alias
B. Alternate Hierarchies
C. Dynamic Time Series
D. Parent/Child-based Hierarchies
Answer: C
Q4. A derived measure is never used to_________.
A. Calculate share measures
B. Add two logical columns together
C. Calculate a variance between two measures
D. Calculate the rank dimension values
E. Input data
Answer: E
Q5. Where is Cache in OBIEE located?
A. In relational database
B. It is local disk-based.
C. In dynamic aggregate
D. In memory cache
Answer: B
Q6. Where is Oracle Mapviewer installed?
A. In the same domain as OBIEE on the web application server
B. Never on the same domain as OBIEE on the web application server
C. On the Database server
D. On its own application server
Answer: A
Q7. One benefit of adding a second table source that is joined to the first table source in the Physical Layer by a foreign key relationship is that______.
A. Multiple SQL queries are performed
B. Two SQL queries are performed to get data from both tables
C. A single SQL query is performed to get data from both tables
D. No SQL queries are performed against the source tables
Answer: C
Q8. Which task can be performed after the Administrator link has been reached through logging into OBIEE?
A. Associate map layers to columns
B. Manage access to Subject Areas
C. SSO enablement
D. Start or Stop BI Managed Servers
Answer: BCD
Q9. Why is it necessary to join multiple source tables to a single dimension?
A. Because transactional source systems are often denormalized
B. Because transactional source systems are often normalized
C. Because a single source table often contains all the dimensions needed
D. Because the dimensions tables are built in the transactional systems
Answer: A
Q10. Under what circumstances would you model within the BI environment to include transactional data directly?
A. When the customer needs near real-time data to support decision making in a fast changing environment
B. When the customer is not prepared to spend budget on data-warehousing
C. When the complexity of operational schema does not allow modeling in the BI repository
D. When it is not possible to query against a transactional system
Answer: A