1Z0-591 Premium Bundle

1Z0-591 Premium Bundle

Oracle Business Intelligence Foundation Suite 11g Essentials Certification Exam

4.5 
(25170 ratings)
0 QuestionsPractice Tests
0 PDFPrint version
November 5, 2024Last update

Oracle 1Z0-591 Free Practice Questions

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:

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:

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:

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:

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:

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

START 1Z0-591 EXAM