Pass the Oracle Oracle Data Integrator 12c Certified Implementation Spe 1z0-448 Questions and answers with CertsForce

Viewing page 3 out of 3 pages
Viewing questions 21-30 out of questions
Questions # 21:

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

Options:

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.


Questions # 22:

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

Options:

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.


Questions # 23:

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

Options:

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.


Viewing page 3 out of 3 pages
Viewing questions 21-30 out of questions