Weekend Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Oracle Certification 1z0-591 Passing Score

Page: 7 / 9
Total 120 questions

Oracle Business Intelligence Foundation Suite 11g Essentials Questions and Answers

Question 25

What are the two methodologies that are followed within an OBIEE implementation?

Options:

A.

Do not use prototypes

B.

Use an iterative approach

C.

Start with a small model and then enhance the repository

D.

Start with a big repository and trim it down with the requirements

Question 26

Identify the two true statements about alias tables.

Options:

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.

Question 27

In the Oracle Data Warehouse Reference Architecture, which term is not a layer in the data warehouse?

Options:

A.

Access and Performance Layer

B.

Master Data Layer

C.

Staging Data Layer

D.

Presentation Data Layer

Question 28

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?

Options:

A.

Every day before Data Warehouse refresh

B.

Every day after Data Warehouse refresh

C.

Every Monday early morning

D.

Every Monday late night

Page: 7 / 9
Total 120 questions