1Z1-591 by Oracle Valid Free Exam Practice Test

Question 1

Oracle BI Server at a company is connected to Data Warehouse that is refreshed on a daily basis, the majority of users at the company log in to Oracle BI every Monday to generate the previous week's sales report. The BI Administrator schedules cache purge and cache seeding to improve report response times. How is this accomplished?

A. Every Monday early morning B. Every Monday late night C. Every day after Data Warehouse refresh D. Every day before Data Warehouse refresh

Correct Answer: A

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 2

How do System Session Variables obtain their values?

A. They are obtained from the Initialization Block B. They are obtained from the Presentation Layer C. They are entered by user input on a dashboard D. They are obtained from data fields in the Physical Layer

Correct Answer: A

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 3

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 Requirements Definition B. Data Quality Assessment C. Dashboard Testing D. Technical Requirements Definition

Correct Answer: D

Question 4

DSNs are set up for access to which data sources?

A. IBM Data Sources B. Teradata Data Sources C. Oracle Data Sources D. ODBC Data Sources

Correct Answer: D

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 5

Which task can be performed after the Administrator link has been reached through logging into OBIEE?

A. Associate map layers to columns B. SSO enablement C. Start or Stop BI Managed Servers D. Manage access to Subject Areas

Correct Answer: A

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 6

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 driving table B. By creating your logical join by using the Joins Manager C. By specifying a one-to-many join between the tables with the small and large numbers of values D. By creating your joins by using the Business Model Diagram E. By specifying a many to one join between the tables with the small and large numbers of values

Correct Answer: A

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Oracle Business Intelligence Foundation Suite 11g Essentials - 1Z1-591 Exam Practice Test