It is more faster and easier to pass the Oracle 1Z0-448 exam by using Approved Oracle Oracle Data Integrator 12c Essentials questuins and answers. Immediate access to the Up to the minute 1Z0-448 Exam and find the same core area 1Z0-448 questions with professionally verified answers, then PASS your exam with a high score now.
Q16. You need to deploy ODI JEE Components on WebLogic Server. Where should you deploy them?(Choose the best answer.)
A. on the Coherence Server
B. on the Administration Server
C. on the Node Manager
D. on the Managed Server
Answer: D
Explanation: (http://docs.oracle.com/cd/E25054_01/core.1111/e10106/odi.htm)
Q17. You are using a customized reverse knowledge module. You want the execution to be performed in only the development data environment. Which statement is true?(Choose the best answer.)
A. The execution should be done only on the development data environment, as long as the other environment is a mirrored copy.
B. Only the production environment can be used.
C. All environments linked to a logical schema can be used to reverse-engineer table structures.
D. Only a Java engine intermediate environment can be processed.
Answer: C
Explanation:
(http://docs.oracle.com/cd/E23943_01/integrate.1111/e12643/create_rev_model.htm#ODID G227)
Q18. You must monitor and managea co-located stand-alone agent,OracleDIAgent1, by using the ODI plug-in for Enterprise Manager CloudControl. Which is the correct command to start this agent on Linux?(Choose the best answer.)
A. ./agent.sh –NAME=OracleDIAgent1 –PORT=20910
B. ./agent.sh –NAME=OracleDIAgent1
C. ./startComponent.sh OracleDIAgent1
D. ./startComponent.sh OracleDIAgent1 –PORT=20910
Answer: A
Explanation: (https://community.oracle.com/thread/3780742?start=0&tstart=0)
Q19. Identify two correct statements about reusable Mappings.(Choose two.)
A. They can have generic input and output signatures.
B. They contain both a Logical and Physical Mapping design.
C. They can be used within regular Mappings.
D. They can be executed directly.
E. They can be shared across projects.
Answer: A,B
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/mappings.htm#ODIDG1617)
Q20. You want to modify the code generated by a failed Task and restart the session. How must you proceed?(Choose the best answer.)
A. Open the Task in Operator, go to Code, click Edit, use Pre-execution Code to edit the code, and save it.
B. It is not possible to modify the code once it has been generated.
C. Open the Step in Operator, edit the code, and save it.
D. Open the Task in Operator, go to Code, click Query/Execution Plan to edit the code, and save it.
Answer: D
Explanation: (http://www.odigurus.com/2011/05/using-operator.html)
Q21. You are working on notifications in a package and you must send an email containing an error message incase a Package step fails.
WhichodiRefmethod do you use to access the error message?(Choose the best answer.)
A. odiRef.getSession()
B. odiRef.getInfo()
C. odiRef.getPrevStepLog()
D. odiRef.getStep()
Answer: B
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIKD/odiref_reference.htm#ODIKD1147)
Q22. A. Add a new subscriber and edit the default Journalizing filter in your Mappings.
B. Drop the journal, add a new subscriber, start the journal, and edit the defaultJournalizing filter in your Mappings.
C. Drop the journal, remove existing subscribers, add a new subscriber, start the journal, and edit the default Journalizing filter in your Mappings.
D. Add a new subscriber, start the journal, and remove the default Journalizing filter in your Mappings.
Answer: B
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/data_capture.htm#ODIDG285)
Q23. Which statement is true about theIKM SQL Control Append thatcreates an intermediate integration table prefixed with I$?(Choose the best answer.)
A. Theintermediate integration table prefixed with I$is required to determine which records must be inserted.
B. IfFlow Control is not necessary, an I$ table is not created.
C. Theintermediate integration table prefixed with I$ is createdbecause the flow control is mandatory when doing an initial load.
D. Neither the LKM northe IKM create intermediate tables. Most of their work is performed in the ODI Agent memory.
Answer: D
Explanation: (http://www.oracle.com/us/products/middleware/data-integration/odi-performance-guide-wp-2147067.pdf)
Q24. You have to loop through a Mapping step three times in a package by using variables. Identify thecorrect variable data type to create the loop. (Choose the best answer.)
A. numeric
B. alphanumeric
C. date
D. text
Answer: A
Explanation: (https://www.packtpub.com/packtlib/book/Big-Data-and-Business-Intelligence/9781849681742/4/ch04lvl1sec31/Using%20variables%20to%20control%20loo ps%20inside%20packages)
Q25. Identify two correct exception behavior values for Run Scenario steps in load plans.(Choose two.)
A. Run Exception and Restart
B. Run Exception and Continue
C. Run Exception and Ignore
D. Run Exception and Fail
E. Run Exception and Raise
Answer: C,E
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/loadplans.htm#ODIDG1350)
Q26. You need toimplement security mechanismsthat allow only user “A” to view all the Mappings contained in a specific projectnamed “P1.” How must you proceed?(Choose the best answer.)
A. Go to Security, assign the NG DESIGNER profile to user “A.” Next, drag project “P1” to user “A” and finally setView privilegesto Active for the Mapping objects.
B. Go to Security, assign the DESIGNER profile to user “A.” Next, drag project “P1” to user “A” and finally set View privileges to Active for the Mapping objects.
C. Go to Security, assign the NG DESIGNER profile to user “A.” Next, drag project “P1” to user “A” and finally set View privileges to Active for the Project, Folder, and Mapping objects.
D. Go to Security, assign the DESIGNER profile to user “A.” Next, drag project “P1” to user “A” and finally set View privileges to Active for the Project, Folder, and Mapping objects.
Answer: D
Explanation:
(https://docs.oracle.com/cd/B12037_01/network.101/b10777/protdata.htm#1006312)
Q27. How are the ODI repositories upgraded?(Choose the best answer.)
A. by using Opatch
B. by using ODI Studio
C. by using the import/export utilities
D. by using Upgrade Assistant
Answer: A
Explanation: (http://odibeginnertutorials.blogspot.in/2013/12/odi-12c-installation-and-odi-12c.html)
Q28. Your package logic requires you to retrieve the status of the previous package step into a variable. How must you implement this?(Choose the best answer.)
A. Create a variable, useodiRef.getPrevStepLog ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.
B. Create a variable, useodiRef.getPrevInfo ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.
C. Create a variable, useodiRef.getStep ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.
D. Create a variable, useodiRef.getPrevStepStatus ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.
Answer: A
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIKD/odiref_reference.htm#ODIKD1237)
Q29. 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.)
A. transform only
B. load and transform
C. extract and load
D. extract and transform
Answer: A
Explanation: (http://www.oracle.com/us/products/middleware/data-integration/oracle-goldengate-realtime-access-2031152.pdf)
Q30. 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)
A. Create new submodels and drag data stores individually to each submodel.
B. Use automatic distribution feature at the models level to automatically create the submodels and move the data stores based on their names.
C. Create new submodels and leverage the automatic distribution feature at the submodels level to automatically move the data stores based on their names.
D. 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)