Download Oracle.1z0-448.ActualTests.2018-11-26.49q.vcex

Download Exam

File Info

Exam Oracle Data Integrator 12c Essentials
Number 1z0-448
File Name Oracle.1z0-448.ActualTests.2018-11-26.49q.vcex
Size 34 KB
Posted Nov 26, 2018
Download Oracle.1z0-448.ActualTests.2018-11-26.49q.vcex

How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Purchase

Coupon: MASTEREXAM
With discount: 20%






Demo Questions

Question 1

How are the ODI repositories upgraded? (Choose the best answer.)


  1. by using Opatch
  2. by using ODI Studio
  3. by using the import/export utilities
  4. by using Upgrade Assistant
Correct answer: A
Explanation:
(http://odibeginnertutorials.blogspot.in/2013/12/odi-12c-installation-and-odi-12c.html)
(http://odibeginnertutorials.blogspot.in/2013/12/odi-12c-installation-and-odi-12c.html)



Question 2

You must run the same mapping concurrently while avoiding clashes of ODI temporary objects. How must you implement this? (Choose the best answer.) 


  1. Create a custom KM to handle this by using ODI variables defined at the Topology level to create unique temporary object names.
  2. Use variables in the Logical Design of the Mapping to create unique temporary object names.
  3. Create a custom Knowledge Module (KM) to handle this by using ODI variables to create unique temporary object names.
  4. Select the Use Unique Temporary Object Names check box at the Physical Design level.
Correct answer: D
Explanation:
(https://blogs.oracle.com/dataintegration/entry/odi_12c_parallel_target_table)
(https://blogs.oracle.com/dataintegration/entry/odi_12c_parallel_target_table)



Question 3

Which tables created by ODI contain error records? (Choose the best answer.)


  1. ERR$
  2. ERROR$
  3. ODI_ERR$
  4. E$
Correct answer: D
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIKD/ckm.htm#ODIKD925)
(https://docs.oracle.com/middleware/1212/odi/ODIKD/ckm.htm#ODIKD925)



Question 4

Your customer wants a project in ODI, which contains a user function, to translate commands with different syntax for different technologies but with the same functionality. 
How can you achieve this? (Choose the best answer.)


  1. The project must be explicitly mapped within an ODI mapping.
  2. A customize knowledge module is needed.
  3. An ODI procedure must be associated with it.
  4. It can be defined for every technology listed in the topology.
Correct answer: D
Explanation:
(http://docs.oracle.com/cd/E23943_01/integrate.1111/e12643/procedures.htm#ODIDG464)
(http://docs.oracle.com/cd/E23943_01/integrate.1111/e12643/procedures.htm#ODIDG464)



Question 5

You want to ensure that the Physical Mapping Design cannot be modified even if the Logical Design of the Mapping is changed. What sequence of steps must you follow to achieve this? (Choose the best answer)


  1. Go to the Physical tab, select the Fixed Design check box of the Physical Mapping Design.
  2. Go to the Physical tab, select the Is Frozen check box of the Physical Mapping Design.
  3. Go to the Physical tab, select the Read-only check box of the Physical Mapping Design. 
  4. Go to the Physical tab, deselect the Modify check box of the Physical Mapping Design.
Correct answer: C
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/mappings.htm#ODIDG1560)
(https://docs.oracle.com/middleware/1212/odi/ODIDG/mappings.htm#ODIDG1560)



Question 6

Which two statements are true about the Oracle Data Integrator Software Development Kit (ODI SDK)? (Choose two.)


  1. It enables developers to execute most ODI operations through a Java program.
  2. It can be used to embed ODI processes into another product.
  3. It is used to load data between Teradata and Oracle.
  4. It must be used by ETL developers to develop ODI processes.
Correct answer: AD
Explanation:
(https://foursconsultancy.wordpress.com/odi/oracle-data-integrator-12c-components/)
(https://foursconsultancy.wordpress.com/odi/oracle-data-integrator-12c-components/)



Question 7

How do you reuse a configuration of OdiSendMail across multiple packages? (Choose the best answer.)


  1. Add a sub-model to a package, set the Sub-model step to Journalizing Sub-model, and select the Extend Window and Lock Subscriber check boxes.
  2. Add an OdiSendMail step to a knowledge module.
  3. Duplicate the OdiSendMail step into multiple packages.
  4. Create a procedure with a step that uses OdiSendMail and add this procedure into multiple packages.
Correct answer: D
Explanation:
(https://blogs.perficient.com/oracle/2014/08/26/how-to-create-an-oracle-data-integrator-odi-package/)
(https://blogs.perficient.com/oracle/2014/08/26/how-to-create-an-oracle-data-integrator-odi-package/)



Question 8

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
Correct answer: A
Explanation:
(http://www.oracle.com/us/products/middleware/data-integration/oracle-goldengate-realtime-access-2031152.pdf)
(http://www.oracle.com/us/products/middleware/data-integration/oracle-goldengate-realtime-access-2031152.pdf)



Question 9

Identify two correct exception behavior values for Run Scenario steps in load plans. (Choose two.)


  1. Run Exception and Restart
  2. Run Exception and Continue
  3. Run Exception and Ignore
  4. Run Exception and Fail
  5. Run Exception and Raise
Correct answer: CE
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/loadplans.htm#ODIDG1350)
(https://docs.oracle.com/middleware/1212/odi/ODIDG/loadplans.htm#ODIDG1350)



Question 10

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.
Correct answer: C
Explanation:
(http://odiexperts.com/context-logical-and-physical-schema-how-does-it-work/)
(http://odiexperts.com/context-logical-and-physical-schema-how-does-it-work/)









CONNECT US

Facebook

Twitter

PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount!



HOW TO OPEN VCEX FILES

Use ProfExam Simulator to open VCEX files