IBM IBM certifications III 000-418 Web Demo
This webdemo is just a demo data, only for reference and learning, there is no other purposes
1. Which three statements are true about File Sets? (Choose three.)
A. File sets are partitioned.
B. File sets are unpartitioned.
C. File sets are stored as a single file.
D. File sets are readable by external applications.
E. File sets are stored as header file and data files.
Answer: ADE
2.When tuning a parallel process, it is necessary to measure the
amount of system resources that are used by each instance of a stage.
Which two methods enable the collection of CPU time used by each
instance of a stage? (Choose two.)
A. Set the environment variable $APT_PM_PLAYER_TIMING=true.
B. Invoke vmstat before the job run and after the job completes.
C. Select the Record job performance data check box from Job Properties.
D. Set the environment variable $DS_MAKE_JOB_REPORT=2.
Answer: AC
3. Your job uses the MQ connector stage to read messages from an MQ
queue. The job should retrieve the message ID into the MessageID field
and parse the payload into two fields: Name is to get the first ten
characters, Description is to get the remaining characters.
What will accomplish this?
A. First column is MessageID as Binary 24; second column is Name as
Binary 10; select WSMG.MSPAYLOAD data element; third column is
Description as VarBinary 200; select WSMG.MSPAYLOAD data element.
B. First column is MessageID; select the WSMQ.MSGID data element for
the Message ID field;second column is Description as VarBinary 200;
third column is Name as Binary 10.
C. First column is MessageID; select the WSMQ.MSGID data element for
the Message ID field; second column is Name; select WSMG.MSPAYLOAD data
element; third column is Description; select WSMG.MSPAYLOAD data
element.
D. First column is MessageID; select the WSMQ.MSGID data element for
the Message ID field; second column is Name as Binary 10; third column
is Description as VarBinary 200.
Answer: D
4. Which three lookup types may be performed in the Lookup stage? (Choose three.)
A. Equality match
B. Negative match
C. Range on stream link
D. Range on the reject link
E. Range on the reference link
Answer: ACE
5. What describes the column information specified in Orchestrate schemas? (Choose two.)
A. C++ data types, such as string[max 145]
B. column properties, such as nullability
C. SQL data types, such as Char(20)
D. record format information, such as record delimiter
Answer: AB
6. Which two methods can be used for adding messages to a message handler? (Choose two.)
A. Import message handler from existing message handler dsx.
B. Drag and drop a message from the job log onto the message handler.
C. Type in the message rule by hand.
D. Use the add rule to message hander interface.
Answer: CD
7. In which two situations would you use the Web Services Client stage? (Choose two.)
A. You want to deploy a service.
B. You need the Web service to act as either a data source or a data target during an operation.
C. You do not need both input and output links in a single web service operation.
D. You need to create a WSDL.
Answer: BC
8. Which two steps are required to change from a normal lookup to a sparse lookup in an ODBC Enterprise stage? (Choose two.)
A. Change the lookup option in the stage properties to "Sparse".
B. Replace columns at the beginning of a SELECT statement with a wildcard asterisk (*).
C. Establish a relationship between the key field column in the source stage with the database table field.
D. Sort the data on the reference link.
Answer: AC
