C2090-303試験無料問題集（134題）「IBM InfoSphere DataStage v9.1 認定」

出題：1

In a Transformer, which two mappings can be handled by default type conversions. (Choose two.)

A. Date input column mapped to a string output column.

B. Integer input column mapped to raw output column.

C. String input column mapped to a date output column.

D. String input column mapped to integer output column.

E. Integer input column mapped to string output column.

正解：D,E 解答を投票する

出題：2

What is the result of running the following command: dsjob -report DSProject ProcData

A. Returns a report of the last run of the ProcData job in a DataStage project named DSProject.

B. Runs the DataStage job named ProcData and returns job status information, including whether the job aborted or ran without warnings.

C. Runs the DataStage job named ProcData and returns performance information, including the number of rows processed.

D. Generates a report about the ProcData job, including information about its stages and links.

正解：A 解答を投票する

出題：3

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 Amount

B. In the Abort when field, select Rows

C. In the Abort when field, select Count

D. In the Abort when field, select Max

正解：B 解答を投票する

出題：4

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 Designer client

B. DataStage Administrator client

C. DataStage Director client

D. Information Server Web Console Administrator client

正解：B 解答を投票する

出題：5

In your ETL application design you have found several areas of common processing requirements in the mapping specifications. These common logic areas found include: code validation lookups and name formatting. The common logic areas have the same logic, but the jobs using them would have different column metadata. Choose the action that gives you the best reusability design to effectively implement these common logic areas in your ETL application?

A. Create parallel shared containers with Runtime Column Propagation (RCP) ON and define only necessary common columns needed for the logic.

B. Create parallel routines for each of the common logic areas and for each of the unique column metadata formats.

C. Create parallel shared containers and define columns combining all data formats.

D. Create separate jobs for each layout and choose the appropriate job to run within a job sequencer.

正解：A 解答を投票する

出題：6

What stage allows for more than one reject link?

A. Lookup stage

B. Funnel stage

C. Merge stage

D. Join stage

正解：C 解答を投票する

出題：7

Which two environment variables add additional reporting information in the job log for DataStage jobs? (Choose two.)

A. $APT_EXPORT_FLUSH_COUNT

B. $APT_IO_MAP

C. $OSH_EXPLAIN

D. $APT_PM_STARTUP_CONCURRENCY

E. $APT_STARTUP_STATUS

正解：C,E 解答を投票する

出題：8

Each row contains the CustID, ProductID, ProductType and TotalAmount columns. You want to retain the record with the largest value in the TotalAmount column for each CustID and ProductType using a RemoveDuplicates stage. How can this be accomplished?

A. Hash-partition on TotalAmount. Sort on CustID, ProductType and TotalAmount.

B. Hash-partition on CustID. Sort on CustID, ProductType and TotalAmount.

C. Hash-partition on ProductType. Sort on ProductType, CustID and TotalAmount.

D. Hash-partition on CustID, ProductType and TotalAmount. Sort on CustID, ProductType and TotalAmount.

正解：B 解答を投票する

出題：9

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 the Deploy command.

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

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 Update From Source Control Workspace.

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

正解：C,E 解答を投票する

出題：10

What is the correct method to process a file containing multiple record types using a Complex Flat File stage?

A. Load a table definition for each record type on the Records tab of the Complex Flat File stage.

B. Flatten the record types into a single record type.

C. Manually break the file into multiple files by record type.

D. Define record definitions on the Constraints tab of the Complex Flat File stage.

正解：A 解答を投票する

C2090-303試験無料問題集「IBM InfoSphere DataStage v9.1 認定」