Q1. There are two aggregate tables that are available for query. How would they be mapped into the logical data model so queries can use them? 

A. By creating two new logical tables sources 

B. By opening the two logical Table Source dialog boxes and mapping the appropriate levels in the Content tab 

C. Both Aand B 

D. By creating one new LogicalTableSource 

View Answer

Q2. 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 

View Answer

Q3. OBIEE default security model stores security Information such as user names and password combinations for accessing an external system such as Active Directory. It is stored in the____________. 

A. Policy Store 

B. Credential Store 

C. Identity Store 

D. Person Store 

View Answer

Q4. One of the most common uses of Dynamic Repository Variables is to setup filters for use in reporting. Which variable below is a valid example of a Dynamic Repository Variable? 

A. Year 

B. Month 

C. Quarter 

D. CurrentMonth 

View Answer

Q5. The WebLogic Repository Schema generated via RCU can be deployed to which three DBMS? 

A. Oracle RDBMS 

B. Microsoft SQL Server 

C. IBMDB2 

D. Teradata 

View Answer

Q6. Which three techniques are applied to support Failover? 

A. WebLogic Clustering 

B. Universal Installer > Scale Out BI System option 

C. OBIEE Clustering 

D. Vertical Scaleout 

View Answer

Q7. Which option describes how OBIEE Integrates with Planning? 

A. OBIEE primarily accesses Planning using standard Essbase integration techniques. 

B. OBIEE provides complete access to all Planning data through the Analytic Data Model (ADM) layer. 

C. Planning is not a supported OBIEE source. 

D. OBIEEintegrates with Planning directly through relational database access. 

View Answer

Q8. What would you use to customize the text elements that appear on BI Analysis, Delivers and Dashboard pages? 

A. Cascading Style Sheets 

B. DHMLMessage files 

C. XMLMessage Files 

D. BI Presentation services web template 

View Answer

Q9. What is an example of a Session Variable? 

A. ETL Load Date 

B. User Organization 

C. OLAP DSN 

D. Top Customers by Revenue 

View Answer

Q10. When creating a query. Subject areas can be combined via point and click as long as____. 

A. the subject areas share objects of the same name 

B. the subject areas both share the same model in the business model and mapping layer 

C. the subject areas are both from the same physical source, though they may be in separate business layers 

D. two or more subject areas cannot be joined together without manually mapping the contents 

View Answer