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

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

View Answer

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

View Answer

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

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

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

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

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

View Answer

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

View Answer

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

A. Regenerate the existing scenario. 

B. Nothing, the existing scenario will automaticallybe updated. 

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

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

View Answer

Q6. What must you set on the Definition tab of a variable to protect the variable value from being displayed in the Operator logs?(Choose the best answer.) 

A. Select the Secure Value check box. 

B. Select the Hide Value check box. 

C. Set the Keep History field to No History. 

D. Leave the Default Value field empty. 

View Answer

Q7. You are designing a Mapping. How are target and source tables defined?(Choose the best answer.) 

A. Their definition is imported with areverse-engineering process directly from databases and other sources, but you must manually define all keys and constraints existing on the database. 

B. Their definition is imported with a reverse-engineering process directly from databases and other sources. 

C. Forevery load the definition of the tables used, their columns and constraints must be manually built. 

D. An external engine must be run to describe what metadata is needed for a Mapping. 

View Answer