Q1. The administration tool is the developer's interface to the repository file. It allows the development of and changes to the metadata repository file. Which statement is true?
A. Changes to the repository can only be carried out in offline mode.
B. Multiple developers can work on one repository at the same time.Results can be merged later on.
C. All aspects of security are being held in the repository file.
D. Opening the rpd.filein online mode results in performance Issues for the application user.
Answer: B
Q2. The highest sales amount for this year is $10,000. If you create a rank measure for sales this year and display it on a report, the value will be________.
A. $10,000
B. 0
C. 1
D. Year
Answer: C
Q3. 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
Answer: A
Q4. A customer needs to do a cross database join between two tables where, one of the tables has a small number of values and the other has a large number of values. How can you optimize the way the BI Server processes the query?
A. By specifying a one-to-many join between the tables with the small and largenumbers of values
B. By specifyingadriving table
C. By specifying a many to one join between the tables with the small and large numbers of values
D. By creating your logical join by using theJoins Manager
E. By creating your joins by using the Business Model Diagram
Answer: B
Q5. Query limits tab can be accessed through________.
A. Security Manager, Query tab, Application role dialog box, Permissions
B. Security Manager, Application Roles tab, Query dialog box, Permissions
C. Security Manager, Application Roles tab, Application role dialog box, Permissions
D. Security Manager, Application Roles tab, Application role dialog box, Query Properties
Answer: C
Q6. What must be purchased when integrating Oracle map with Oracle BI?
A. Oracle Mapviewer
B. Oracle Business Intelligence Enterprise Edition
C. Spatial Option with Database
D. OLAP option
Answer: A
Q7. 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
Q8. To add multiple sources to on existing logical table dimension in the Business Model and Mapping layer, the source of the data must first exist in which option?
A. Presentation Layer
B. Business Aggregate Layer
C. PhysicalLayer
D. WebCatalog
Answer: C
Q9. One of the initial phases in OBIEE implementation is the Discovery phase where the project team focuses on a few activities. Which option is not one of them?
A. Business RequirementsDefinition
B. Technical Requirements Definition
C. Data Quality Assessment
D. DashboardTesting
Answer: B
Q10. When Exporting an Analysis from a Dashboard, which of the following is NOT an option?
A. MS Excel
B. MS Word
C. PDF
D. CSV
Answer: B
Q11. Identity the three advantages of the BI Server metadata repository.
A. Mapping of federated data sources to one logical object
B. Ability to change physical sources without losing reports
C. Little changes in the physical layer to shiftfrom development to production environment
D. Three layers support the highest level of security
Answer: ACD
Q12. Oracle BI Server cache setup information is configured by using Enterprise Manager Fusion Middleware control. Which component stores the configuration Information?
A. NQSConfig.ini
B. Cache table inOBIEErepository
C. WebCatalogue
D. Instanceconfig.xml
Answer: A
Q13. A customer frequently queries multiple dimension tables without a measure. What needs to be defined in the presentation layer?
A. Logical Key
B. ImplicitFact Column
C. Alias
D. Logical Column Name
E. CustomDisplay Name
Answer: D
Q14. 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
Q15. Which variable does not use initialization blocks to initialize its values?
A. Static Repository Variable
B. Dynamic Repository Variable
C. System Variable
D. Non System Variable
Answer: A
Q16. Which option is not an example of a level-based measure?
A. Regional Revenue
B. Sales
C. Brand Cost
D. Employee Salary
Answer: C
Q17. How do Dynamic Repository Variables differ from Static Repository Variables?
A. Dynamic Repository Variables are not initialized by the Initialization Block.
B. Dynamic Repository Variables cannot be used in the Expression Builder.
C. Dynamic Repository Variables can be changed by data that is returned from queries.
D. Dynamic Repository Variables cannot be used in a CASE statement.
Answer: C
Q18. What are the two capabilities that users can apply to an Analysis when working within Plug-In for MS Office?
A. Edit Analysis
B. Refresh All
C. Edit Prompts and Levels
D. Publish
Answer: BC