IBM InfoSphere DataStage v8.5 - C2090-421 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Which two statements are correct when using the Oracle Enterprise stage? (Choose two.)

A. $APT_ORCHHOME/bin must appear before $ORACLE_HOME/bin in the $PATH. B. DataStage Designer requires connectivity to the Oracle database during job development. C. Add $ORACLE_HOME/bin to the $PATH and $ORACLE_HOME/lib to the $LIBPATH, $LD_LIBRARY_PATH, or $SHLIB_PATH. D. Define variable $TNS_ADMIN to point to the tnsnames.ora file location.

Discussion 0

Correct Answer: A,C Vote an answer

Question 2

You have a 3TB dataset hash-partitioned on CustID in a clustered environment. You need to join this dataset with 1GB of reference data on OrderID. Which technique is most appropriate?

A. Use Join stage, hash-partition and sort both link on OrderID. B. Use Lookup stage, select auto partitioning for the stream link and hash-partition the reference link on CustI C. Use Lookup stage, select auto partitioning for both link. D. Use Lookup stage, select auto partitioning for the stream link and entire partitioning for the reference link.

Discussion 0

Correct Answer: D Vote an answer

Question 3

You are responsible for deploying objects into your customers production environment. To ensure the stability of the production system the customer does not permit compilers on production machines. They have also protected the project and only development machines have the required compiler. What two options will allow jobs with a parallel transformer to execute in the customers production machines? (Choose two.)

A. Set $APT_COPY_TRANSFORM_OPERATOR B. Export the jobs with Information Server Manager with the executables. C. Create a package with Information Server Manager and select the option to include executables. D. Add $APT_COMPILE_OPT=-portable

Discussion 0

Correct Answer: B,C Vote an answer

Question 4

In a Transformer, which two of the following mappings can be handled by default type conversions. (Select two)

A. String input column mapped to integer output column. B. Date input column mapped to a string output column. C. Integer input column mapped to raw output column. D. Integer input column mapped to string output column. E. String input column mapped to a data output column.

Discussion 0

Correct Answer: D,E Vote an answer

Question 5

A client has multiple servers connected with a high bandwidth switch and has installed DataStage on one of them. There are five files (with the same record layout) that must be retrieved from three other servers using FTP. Which approach will retrieve and process all five files in the minimal amount of time?

A. In a single job, use five separate FTP Enterprise stages with output links to a single Sort Funnel stage. Next, process the records without landing to disk. B. In a single job, use three separate FTP Enterprise stages (one for each machine) with output links to a single Sort Funnel stage. Next, process the records without landing to disk. C. Use a single FTP Enterprise stage and specify five URI properties (one for each file). Next, process the records without landing to disk. D. Create a sequence containing five separate DataStage jobs which each retrieve a single file and append it to a common Data Set. Next, process the resulting Data Set in an sixth DataStage job.

Discussion 0

Correct Answer: C Vote an answer

Question 6

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? (Select two)

A. Set environment variable $DS_ENABLE_RESERVED_NUM_CONVERT to true. B. Avoid using the strings_025_and_026_in your IBM DB2 column names. C. Avoid using the strings_035_and_036_in your IBM DB2 column names. D. Set environment variable $DS_ENABLE_RESERVED_CHAR_CONVERT to true.

Discussion 0

Correct Answer: C,D Vote an answer

Question 7

Which three methods can be used to import metadata from a Web Services Description Language (WSDL) document? (Choose three.)

A. Orchestrate Schema Definitions B. XML Table Definitions C. Job Stage Column tab properties entered using "Load" feature D. Web Services WSDL Definitions E. Web Service Function Definitions

Discussion 0

Correct Answer: B,D,E Vote an answer

Question 8

Click on the Exhibit button.

Provided you have enough system resources, what is the maximum number of jobs that could be running concurrently in this image?

A. 3 B. 2 C. 5 D. 4

Discussion 0

Correct Answer: A Vote an answer

Question 9

Which two statements are correct when referring to an Aggregator Stage? (Choose two.)

A. Use Hash method for a limited number of distinct key values B. Use Hash method with a large number of distinct key-column values C. Use Sort method for a limited number of distinct key values D. Use Sort method with a large number of distinct key-column values

Discussion 0

Correct Answer: A,D Vote an answer

Question 10

The DB2 and Oracle Enterprise stages support logged and non-logged DBMS table operations. What is the non-logged operation that is supported by the DB2 and Oracle Enterprise stages?

A. Update B. Delete C. Insert D. Load

Discussion 0

Correct Answer: D Vote an answer