1Z0-591 Exam - Oracle Business Intelligence Foundation Suite 11g Essentials

certleader.com

Q1. What are the two types of Repository Variables? 

A. System 

B. Non System 

C. Static 

D. Dynamic 

Answer: CD 

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

A. Creating and Maintaining Users 

B. Authentication and Authorization 

C. Basic Directory for storing user details 

D. Subject area and row-level security, connection pool passwords 

E. Application of SessionVariables as Data Filters 

Answer: ACD 

Q3. Which analysis features could be applied to provide interactive controls for end users? 

A. Column Selector 

B. Action Links 

C. Conditional Formatting 

D. Narrative View 

E. Greenbar Styling 

Answer:

Q4. What are the two disadvantages of implementing Query Caching? 

A. Reduction in BI server processing time 

B. Cache results being old 

C. Storage space for cache 

D. Increased network traffic 

E. Needs a lot of administrators' time 

Answer: BC

Q5. There is a logical fact table that contains Item number, store, time, and revenue. How would you add Number of items sold? 

A. By creating a derived measure on the logical columnItem number and using the count Function 

B. By creating a derived measure on the logical column item number and usingthe count distinct function 

C. By creating a derived measure based on the physical column item number and changing theaggregation method to count 

D. By creatinga derived metric by using the Expression Builder 

Answer:

Q6. Which three options apply to FMW Application Roles? 

A. Provide an indirection between LDAP groups and BI roles 

B. Can be exported / moved between FMW11g environments 

C. Are created and managed by using the WLS Admin Console and FMW Control 

D. Can be created by using BI Administrator Client and "pushed" to WLS Admin Console 

E. Secures RPD permissions but NOT Web Catalog (webcat) permissions 

Answer: ACE

Q7. Cache in OBIEE is used to_____. Select the two correct answers. 

A. improve performance of Dashboards and Analysis 

B. decrease query response time 

C. improve Analysis data quality 

D. eliminate Write Back Capabilities 

E. create Aggregate tables 

Answer: AB

Q8. Which resource identifies the OBIEE Web Catalog (webcat)? 

A. instanceconfig.xml 

B. RCU Schema 

C. Identity Store 

D. nqsconfig.ini 

E. Admin Server 

Answer: CE

Q9. Which two Oracle BI Components contain security information regarding permissions and privileges? 

A. The Web Catalog 

B. The Repository 

C. NQSConfig.ini File 

D. NQServer.ini File 

E. InstanceConfig.xml File 

Answer: BD

Q10. How do System Session Variables obtain their values? 

A. They are entered by user input on a dashboard 

B. They are obtained from data fields in the Physical Layer 

C. They are obtained from the Presentation Layer 

D. They are obtained from the Initialization Block 

Answer: D