최신 1z0-591 무료덤프 - Oracle Business Intelligence Foundation Suite 11g Essentials

문제1

Identify the two types of storage for Essbase.

A. OLAP Storage and Cell Storage

B. Aggregate Storage and Cell Storage

C. Aggregate Storage and Hybrid Columnar Compression

D. Aggregate Storage Option and Block Storage Option

정답: D

설명: (DumpTOP 회원만 볼 수 있음)

문제2

A company's Database Administrator has divided the region table into two tables so that the region "West" is in one table and all the other regions are in another single table. What kind of partition is being used?

A. Mixed

B. Complex

C. Time-based

D. Fact-based

정답: B

설명: (DumpTOP 회원만 볼 수 있음)

문제3

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 creating your logical join by using the Joins Manager

B. By creating your joins by using the Business Model Diagram

C. By specifying a driving table

D. By specifying a one-to-many join between the tables with the small and large numbers of values

E. By specifying a many to one join between the tables with the small and large numbers of values

정답: C

설명: (DumpTOP 회원만 볼 수 있음)

문제4

One of the most common uses of Dynamic Repository Variables is to setup filters for use in reporting. Which variable below is a valid example of a Dynamic Repository Variable?

A. CurrentMonth

B. Year

C. Month

D. Quarter

정답: A

문제5

Query limits tab can be accessed through________.

A. Security Manager, Application Roles tab, Application role dialog box, Permissions

B. Security Manager, Application Roles tab, Application role dialog box, Query Properties

C. Security Manager, Query tab, Application role dialog box, Permissions

D. Security Manager, Application Roles tab, Query dialog box, Permissions

정답: A

설명: (DumpTOP 회원만 볼 수 있음)

문제6

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

B. 0

C. $10,000

D. Year

정답: A

설명: (DumpTOP 회원만 볼 수 있음)

문제7

Which three components are part of a cluster server?

A. Web Server

B. Repository Publishing Directory

C. Primary Cluster Controller

D. Server request Controller

E. Master Server

정답: A,C,E

설명: (DumpTOP 회원만 볼 수 있음)

문제8

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

정답: A

설명: (DumpTOP 회원만 볼 수 있음)

문제9

The Time Dimension hierarchy is a good example of a__________.

A. Value-based Hierarchy

B. Level-based Time Dimension hierarchy

C. Ragged Hierarchy

D. Skip Level Hierarchy

정답: B

설명: (DumpTOP 회원만 볼 수 있음)

문제10

One benefit of adding a second table source that is joined to the first table source in the Physical Layer by a foreign key relationship is that______.

A. A single SQL query is performed to get data from both tables

B. Multiple SQL queries are performed

C. No SQL queries are performed against the source tables

D. Two SQL queries are performed to get data from both tables

정답: A

설명: (DumpTOP 회원만 볼 수 있음)

최신 1z0-591 무료덤프 - Oracle Business Intelligence Foundation Suite 11g Essentials

우리와 연락하기

유용한 링크

최신 업데이트