Online Access Free 000-418 Practice Test

Which three statements describe a DataStage installation in a clustered environment? (Choose three.)

• A.DataStage must be installed on the same kind of operating system as the metadata repository.
• B.All machines within the cluster must have connectivity to the metadata repository.
• C.Compiled job and all shared components must be available across all servers.
• D.The conductor node will create the job score and consolidate messages to the DataStage log.
• E.For clustered implementations, appropriate node pools are useful to reduce data shipping.

In your DB2 database you have column names that use characters # and $. Which two steps should be completed to allow DataStage to convert these characters into internal format and back as necessary? (Choose two.)

• A.Set environment variable $DS_ENABLE_RESERVED_NUM_CONVERT to true.
• B.Set environment variable $DS_ENABLE_RESERVED_CHAR_CONVERT to true.
• C.Avoid using the strings __035__ and __036__ in your IBM DB2 column names.
• D.Avoid using the strings __025__ and __026__ in your IBM DB2 column names.

You need to accumulate totals for all input records from a sequential file based on month, without regard to day or year. The output is to a sequential file. The columns appear as CUSTID Varchar(12), Sale_date Date, and sale_amount Decimal (5,2). Which series of stages would accomplish this task in the shortest time?

• A.Sequential File -> Transformer -> Aggregator -> Sequential File
• B.Sequential File -> Sort -> Aggregator -> Sequential File
• C.Sequential File -> Transformer -> Remove Duplicates -> Sequential File
• D.Sequential File -> Aggregator -> Sequential File

Which two methods should be used to delete a persistent parallel Data Set? (Choose two.)

• A.Delete the data set in the Data Set stage.
• B.Delete the Data Set using the UNIX rm command.
• C.Delete the Data Set in the Data Set Management utility.
• D.Delete the Data Set using the orchadmin command.

Which condition would require the use of a Custom Operator instead of a BuildOp or Transformer?

• A.The stage requires dynamic metadata.
• B.The stage will call external routines written in C/C++.
• C.The stage needs to run in parallel rather than sequentially.
• D.The stage is working with string variables.