Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-448
100% Free Download! 100% Pass Guaranteed!

Oracle Data Integrator 12cEssentials

Question No: 41

When Oracle Data Integrator (ODI) and Oracle GoldenGate are used together, which option represents the phases of an ELT process that Oracle GoldenGate performs?(Choose the best answer.)

  1. transform only

  2. load and transform

  3. extract and load

  4. extract and transform

Answer: A

Explanation: (http://www.oracle.com/us/products/middleware/data-integration/oracle- goldengate-realtime-access-2031152.pdf)

Question No: 42

You are designing a Mapping. How are target and source tables defined?(Choose the best answer.)

  1. Their definition is imported with areverse-engineering process directly from databases and other sources, but you must manually define all keys and constraints existing on the database.

  2. Their definition is imported with a reverse-engineering process directly from databases and other sources.

  3. Forevery load the definition of the tables used, their columns and constraints must be manually built.

  4. An external engine must be run to describe what metadata is needed for a Mapping.

Answer: A Explanation:


Question No: 43

What is the main benefit of using consistent set journalizing compared to simple journalizing?(Choose the best answer.)

  1. Consistent set journalizing runs faster than simple journalizing.

  2. Consistent set journalizing always uses Oracle GoldenGate.

  3. Consistent set journalizing treats each data store individually.

  4. Consistent set journalizing provides a guarantee of consistency of the captured changes.

Answer: D Explanation:


Question No: 44

Which two objects can be dragged to a Mapping?(Choose two.)

  1. Variables

  2. Datastores

  3. Knowledge Modules

  4. Reusable Mappings

Answer: B,D Explanation:


Question No: 45

You must ensure that your Mappings do not run into connectivity issues when moving data from server A to server B by using an AGT agent that is running on server B.

How must you test this by using ODI Studio running on machine C?(Choose the best answer.)

  1. UseOdiPingAgentin a package to ping AGT agent.

  2. In Topology, test the connections to servers A and B by using the AGT agent.

  3. In Topology, test the connections to the AGT agent.

  4. In Topology, test the connections to servers A and B by using Local (No Agent).

Answer: B

Explanation: (http://www.ateam-oracle.com/how-to-understand-and-diagnose-odi- connectivity-issues/) as per this link even choice A is right as its alternative/additional method for testing connectivity

Question No: 46

Which statement is correct about choosing the join order in an ODI Mapping when defining a join?(Choose the best answer.)

  1. This option is inherited from reverse engineering.

  2. This option is always available.

  3. You can never make this choice.

  4. This option may be available only if the underlying technology supports it.

Answer: B Explanation:


Question No: 47

What must you set on the Definition tab of a variable to protect the variable value from being displayed in the Operator logs?(Choose the best answer.)

  1. Select the Secure Value check box.

  2. Select the Hide Value check box.

  3. Set the Keep History field to No History.

  4. Leave the Default Value field empty.

Answer: C Explanation:


Question No: 48

How would a Knowledge Module, that is required to perform an aggregation in a Mapping, generate the correct code? (Choose the best answer.)

  1. The Knowledge Module must be customized because business rules and the physical implementation are strictly interlayed in ODI.

  2. The Knowledge Module must be customized only for aggregation functions.

  3. The Knowledge Module need not be customized because aggregation code is generated automatically by ODI according to the Mapping logic.

  4. The Knowledge Module need not be customized, but a variable must be used in the

aggregate expression to generate the correct sum.

Answer: D Explanation:


Question No: 49

You have been tasked with designing a Mapping that must perform an initial load and incremental updates using the same transformation logic. How should you proceed?(Choose the best answer.)

  1. Create a single Mapping with two Physical Designs: one for theinitialload and one for the incremental updates.

  2. Create a single Mapping with a single Physical Design and modify it appropriately when an initial load is required or when an incremental update is required.

  3. Create two Mappings: one for the initial load and one for the incremental updates. Duplicate the transformation logic.

  4. Create a single Mapping and use variables in the Logical Design to do an initial load when required or an incremental update otherwise.

Answer: D Explanation:


Question No: 50

Identify two implementation strategies of changed data capture provided through ODI Knowledge Modules. (Choose two.)

  1. extracting source data to flat files

  2. triggers

  3. Oracle GoldenGate

  4. before-and-after database image comparison

Answer: B,C

100% Ensurepass Free Download!
Download Free Demo:1z0-448 Demo PDF
100% Ensurepass Free Guaranteed!
1z0-448 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
Free VCE Simulator Yes No No
Instant Download Yes No No