IBM IBM Certified Solution Developer A2090-303 Questions & Answers

• Question 81:

  Which two statements about the Additional Connections Options property in the Teradata Connector stage to specify details about the number of connections to Teradata are true? (Choose two.)

  A. The default for requestedsessions is the minimum number of available sessions.

  B. The default for requestedsessions is the maximum number of available sessions.

  C. Requestedsessions is a number between 1 and the number of vprocs in the operating system.

  D. Sessionsperplayer determines the number of connections each player in the job has to Teradata.

  E. Total requested sessions equals sessions per player multiplied by number of nodes multiplied by players per node. The default value is 4.

  Correct Answer: BD

• Question 82:

  Which requirement must be met to read from a database in parallel using the ODBC connector?

  A. ODBC connector always reads in parallel.

  B. Set the Enable partitioning property to Yes.

  C. Configure environment variable $APT_PARTITION_COUNT.

  D. Configure environment variable $APT_MAX_TRANSPORT_BLOCK_SIZE.

  Correct Answer: B

• Question 83:

  Which two pieces of information are required to be specified for the input link on a Netezza Connector stage? (Choose two.)

  A. Partitioning

  B. Server name

  C. Table definitions

  D. Buffering settings

  E. Error log directory

  Correct Answer: AD

• Question 84:

  Which method is used to specify when to stop a job because of too many rejected rows with an ODBC Connector?

  A. In the Abort when field, select Max

  B. In the Abort when field, select Rows

  C. In the Abort when field, select Count

  D. In the Abort when field, select Amount

  Correct Answer: B

• Question 85:

  Which step is required to change from a normal lookup to a sparse lookup in an ODBC Connector stage?

  A. Change the partitioning to hash.

  B. Sort the data on the reference link.

  C. Change the lookup option in the stage properties to "Sparse".

  D. Replace columns at the beginning of a SELECT statement with a wildcard asterisk (*).

  Correct Answer: C

• Question 86:

  Which two statements are true about the use of named node pools? (Choose two.)

  A. Grid environments must have named node pools for data processing.

  B. Named node pools can allow separation of buffering from sorting disks.

  C. When named node pools are used, DataStage uses named pipes between stages.

  D. Named node pools limit the total number of partitions that can be specified in the configuration file.

  E. Named node pools constraints will limit stages to be executed only on the nodes defined in the node pools.

  Correct Answer: BE

• Question 87:

  Suppose a user ID has been created with DataStage and QualityStage component authorization. Which client application would be used to give that user ID DataStage Developer permission?

  A. DataStage Director client

  B. DataStage Designer client

  C. DataStage Administrator client

  D. Information Server Web Console Administrator client

  Correct Answer: C

• Question 88:

  Which two data repositories can be used for user authentication within the Information Server Suite? (Choose two.)

  A. IIS Web Console

  B. IBM Metadata repository

  C. Standalone LDAP registry

  D. Operations Console database

  E. IBM Information Server user directory

  Correct Answer: CE

• Question 89:

  What is the purpose of the APT_DUMP_SCORE environment variable?

  A. There is no such environment variable.

  B. It is an environment variable that turns on the job monitor.

  C. It is an environment variable that enables the collection of runtime performance statistics.

  D. It is a reporting environment variable that adds additional runtime information in the job log.

  Correct Answer: D

• Question 90:

  Which two statements are true about stage variables in a Transformer Stage? (Choose two.)

  A. Stage variables can be set to NULL.

  B. Stage variables cannot be set to NULL.

  C. Varchar stage variables can be initialized with spaces.

  D. Stage variables are refreshed with default values before each new input row is processed.

  E. A stage variable in one Transformer can refer to a stage variable in another Transformer, as long as the second Transformer was processed earlier in the job flow.

  Correct Answer: AC