Oracle 1Z0-525 Online Practice Questions and Exam Preparation

Oracle 1Z0-525 Online Questions & Answers

• Question 1:

  Which three attributes identify a single set of books?

  A. Chart of accounts
  B. Currency
  C. Calendar definition
  D. Company name or identifier
  A. Chart of accounts
  B. Currency
  C. Calendar definition

• Question 2:

  What is the default location where parameter files are created by DAC?

  A. $DAC_HOME\Informatica\server\parameters
  B. $DAC_HOME\Informatica\parameters
  C. $DAC_HOME\parameters
  D. $lNFA_HOME\server\infa_shared\BWParam
  B. $DAC_HOME\Informatica\parameters

• Question 3:

  Which is the right sequence of a typical Informatica Type 1 Customization?

  i) Extend Staging and target Database table to accommodate new column.

  ii) Copy appropriate Informatica mapping and workflow to Informatica Custom folder.

  iii) Modify the existing Informatica mapping workflow to accommodate new columns.

  iv) Modify DAC with the necessary change.

  A. i, ii, in, iv
  B. i, iii, ii, iv
  C. iii, ii, i, iv
  D. ii, i, iii, iv
  B. i, iii, ii, iv

• Question 4:

  What is the purpose of csv files under the SrcFiles folder in Informatica server home?

  A. They are used to store Informatica parameters.
  B. They are the source for enterprise-dependent data, required for loading certain dimensions.
  C. They are used to hold data extracted during ETL processes.
  D. They are used for customization.
  A. They are used to store Informatica parameters.

• Question 5:

  During which phase of the Oracle BI Applications project flow are decision makers interviewed for the first time?

  A. Design
  B. Build
  C. Define
  D. Validate
  A. Design

• Question 6:

  To enable SSO integration of the Source EBS Application with BIEE which file do you need to configure?

  A. NQSConfig.ini
  B. credentialstore.xml
  C. instanceconfig.xml
  D. isapiconfig.xml
  C. instanceconfig.xml

• Question 7:

  What is the name of the Informatica repository that comes as part of the BI Applications installation?

  A. Oracle_BI_DW_Base.rep
  B. OracleBIAnalyticsApps.rpd
  C. Oracle_BI_DW_Base.rpd
  D. OracleBIAnalyticsApps.rep
  A. Oracle_BI_DW_Base.rep

• Question 8:

  During what phase does DAC calculate the sequence of the tasks listed under the selected subject area?

  A. when you 'synchronize" the tasks
  B. when you "generate parameters" for an execution plan
  C. when you "assemble" the subject area
  D. when you "build" the execution plan
  C. when you "assemble" the subject area

• Question 9:

  What is a set of books?

  i) It is synonymous with a Ledger ii) A set of books identifies a company or fund that shares a common chart of accounts structure, calendar, and functional currency iii) List of parameters required for the ETL to run successfully

  A. i, ii
  B. ii, iii
  C. i, iii
  D. i, ii, iii
  A. i, ii

• Question 10:

  Which item under DAC connection information will be modified while promoting the code to a new environment?

  A. Execute
  B. Setup
  C. Subject Area
  D. System
  B. Setup