Pass4Test  Oracle 1Z0-525 (Oracle Business Intelligence Applications 7.9.6 for ERP Essentials) 시험덤프 구매전 구매사이트에서 무료샘플을 다운받아 PDF버전 덤프내용을 우선 체험해보실수 있습니다. 무료샘플을 보시면 Pass4Test  Oracle 1Z0-525 (Oracle Business Intelligence Applications 7.9.6 for ERP Essentials) 시험대비자료에 믿음이 갈것입니다.고객님의 이익을 보장해드리기 위하여Pass4Test는 시험불합격시 덤프비용전액환불을 무조건 약속합니다. Pass4Test의 도움으로 더욱 많은 분들이 멋진 IT전문가로 거듭나기를 바라는바입니다.

 

 

NO.1 The webcat structure, along with various other presentation parameters are stored in: .?

A. DBFeatures. ini

B. Instanceconfig. xml

C. NQSConfig. ini

D. Repository File (.rpd)

Answer: D

 

NO.2 A new source is available containing several big tables with over 2 million rows of data. Some of this

data is needs in Oracle BI analysis, combind with existing data sources. What are your options to enable

this combined analysis?

A. Analyze the needed data and needed granularity. If applicable create aggregation tables and

partitioned tables in the source database. Apply a type 2 customization in Informatica PowerCenter and

modify the DAC with appropriate objects. Model the BI repository with the new data warehouse objects

and enable aggregate navigation and pertition navigation. Enable cross analysis in the logical layer. Use

simple requests and analyze the request performance on the new data.

B. Apply a type 2 customization in Informatica PowerCenter to include the necessaryt data warehouse

objects and modify the DAC with appropriate objects. Model the Bi repository with the new data

warehouse objects and enable aggregate navigation and partition navigation.

C. Apply a type 1 customization in Informatica PowerCenter to include the necessaryt data warehouse

objects and modify the DAC with appropriate objects. Model the Bi repository with the new data

warehouse objects and enable aggregate navigation and partition navigation. Enable cross-analysis in

the logical layer.

D. Analyze the needed data and needed granularily. If applicable create aggregation tables and

partitioned tables in the source database. Apply a type 1 customization in Informatica PowerCenter and

modify the DAC with appropriate objects. Model the BI repository with the new data warehouse objects

and enable aggregate navigation and partition navigation.

E. Normalize the new data source into smaller tables and apply a type 2 customization in Informatica

PowerCenter. Apply changes in DAC to read the new source data have execution plans load the needed

data into the data warehouse. Model the BI repositorty with the new data warehouse objects and enable

aggregate navigation and partition navigation. Enable cross-analysis in the logical layer.

F. Normalize the new data source into smaller tables and apply a type 1 customization in Informatica

PowerCenter. Model the BI repository with the new data warehouse objects and enable aggregate

navigation and partition navigation. Enable cross-analysis in the logical layer.

Answer: A

 

NO.3 What is the default location where paramether files are created by DAC?

A. $DAC_HOME\Informatica\server\parameters

B. $DAC_HOME\Informatica\parameters

C. $DAC_HOME\ parameters

D. $DAC_HOME\ server\infa_shared\BWParam

Answer: B

 

NO.4 Which is true regarding the location of Informatica PowerCenter client tools installation?

A. the client tools should be installed on the same machine as the transactional database.

B. the client tools should be installed on the same machine as the DAC Server.

C. the client tools should be installed on the same machine as the OBAW database.

D. the client tools should be installed on the same machine as the DAC client.

Answer: D

 

NO.5 Which three variable tu\ype does the BI Applications data model support for specifying currencies?

A. Document

B. Local

C. Global

D. Override

Answer: A, B, C

 

NO.6 How can you be sure to access a specific data source in a default Oracle BI Applications installation for

users working from a client machine? Assume that log level 2 has been enabled.

A. With log level 2 or higer enabled in the NqsConfig. ini, you can check the SQL from the query log of a

specific Answers request. Read the SQL and check the connection pool(s) used and the data source

name(s).

B. The only data source in a standard BI Applications installation is the data warehouse. This source is

defined in DAC in the Setup View under Physical Data Surces. You can alx\so check the (native)

Connection credentials.

C. Sources can range from data wareshouse to OLTP systems. Their connections are named in

connection pools in the BI reposity. Using these connection names you can check the (native) connection

credentials.

D. All physical connections are defined in Informatica Powercenter Repository Manager. Log in and check

all connection credentials.

E. Users can log in to Aswers, the BI repository, DAC or Informatica to check connection credentials and

data source names.

Answer: C

 

NO.7 Which three calendar types are supported by BI Applications 7.9.6 rlease?

A. Enterprise

B. 13 Period, 4-4-5

C. Fiscal and Gregorian

D. 15 Period

Answer: A, B, C

 

NO.8 A large insurance company ABC-Safe uses PeopleSoft and Hyperion Planning & Budgeting for

Financial Analytics and a third-party software package for HR Compensatio. ABC-Safe wants to have a

consolidated picture of its finances and compensation packages. What would you advise?

A. Immediately enhance the existing Oracle BI Financial Application with HR analytics.

B. Perform a fit-gap analysis on the usability of the ETL for HR analytics and cross functionality with

Financial Applications and present a business case for extending the Oracle BI Applications environment

with Oracle BI HR analytics or enhance the existing BI applications environment with HR data by building

the ETL, enhance the BI repository, Reports& Dashboards, security and other needed elements.

C. Oracle BI applications cannot be enhanced by data from third-party software packages.

D. Offer implementing Oracle BI HR Analytics, inckuding a calculation for reusing prebuilt ETL using the

Universal connector.

E. Offer implementing Oracle BI Standard Edition One, including a Compensation warehouse setup in

Warehouse Builder.

Answer: B

 

NO.9 Which condition results in a source record being neglected during incremental load?

A. INTIAL_UPDATE_DATE >= LAST_EXTRACT_DATE

B. LAST_UPDATE_DATE >= LAST_EXTRACT_DATE

C. LAST_UPDATE+DATE >= INITIAL_EXTRACT_DATE

D. LAST_UPDATE_DATE <= LAST_ EXTRACT_DATE

Answer: D

 

NO.10 The universal adpter in Informatica, is used to load data from what two sources?

A. EBS

B. JD Edwards

C. Legacy OLTP Systems

D. Non Oracle Sources

Answer: A,C