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

Oracle Data Integrator 12cEssentials

Question No: 31

Which two statements are true about using ODI and Oracle GoldenGate together?(Choose two.)

  1. Oracle GoldenGate primarily performs aggregations for ODI.

  2. Oracle GoldenGate and ODI are used together primarily for running weekly batch jobs.

  3. Oracle GoldenGate provides non-invasive changed data capture capabilities to ODI.

  4. ODI starts and stops Oracle GoldenGate processes automatically during a Mapping execution.

  5. ODI and Oracle GoldenGate enable real-time business intelligence.

Answer: A,E

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

Question No: 32

Identify two correct Restart values for parallel steps in load plans.(Choose two.)

  1. Restart from new session.

  2. Restart from failure.

  3. Restart from failed children.

  4. Restart all children.

Answer: C,D Explanation:

(https://docs.oracle.com/middleware/1212/odi/ODIDG/loadplans.htm#ODIDG1409)

Question No: 33

Updates have been made to Mappings in a package. What must you do to ensure that the Production team runs a scenario that contains those updates while preserving the existing scenario’s schedule?(Choose the best answer.)

  1. Regenerate the existing scenario.

  2. Nothing, the existing scenario will automaticallybe updated.

  3. Generate a new scenario and create a new schedule.

  4. Generate a new scenario and attach the previous scenario’s schedule to it.

Answer: A Explanation:

(https://docs.oracle.com/middleware/1212/odi/ODIDG/scenarios.htm#ODIDG470)

Question No: 34

How should you define the Work Schema of a Physical Schema?(Choose the best answer.)

  1. Use a dedicated schema such asODI_STAGING.

  2. UseTEMP.

  3. Use the same schema as the Data Schema.

  4. Use SYSTEM.

Answer: A Explanation:

(http://www.rittmanmead.com/2014/12/data-integration-tips-one-data-server/)

Question No: 35

You must split a model with many database tables into multiple sub-models based on their names. How must you proceed?(Choose the best answer)

  1. Create new submodels and drag data stores individually to each submodel.

  2. Use automatic distribution feature at the models level to automatically create the submodels and move the data stores based on their names.

  3. Create new submodels and leverage the automatic distribution feature at the submodels level to automatically move the data stores based on their names.

  4. Create new models, drag the data stores individually to each model and then drag the models to the parent model to create submodels.

Answer: B Explanation:

(https://docs.oracle.com/middleware/1212/odi/ODIDG/organizing_documenting.htm#ODID G524)

Question No: 36

Your project requires a loop through the same package logic 24/7. You must be able to purge those executions when required. How do you accomplish this?(Choose the best answer.)

  1. Link the last step of the package to its first step to create an infinite loop.

  2. Create a scenario from the package, add the scenario as the last step in the package, run it asynchronously, and then save and regenerate this scenario.

  3. Create a scenario from the package, add the scenario as the last step in the package, run it asynchronously, and then save.

  4. Drag the package to the last step in the package, run it asynchronously, and then save.

Answer: B

Explanation: (http://www.rittmanmead.com/2015/04/di-tips-odi-convert-to-flow/)

Question No: 37

Which two statements are true about big data support in ODI?(Choose two.)

  1. ODI uses its own transformation engine to process data in a Hadoop cluster.

  2. ODI performs data transformations inside a Hadoop cluster.

  3. ODI must perform data transformations outside Hadoop in an Oracle database.

  4. ODI allows moving data in and out of a Hadoop cluster.

Answer: B,D

Explanation: (https://docs.oracle.com/middleware/1213/odi/develop-app- adapters/hadoop.htm#ODIAA193)

Question No: 38

Which statement is true about defining more than one physical schema associated to the same data server?(Choose the best answer.)

  1. ODI topology does not allow defining more than one physical schema for a data server; the associated logical schema would be ambiguous.

  2. It is possible to define more than one physical schema associated to the same data server, but it is mandatory to specify a different user to log in.

  3. It is possible to define more than one physical schema associated to the same data server, but you must flag the default physical schema.

  4. It is possible but it is better to avoid doing so because it is more difficult to define a logical schema this way.

Answer: C

Explanation: (http://odiexperts.com/context-logical-and-physical-schema-how-does-it- work/)

Question No: 39

You are designing a load plan in which you must run Mappings A and B one after the other while running Mapping C at the same time. Which option represents the steps to accomplish this?(Choose the best answer.)

  1. Add a parallel step, add three serial steps underneath it, then addAto the first parallel step, B to the second one, and C to the last one.

  2. Create a scenario from the variable and add the scenario to the load plan to create a case step.

  3. Add a parallel step, add two parallel steps underneath it, then add A and B tooneparallel step, and C to the other.

  4. Add a parallel step, add two serial steps underneath it, then add A and B to one serial step, and C to the other.

Answer: C Explanation:

(https://docs.oracle.com/middleware/1212/odi/ODIDG/loadplans.htm#ODIDG1356)

Question No: 40

You are setting up the topology for an infrastructure with three different environments: Dev, QA, and Prod. How must you create Logical Schemas?(Choose the best answer.)

  1. Create one Logical Schema per Physical Schema.

  2. Create one Logical Schema per Physical Schema that stores the same type of data.

  3. Create one Logical Schema per Data Server.

  4. Create one Logical Schema per Context.

Answer: D Explanation:

(https://docs.oracle.com/middleware/1213/odi/develop/setup_topology.htm#ODIDG174)

100% Ensurepass Free Download!
Download Free Demo:1z0-448 Demo PDF
100% Ensurepass Free Guaranteed!
Download 2018 EnsurePass 1z0-448 Full Exam PDF and VCE

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