A2090-421 Exam Training Practice Tests (IBM Assessment: InfoSphere DataStage v8.5)]

Question 1

You are setting up a clustered environment. Each node in the cluster has public and private network adapters. The private network uses fast Ethernet. Which two statements are true? (Select two)

A. The client machines on the public network must use the host name for the engine on the private network to connect. B. Using the host names on the private network for 'fastname' makes better performance. C. You must use APT_PM_CONDUCTOR_HOSTNAME variable for optimal environment. D. Host name alias is not allowed for conductor node.

Correct Answer: B,C

Question 2

You are connected to a domain and must configure it for Source Code Integration.
What are the two things that must be done to associate your DataStage repository with a source control system? (Select two)

A. From Designer Client choose Team Share Project. B. From Information Server Manager choose Team Share Project. C. From Information Server Manager choose Team Import. D. Create a source code control project with the same name as the domain. Choose Integrate Source Control.

Correct Answer: C,D

Question 3

A job contains a Sort stage that sorts a large volume of data across a cluster of servers. Due to new requirements, the customer has requested that this sorting be done on a subset of servers identified in the configuration file to minimize impact on database nodes. The $APT_CONFIG_FILE shows no sort disk pool for any node. Which two steps will accomplish this? (Choose two.)

A. Create a sort scratch disk pool with a subset of nodes in the parallel configuration file. B. Use the environment variable $APT_SCRATCH_SPACE_SORT_USAGE. C. Have an appropriate node constraint within the Sort stage. D. Assign a separate config file just for the Sort stage. E. Define a non-default node pool with a subset of nodes in the parallel configuration file.

Correct Answer: C,E

Question 4

The Teradata Enterprise stage uses a distributed FastExport to access data. What is a limitation to distributed FastExport?

A. Non-data access (e.g., pseudo-tables like DATE or USER) is allowed. B. The use of the USING modifier is allowed. C. Aggregates and most arithmetic operators in the SELECT statement are allowed. D. Multiple-AMP requests are allowed.

Correct Answer: D

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 5

Your job is using the DB2 Enterprise stage as a target. In this job you are inserting data into a single existing table on a remote database. You are using Run-Time Column Propagation (RCP) on all of the links.
Which two job design configuration actions would you consider to effectively use RCP? (Select two)

A. Use DB2 partitioning properties on the input link to the DB2 Enterprise stage to control column layout in partitions. B. Use a Modify stage prior to the DB2 Enterprise stage in order to drop the columns not found in the table. C. In the DB2 Enterprise stage use Connection properties to manage column mappings. D. In the DB2 Enterprise stage set the option named "Silently Drop Columns Not in Table" to "True".

Correct Answer: A,D

Question 6

You are given a job requirement that requires calculations based on the latest currency exchange rate. You decide to invoke a Web service to obtain the latest exchange rate.
What are two ways that you can perform a Web service invocation in a DataStage job to obtain the latest exchange rate? (Select two)

A. Use Web Services Transformer stage. B. Use WISD Input stage. C. Call a Web Service using a DSRoutine inside the Parallel Transformer stage. D. Use Web Services Client stage as a lookup.

Correct Answer: A,D

Question 7

Which two statements about annotations are correct? (Select two)

A. The Full job description field is only visible within the Designer Client. B. The Short job description field will appears in job log when $APT_PM_SHOW_PIDS is set. C. An annotation can be drawn around one of more stages. D. The Short job description field displays on log summary lines within Director client.

Correct Answer: B,C

Question 8

Refer to the exhibit.

You submit a job from DataStage Director and then log onto your DataStage Linux server to issue the command "ps-ef | grepds" and receive the following screen:
Which process is the section leader for node2?

A. 7221 B. 7219 C. 7220 D. 7216

Correct Answer: A

Question 9

You have a job that reads in Sequential File followed by a Transformer stage. When you run this job, which partitioning method will be used by default?

A. Round Robin B. Same C. Random D. Hash

Correct Answer: A

Question 10

Which two tasks can the Slowly Changing Dimensions (SCD) stage perform? (Choose two.)

A. Look up whether a record with a matching business key value exists in a dimension table. If it does, add new values for selected fields to values lists for those fields. B. Look up whether a record with a matching business key value exists in a dimension table. If it does not, retrieve a new surrogate key value and insert a new row into the dimension table. C. Look up whether a record with a matching business key value exists in a dimension table. If it does, mark the record as not-current, and generate a new record with new values for selected fields. D. Look up whether a record with a matching business key value exists in a fact table. If it does not, retrieve a new surrogate key value and insert a new row into the fact table.

Correct Answer: B,C

Question 11

You are using the Change Capture stage in your job design to identify changes made to the input link (before image) to obtain the results in the output link. This job will be using a multi-node configuration file when executed.
What are two requirements on the input link data for the Change Capture stage? (Select two)

A. Sorted B. Key partitioned C. Merged links D. Sequential mode

Correct Answer: C,D

IBM Assessment: InfoSphere DataStage v8.5 - A2090-421 Exam Practice Test