1Z0-448 Online Practice Questions and Answers

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

A. The project must be explicitly mapped within an ODI mapping.

B. A customize knowledge module is needed.

C. An ODI procedure must be associated with it.

D. It can be defined for every technology listed in the topology.

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

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

B. Add anOdiSendMailstep to a knowledge module.

C. Duplicate theOdiSendMail stepinto multiple packages.

D. Create a procedure with a step that usesOdiSendMailand add this procedure into multiple packages.

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.

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.

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.

You are defining a data store in ODI metadata and want to add a primary key even if it does not physically exist on the related database catalog.

How can you accomplish this? (Choose the best answer.)

A. You can add a primary key even if it does not physically exist on the related database catalog, by adding constraintson the data store.

B. You can add a primary key even if it does not physically exist on the related database catalog, by adding constraints to the data store diagram.

C. You cannot add a primary key if it does not physically exist on the related database catalog. You can flag only non-null conditions to be checked.

D. You cannot add a primary key if it does not physically exist on therelated database catalog. You can reverse engineer only the existing constraints.

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.

Which two statements are true about ODI web-based components? (Choose two.)

A. ODI Console allows administrators to edit users' information.

B. Enterprise Manager Cloud Control provides access to ODI data servers' settings.

C. ODI sessions can be monitored in Enterprise Manager Cloud Control.

D. ODI Console provides access to project and mapping details.

A Mapping that uses CDC does not load any source data and you want to check the SNP_CDC_SET table to find out the current window ID.

In which database schema must you look to find this table? (Choose the best answer.)

A. the schema hosting the Work repository

B. the schema hosting theWork schema of the default schema defined for your source data server

C. the schema hosting the Staging Area

D. SYS

You design 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.

Which statement is true about the IKM SQL Control Append that creates 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.

How do you provide a timeout value for an exception step? (Choose the best answer.)

A. by using a custom Groovy script

B. by using a variable

C. by using the Timeout filed

D. by using a Timeout knowledge module

You need to implement security mechanisms that allow only user "A" to view all the Mappings contained in a specific project named "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.

How can you define the order in which target data stores are loaded in a Mapping? (Choose the best answer.)

A. ODI automatically computes the load order based on the order on which the data stores were added to the Mapping.

B. You can use the Target Order field.

C. You can use the Target Load Order field.

D. You can use the Load Order field.

Identify the correct variable step type to use when assigning a value to a variable with an SQL query. (Choose the best answer.)

A. Evaluate Variable

B. Set Variable

C. Declare Variable

D. Refresh Variable