IBM IBM Certified Solution Developer A2090-303 Questions & Answers

• Question 71:

  Which DB2 to InfoSphere DataStage data type conversion is correct when reading data with the DB2 Connector stage?

  A. XML to SQL_WVARCHAR

  B. BIGINT to SQL_BIGINT (INT32)

  C. VARCHAR, 32768 to SQL_VARCHAR

  D. CHAR FOR BIT DATA to SQL_VARBINARY

  Correct Answer: A

• Question 72:

  The ODBC stage can handle which two SQL Server data types? (Choose two.)

  A. Date

  B. Time

  C. GUID

  D. Datetime

  E. SmallDateTime

  Correct Answer: CE

• Question 73:

  Which job design technique can be used to give unique names to sequential output files that are used in multi-instance jobs?

  A. Use parameters to identify file names.

  B. Generate unique file names by using a macro.

  C. Use DSJoblnvocationID to generate a unique filename.

  D. Use a Transformer stage variable to generate the name.

  Correct Answer: A

• Question 74:

  Which statement is correct about the Data Rules stage?

  A. The Data Rules stage works with rule definitions only; not executable rules.

  B. As a best practice, you should create and publish new rules from the Data Rules stage.

  C. If you have Rule Creator role in InfoSphere Information Analyzer, you can create and publish rule definitions and rule set definitions directly from the stage itself.

  D. When a job that uses the Data Rules stage runs, the output of the stage is passed to the downstream stages and results are stored in the Analysis Results database (IADB).

  Correct Answer: A

• Question 75:

  A 100MB input dataset has even distribution across 400 unique key values. When you run with a 4-node configuration file, which two changes could improve sort performance in this scenario? (Choose two.)

  A. Convert all numeric fields to varchars.

  B. Set $APT_TSORT_STRESS_BLOCKSIZE to 50MB.

  C. Alter the Sort stage properties to perform a stable sort.

  D. Specify Round Robin partitioning on the input link to the Sort stage.

  E. Specify "Restrict Memory Usage" to 60MB on the Sort stage properties.

  Correct Answer: BE

• Question 76:

  How must the input data set be organized for input into the Join stage? (Choose two.)

  A. Unsorted

  B. Key partitioned

  C. Hash partitioned

  D. Entire partitioned

  E. Sorted by Join key

  Correct Answer: BE

• Question 77:

  The Change Apply stage produces a change Data Set with a new column representing the code for the type of change. What are two change values identified by these code values? (Choose two.)

  A. Edit

  B. Final

  C. Copy

  D. Deleted E. Remove Duplicates

  Correct Answer: CD

• Question 78:

  What stage allows for more than one reject link?

  A. Join stage

  B. Merge stage

  C. Lookup stage

  D. Funnel stage

  Correct Answer: B

• Question 79:

  Configuring the weighting column of an Aggregator stage affects which two options. (Choose two.)

  A. Sum

  B. Maximum Value

  C. Average of Weights

  D. Coefficient of Variation

  E. Uncorrected Sum of Squares

  Correct Answer: AE

• Question 80:

  The parallel framework was extended for real-time applications. Identify two of these aspects. (Choose two.)

  A. XML stage.

  B. End-of-wave.

  C. Real-time stage types that re-run jobs.

  D. Real-time stage types that keep jobs always up and running.

  E. Support for transactions within source database connector stages.

  Correct Answer: BD