Your customer is using Source Code Control Integration for Information server and have tagged artifacts for version 1. You must create a deployment package from the version 1. Before you create the package you will have to ensure the project is up to date with version 1. What two things must you do to update the meta-data repository with the artifacts tagged as version 1? (Choose two.)

A. Right-click the asset and click the Deploy command.

B. Right-click the asset and click the Team Import command.

C. Right-click the asset and click Update From Source Control Workspace.

D. Right-click the asset and click Replace From Source Control Workspace.

E. Right-click the asset and click the Team command to update the Source Control Workspace with the asset.

Which derivations are executed first in the Transformer stage?

A. Input column derivations

B. Loop variable derivations

C. Stage variable derivations

D. Output column derivations

Which two statements are true about the use of named node pools? (Choose two.)

A. Grid environments must have named node pools for data processing.

B. Named node pools can allow separation of buffering from sorting disks.

C. When named node pools are used, DataStage uses named pipes between stages.

D. Named node pools limit the total number of partitions that can be specified in the configuration file.

E. Named node pools constraints will limit stages to be executed only on the nodes defined in the node pools.

In your job you are using a Sequential File stage as a source. You have decided to use a schema file as an alternative way of specifying column definitions and record format properties. What two items are true in configuring this stage in your parallel job? (Choose two.)

A. Enable Run Time Column propagation.

B. Enable Run Time Schema propagation.

C. Configure the column tab with one column named 'Input'.

D. Configure the Schema File property with the path of the schema file definition.

E. Configure the APT_SEQFILE_HASSCHEMA property with the schema file path.

In a file defining a partial schema, which two properties define the record? (Choose two.)

A. intact

B. delim

C. position

D. length_of_record

E. record_delim_string

What are the two Transfer Protocol Transfer Mode property options for the FTP Enterprise stage? (Choose two.)

A. FTP

B. EFTP

C. TFTP

D. SFTP

E. RFTP

What two binding types are supported by Information Services Director (ISD) for a parallel job that is designed to be used as a service? (Choose two.)

A. EJB

B. SQL

C. HDFS

D. SOAP

E. STREAMS

A job design consists of an input Row Generator stage, a Filter stage, followed by a Transformer stage and an output Sequential File stage. The job is run on an SMP machine with a configuration file defined with three nodes. The $APT_DISABLE_COMBINATION variable is set to True.

How many player processes will this job generate?

A. 2

B. 4

C. 6

D. 8

In addition to the table and schema names, what two element names must be specified when you create a shared table definition in DataStage Designer? (Choose two.)

A. Database

B. Project name

C. Host system

D. Database instance

E. DataStage server system name

Which of following two pieces of information are required to be specified for the input link on a Netezza Connector stage? (Choose two.)

A. Partitioning

B. Server name

C. Buffering settings

D. Table definitions

E. Error log directory