IBM InfoSphere Information Server for Data Integration Fundamentals Technical Mastery v1

Define specific user variables and make them available within a Job Sequence ✘ Drop a database table using a script, then start two different parallel jobs in sequence when a file appears in a specific directory ✘

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

✘ Create multiple Exception Handlers stages to handle different types of failures ✔

It can extend data lineage to display data integration flows that are outside of Information Server ✘ It relies on the repository functions in DataStage Designer for impact analysis ✘ It displays data lineage reports ✘ It allows Metadata Workbench administrators to associate data stewards with data objects ✔

Transformer Stages ✘ Sequencer Stages ✘ Triggers ✘ Job Activity Stages ✔

DataStage Designer ✘ DataStage Administrator ✘ DataStage Director ✘ Information Server Web Console ✔

Stage reports an error ✘ Stage skips the input record ✘ Stage rejects the Input record ✘ Job gets aborted ✔

WAS (WebSphere Application Server) ✘ The ASB agent ✘ The database holding the Information Server Metadata Repository ✘ All of the above ✔ None of the above ✔

Degree of parallelism ✘ Scratch disk dedicated for sorting ✘ Compilation options for DataStage jobs ✘ A named pool including only part (some) of the nodes ✔

By a space character ✘ By a 'NULL' string ✘ A -1 for an integer field and an empty string for a VARCHAR field ✘ As defined by the Developer in the extended properties of the field ✔

Automate data relationship discovery ✘ Prototype a data model for the first time ✘ Automate transformation rule discovery ✘ Automate business object identification ✔ All of the above ✔

Blueprint Director will display the time needed to perform individual tasks ✘ You can browse and search Information Server metadata assets ✘ You can create new blueprints from standard reference architecture templates ✘ Reference architectures contain detailed method guidance for required activities ✔