IBM InfoSphere Information Server for Data Integration Fundamentals Technical Mastery Test v1 - 000-N45 Exam Practice Test

A. Automatically updates table definitions when a SQL type mismatch is detected

B. Deletes rows from a DB2 table

C. Reads a DB2 table

D. Performs a lookup directly on a DB2 table

A. Run two different parallel jobs in sequence and use job parameters to pass different $APT_CONFIG _FILE values for each of them

B. Create multiple Exception Handlers stages to handle different types of failures

C. Define specific user variables and make them available within a Job Sequence

D. Drop a database table using a script, then start two different parallel jobs in sequence when a file appears in a specific directory

A. Overwrite

B. Create

C. Append

D. Delete

A. Setup a configuration file defining multiple CPUs for each logical node

B. Avoid repartitioning if possible

C. Disable the pipeline parallelism for all the stages that can run in parallel

D. All of the above

A. Prototype a data model for the first time

B. Automate business object identification

C. Automate transformation rule discovery

D. Automate data relationship discovery

E. All of the above

A. Transformer Stage

B. Funnel Stage

C. Join Stage

D. Lookup Stage