You have been asked to identify all of the job objects that use a particular Table Definition. This task must be performed to evaluate the impact of this layout change for your DataStage application. To accomplish this task, which two steps must have been completed by the job developers to allow you to locate all of the jobs associated with the table definition? (Choose two.)
A. The job stage cross reference properties must be entered using the Table Definition name.
B. The Table Definition object must be created.
C. The Cross Reference object must be created.
D. The job stage column tab properties must be entered using 'Load' button within the Table Definition.
正解:B,D
質問 2:
You desire that no changes be made to your jobs in either QA or production environments. What are two ways to ensure this? (Choose two.)
A. Export only executables from the development environment.
B. Protect the QA and production projects.
C. Mark the project read-only in the Director.
D. Only give execute permissions to the QA and production users.
正解:A,B
質問 3:
You are asked to promote your DataStage jobs from Development to QA and then on to the production environment. You must do this within the organization's change management guidelines which specify that the jobs will be imported using a deployment package and that no configuration changes can be made at this time. What are two ways that enable your jobs to access the databases in all three environments? (Choose two.)
A. Change database connection values using the Connector Administrator Console.
B. Use parameter sets and have different value files in each environment.
C. Pass values to parameters from environment variables that contain the required database connection values.
D. Create a database values file.
正解:B,C
質問 4:
In a job using Sequential File stage to write a sequential file, the ContactName column is nullable, but the "Null field value" property is left unspecified. The ContactName column has a Char(50) data type. What will happen if NULL is written to the ContactName column?
A. The job will abort.
B. The column will be padded with the character specified by the $APT_STRING_PADCHAR character.
C. The row containing the NULL will be rejected.
D. The empty string ("") will be written to the ContactName column.
正解:C
質問 5:
What describes the column information specified in Orchestrate schemas? (Choose two.)
A. Record format information, such as record delimiter
B. SQL data types, such as Char(20)
C. Column properties, such as nullability
D. C++ data types, such as string[max 145]
正解:C,D
質問 6:
Which two statements are true regarding access to a MQ queue? (Choose two.)
A. MQ stage connects to a queue manager in Client mode only.
B. MQ stage can be used to read and write messages from a remote MQ message queue.
C. MQ stage and MQ connector stages support destructive reads.
D. MQ connector stage is capable of connecting to Queue manager in both Server and Client mode.
正解:C,D