1Z0-448 Exam - Oracle Data Integrator 12c Essentials

Q1. 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.) 

A. UseOdiPingAgentin a package to ping AGT agent. 

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

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

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

View Answer

Q2. 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 

View Answer

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

A. Use a dedicated schema such asODI_STAGING. 

B. UseTEMP. 

C. Use the same schema as the Data Schema. 

D. Use SYSTEM. 

View Answer

Q4. You need to create a Model that works with multiple underlying technologies. How must you proceed?(Choose the best answer.) 

A. This works only for Oracle and Informix. 

B. This works only for Oracle and MySQL. 

C. Create a new generic technology to support it. 

D. Use the out-ofthe box Generic SQL technology. 

View Answer

Q5. You must send the same message in multiple packages to several email addresses stored in the same database table. How do you accomplish this by using a reusable package step?(Choose the best answer.) 

A. Create a procedure and add two tasks. The first one must have a Command on Source that reads the email addresses from the database table and stores them in a bind variable, and the second must have a Command on Target that usesOdiSendMailto send the email by using the bind variable defined in the first task. 

B. Createa Knowledge Module. Add a task with a Command on Source that reads the email addresses from the database table and stores them in a bind variable, and a Command on Target that usesOdiSendMailto send the email using the bind variable defined in the Command on Source. 

C. Create a counter variable that gets the total number of email addresses stored in the database table. Next, create another variable that selects the email addresses from the database table. Then, create a loop in the packages by using the variables and anOdiSendMailstep. 

D. Create a procedure. Add a task with a Command on Source that reads the email addresses from the database table and stores them in a bind variable, and a Commandon Targetthat usesOdiSendMailto send the email using the bind variable defined in the Command on Source. 

View Answer

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

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

B. ODI performs data transformations inside a Hadoop cluster. 

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

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

View Answer

Q7. 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() 

View Answer

Q8. You create two mappings that both use the same changed data and run at different times. One runs every 15 minutes and the other runs once every day. 

What must you do to ensure that the Mapping that gets executed more often does not consume the changed data required by the other Mapping?(Choose the best answer.) 

A. Use Consistent CDC, do not perform a purge of the journal data when the first Mapping gets executed, and manually change theJRN_SUBSCRIBERcolumn in the correspondingJ$table to keep the changed data present for the second Mapping. 

B. Create a third mapping to copy the changed data to a staging table, which is used as the source of the second Mapping. 

C. Duplicate the source data store for each Mapping. 

D. Create two distinct subscribers for each Mapping. 

View Answer

Q9. Youdesign a package with mappings that consume data from journalized data stores in Consistent Set CDC mode. Which option represents the steps that must be performed at the beginning of your package to accomplish this?(Choose the best answer.) 

A. Add data stores to the package, set Datastores steps to Journalizing Datastore, and select the Extend Window and Lock Subscriber check boxes. 

B. Add data stores to the package, set Datastores steps to Journalizing Datastore, and select the Unlock Subscriber and Purge Journal check boxes. 

C. Add a model to the package, set the Model step to Journalizing Model, and select the Extend Window and Lock Subscriber check boxes. 

D. Add a sub model to the package, set the Sub-model step to Journalizing Sub-model, and select the Extend Window and Lock Subscriber check boxes. 

View Answer

Q10. 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. 

View Answer