IBM Certified Solution Developer - IBM InfoSphere DataStage (000-303) Free Practice Test

Question 1

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

A. ODBC connector always reads in parallel.

B. Configure environment variable $APT_MAX_TRANSPORT_BLOCK_SIZE.

C. Configure environment variable $APT_PARTITION_COUNT.

D. Set the Enable partitioning property to Yes.

Correct Answer: D

Question 2

Your customer is using Source Code Control Integration for Information server and have tagged artifacts for version 1. You must create a deployment package from the version 1. Before you create the package you will have to ensure the project is up to date with version 1. What two things must you do to update the meta-data repository with the artifacts tagged as version 1? (Choose two.)

A. Right-click the asset and click Replace From Source Control Workspace.

B. Right-click the asset and click Update From Source Control Workspace.

C. Right-click the asset and click the Team command to update the Source Control Workspace with the asset.

D. Right-click the asset and click the Deploy command.

E. Right-click the asset and click the Team Import command.

Correct Answer: A,C

Question 3

Which option is required to identify a particular job player processes?Which option is required to identify a particular job? player processes?

A. Set $APT_DUMP_SCORE to true.

B. Use the DataStage Director Job administration screen to display active player processes.

C. Log onto the server and issue the command "ps -ef | grep ds".

D. Set $APT_PM_SHOW_PIDS to true.

Correct Answer: D

Question 4

What are the valid join operations for the Join stage? (Choose two.)

A. Inner join

B. Where join

C. Top outer join

D. Bottom inner join

E. Right outer join

Correct Answer: A,E

Question 5

Which statement is true about table definitions created in DataStage Designer?

A. Table definitions created in DataStage Designer are local to DataStage and cannot be shared with other Information Server products.

B. By default, table definitions created in DataStage Designer are visible to other Information Server products.

C. When a table definition is created in one DataStage project, it is automatically available in other DataStage projects, but not outside of DataStage.

D. Table definitions created in DataStage Designer are not by default available to other Information Server products, but they can be shared with other Information Server products.

Correct Answer: D

Question 6

Click the Exhibit button.

The job in the exhibit runs to successful completion with no warnings. However, a validation test identifies that the CUSTOMER_MASTER table is empty. You suspect the cause to be related to the NEW_CUSTOMERS table or a defect in the job. Examining runtime metadata may help you track down the problem. Which two product features will help you isolate the cause of the problem? (Choose two.)

A. The view data button in the target Connector stage.

B. Designer "Show performance statistics" option.

C. Director job monitor tool.

D. Designer Performance Analyzer tool.

E. InfoSphere Metadata Asset Manager (IMAM) operational metadata reports.

Correct Answer: B,C

Question 7

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 Count

B. In the Abort when field, select Rows

C. In the Abort when field, select Max

D. In the Abort when field, select Amount

Correct Answer: B

Question 8

You are editing the configuration file. Which statement is true about file system efficiency?

A. Creating scratch disk spaces on an internal disk rather than on an NFS drive improves sort performance.

B. In a clustered environment where NAS is used for a common storage, you must specify the internal disk for scratch disk.

C. For the resource disk, it is best to use the partition where the engine is installed.

D. Using multiple scratch spaces in a logical node improves performance.

Correct Answer: A

Welcome to TestSimulate

IBM Certified Solution Developer - IBM InfoSphere DataStage (000-303) Free Practice Test