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

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

A. extracting source data to flat files 

B. triggers 

C. Oracle GoldenGate 

D. before-and-after database image comparison 

View Answer

Q2. Identify three capabilities of load plans. (Choose three.) 

A. restart from failed tasks 

B. exception handling 

C. native support for parallelism 

D. support for Open Tools 

E. restart of an agent 

View Answer

Q3. You mustmodify the order in which data stores are being journalizedin a model. What sequence of steps do you follow to achieve this?(Choose the best answer.) 

A. Openthe model, go to the Journalizing tab, and modify the order there. 

B. Right-click Datastore, select Changed Data Capture, and then select Order. 

C. Open the model, go to the Journalized tables tab, and modify the order there. 

D. Open the data stores, go to the Journalizing tab, and modify the order there. 

View Answer

Q4. Which statement is true about the need to have a topology with an intermediate server, in order to use ODI correctly in a data warehouse project?(Choose the best answer.) 

A. Data transformation must be distributed across several scalable nodes. 

B. It is mandatory to have an intermediate server. 

C. It is better to load data directly from sources into a data warehouse server. 

D. It is mandatory to collect data directly from sources to a data warehouse server by using 

real time replication processes. 

View Answer

Q5. You are working with delimited flat files and want to enforce a primary key on a flat file by using a Check Knowledge Modules (CKM). However, you encounter an error. 

Why did this happen?(Choose the best answer.) 

A. It is not possible to enforce constraints on some technologies such as flat files and Java Messaging Service (JMS) queries. 

B. It is not possible to enforce constraints on any technology. 

C. It is only possible to forward-engineer it to the flat file definition. 

D. It is possible to enforce a primary key on a flat file by using a CKM; however, you have to save it as a fixed file. 

View Answer

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

View Answer

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

View Answer

Q8. Identify two constraints that can be used to ensure uniqueness in ODI.(Choose two.) 

A. conditions 

B. foreign keys 

C. primary keys 

D. alternate keys 

E. not null 

View Answer

Q9. You want to draw directly in the data flow all the details about how the different servers involved are connected, in order to load a specific table by using ODI. 

What must you do to accomplish this?(Choose the best answer.) 

A. In the ODI Interface palette, choose the more convenient graphic objects to link the involved servers. 

B. You need not draw directly in the data flow all the details about how the different servers involved are connected. ODI automatically designs the flow and how servers are connected. 

C. You need not draw directly in the data flow all the details about how the different servers involved are connected. The code will be the black box generated directly by ODI. 

D. You must draw directly in the data flow all the details about how the different servers involved are connected, and also specify with variables the passwords for connecting to the data contained in the servers. 

View Answer

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

View Answer