000-418 Exam

- Covers the entire recommended syllabus
- Comprehensive questions and answers about 000-418 exam
- Verified Answers Researched by Industry Experts and almost 100% correct
- 000-418 exam questions updated on regular basis
- Same type as the certification exams, 000-418 exam preparation is in multiple-choice questions (MCQs)
- Tested by multiple times before publishing
- Try free 000-418 exam demo before you decide to buy it in Hiexam
- Technical support through Live Chat or Email

　
　
Exam : IBM 000-418
Title : IBM Websphere Datastage V.8.0


1. 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

2. 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

3. 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

4. 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

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

http://www.Hiexam.com The safer.easier way to get IBM certifications III Certification.