Proper study guides for Renovate Oracle Oracle Business Intelligence Foundation Suite 11g Essentials certified begins with Oracle 1Z0-591 preparation products which designed to deliver the Real 1Z0-591 questions by making you pass the 1Z0-591 test at your first time. Try the free 1Z0-591 demo right now.

Q25. When a customer wants to get sales numbers by day, how is data stored in the Star Schema, if the data is loaded nightly? 

A. The lowest level of aggregation 

B. The highest level of aggregation 

C. Multiple levels of aggregation 

D. Independently from aggregation level 

Answer: B 


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


Q27. Identify the two true statements about alias tables. 

A. Alias tables are set up to avoid triangular or circular joins. 

B. Alias tables are set up to include best practice naming conventions for physical table names. 

C. Alias tables are set up to create another physical copy of the data. 

D. Alias tables are set up to create a copy of the data with a filter applied to it. 

Answer: B


Q28. When creating an initialization Block, which BI Administration function is used? 

A. Variable Manager 

B. Job Manager 

C. Identity Manager 

D. Projects Manager 

Answer: A


Q29. How do you get the BI plug-in for MS Office? 

A. By contacting the administrator 

B. By downloading it from the BI Server 

C. By downloading it from the Database Server 

D. By downloading it from Microsoft Server 

Answer: B


Q30. What is the first step when creating an Aggregate table in the OBI repository? 

A. Test the Aggregate table by using Analysis 

B. Specify the Fact table that you want to aggregate 

C. Use Job Manager to run the Aggregate script 

D. Create a dedicated Connection Pool 

Answer: B


Q31. Which two steps are needed to set up Failover support for an OBIEE deployment? 

A. Use Installer to affect Horizontal scale out of an existing instance 

B. Employ WebLogic Enterprise Edition, licensed separately 

C. Use Installer to set up separate single instances, then apply Horizontal scale out clustering 

D. Apply OBIEE Clustering option 

E. Leverage spare hardware capacity of single machine by using Verticalscale out option 

Answer: AD


Q32. Which Oracle Partner is the supplier of map-based content to provide background maps, boundary information, and points of interest? 

A. Navteq 

B. TeleAtlas 

C. Google 

D. ESRI 

Answer: C