Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-525
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-525.html

Oracle Business Intelligence Applications 7 for ERP Essentials

Question No: 31

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

  1. Extend Staging and target Database table to accommodate new column.

  2. Copy appropriate Informatica mapping and workflow to Informatica Custom folder.

  3. Modify the existing Informatica mapping workflow to accommodate new columns.

  4. Modify DAC with the necessary change.

  1. i, ii, in, iv

  2. i, iii, ii, iv

  3. iii, ii, i, iv

  4. ii, i, iii, iv

Answer: B

Question No: 32

What techniques would you use to promote Oracle BI Applications materials to a new environment after ail environments have been set up initially?

  1. Copy the BI Presentation catalog and BI repository into the new environment, create a db dump for the DAC repository and Informatics Repository and Data Warehouse. Load these into the new environment.

  2. Copy the BI Presentation catalog and BI repository into the new environment, create a db dump for the DAC repository and load this into the new environment. Restore connections between DAC, Informatica, the Warehouse and its source(s).

  3. Copy the BI Presentation catalog and BI repository into the new environment. Check connections between DAC, Informatica, the Warehouse and its source(s).

  4. Copy the BI repository into the new environment, create a db dump for the DAC repository and Warehouse and load these into the new environment. Check connections between DAC, Informatica, the Warehouse and its source(s). Merge new standard reports and dashboards into the new presentation catalog using the Catalog Manager and keep ad-hoc materials from the new environment.

  5. It is sufficient to copy the BI Presentation catalog and BI repository into the new environment.

  6. Copy the BI Presentation catalog, create a db dump for the DAC repository and Warehouse and load these into the new environment. Check connections between DAC, Informatica, the Warehouse and its source(s).

Answer: D

Question No: 33

Some users need a new Critical Success Factor or Ratio based on a measure that is not available. How would you help them in a way that is the least time consuming?

  1. Start looking in the source database(s) for base elements. Next step would be to check BTL if these are already mapped and available in the warehouse. If not, build new ETL, register ETL and new warehouse objects in DAC and model in BI repository. If available, build the new ratio in the Business Model and Mapping Layer, set available in the presentation layer and test in Answers.

  2. Start looking for base elements in the physical layer in the repository. If available you can directly build the ratio in the Business Model and Mapping Layer, set available for querying in the presentation layer and test results in Answers. If not available, check the warehouse tables and lastly the source tables.

  3. Directly start building SDE and SIL mappings to enhance the warehouse with extra columns. Register the mappings and new warehouse objects in the DAC, run the ETL and model in the BI repository. Test your work in Answers.

  4. Build a request in Answers based on the online BI Repository and create your new ratio as a new column based on other columns.

  5. Build a request in Answers directly on the source data available to you and create the new ratio as a new column in your report.

Answer: A

Question No: 34

Considering loading a fact named w_xxx_A, what is the exact sequence in which the mappings related fact are loaded?

  1. SDE -gt; PLP-gt; SIL

  2. SDE -gt; SIL -gt; PLP

  3. SIL -gt; SDE -gt; PLP

  4. PLP-gt; SIL -gt; SDE

Answer: B Explanation:

The correct sequence is SDESILPLP

Question No: 35

By default for a session in Informica, which properly is used to configure the minimum number of errors to be encountered, to mark the session as failed?

  1. Error limit

  2. Minimum Errors

  3. Stop on Errors

  4. Error Benchmark

Answer: D

Question No: 36

How many Informatica Repository Servers can be configured with a single DAC server?

  1. One

  2. Two

  3. Three

  4. Any number

Answer: A

Question No: 37

Which combination of the following machines represents an appropriate architecture for an Oracle BI Applications implementation?

  1. Machine A running DAC Server and DAC Client

  2. Machine B running DAC Server and Informatica Services

  3. Machine C running Informatica Services and Informatica Client tools

  4. Machine D running DAC Client and Informatica Client tools

  5. Machine E running DAC server and client, Informatica services and Client tools

  6. Machine F running Oracle BI EE components

  7. Machine G running an Oracle Database hosting the data warehouse

  8. Machine H running the source system

  1. Machines: A, C, F, G, H

  2. Machines: B, D, F, G, H

  3. Machines: E, F, H

  4. Machines: B, F, G, H

Answer: B

Explanation: DAC server and Informatica server should reside in the same machine.

Question No: 38

In an Oracle BI Cluster Server environment which statement is true?

  1. BI Scheduler can reside outside Local Area Network (LAN) whereas the other components

    (Clustered BI Servers, Master BI Server, BI Cluster Manager) of Oracle BI Cluster Server must reside on the same LAN.

  2. Clustered BI Servers, Master BI Server, BI Scheduler and Cluster Manager all need to reside in one Local Area Network (LAN).

  3. Cluster Manager can reside outside Local Area Network (LAN) whereas the other components (Clustered BI Servers, Master BI Server, BI Scheduler) of Oracle BI Cluster Server must reside on the same LAN.

  4. All components of an Oracle BI Cluster Server environment may exist on different Local Area Networks (LANs), provided the LAN are connected through a single Wide Area Network (WAN).

Answer: A

Question No: 39

After a year of working with HR and Financial Analytics, your organization chooses to add Sales Order Management Analytics. How would you combine this new module with the existing ones in the BI Applications installation?

  1. Build a new Sales Order Warehouse and ETL rules to source it. Then import its metadata into DAC and model as new physical layer in the BI repository. Test your work in Answers.

  2. Install Oracle BI Applications Sales Order Management and create the extra objects in the existing warehouse. Perform a table scan from DAC and check connection pools in the

    BI repository. Test your work in Answers and Dashboards.

  3. Make a backup of your ETL, the Warehouse, BI Presentation Catalog and BI Repository. Install Oracle BI Applications Sales Order Management and have the extra objects created by a script in the existing warehouse and Informatica Repository. Seed the DAC repository with new metadata, test new Out-of-the-Box execution plans, merge the newly installed BI repository with the backup and do the same with the presentation catalogs. Enable logging and test your work in Answers and Dashboards.

  4. Make a backup of the BI Presentation Catalog and BI Repository. Run the installation for Oracle BI Applications Sales Order Management. Merge all new objects with your back-up materials. Enable logging and test your results in Answers.

  5. Build a new Sales Order Warehouse and ETL rules to source it. Then import its metadata into DAC and build new execution plans based on the new Warehouse objects. Enable the BI repository with Sales Order metadata and cross-analysis and test your work in Answers.

  6. Install Oracle BI Applications Sales Order Management. After the installation check the connection pools in the BI repository. Test your work in Answers and Dashboards.

Answer: C

Question No: 40

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

  1. Execute

  2. Setup

  3. Subject Area

  4. System

Answer: B

Explanation: You change the connection in “setup” tab of DAC to point to test or prod instance when you change the environments.

100% Ensurepass Free Download!
Download Free Demo:1z0-525 Demo PDF
100% Ensurepass Free Guaranteed!
1z0-525 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No