最新的IBM A2090-421免費考試真題

問題1

The DB2 and Oracle Enterprise stages support logged and non-logged DBMS table operations. What is the non-logged operation that is supported by the DB2 and Oracle Enterprise stages?

A. Delete

B. Insert

C. Load

D. Update

正確答案: C

問題2

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. 7216

B. 7219

C. 7221

D. 7220

正確答案: C

問題3

You are processing groups of rows in a Transformer. The first row in each group contains "1" in the Flag column and "0" in the remaining rows of the group. At the end of each group you want to sum and output the QTY column values. Which three techniques will enable you to retrieve the sum of the last group? (Choose three.)

A. Output the sum that you generated up to the previous row each time you process a row with a "1" in the Flag column. Use the LastRow() function to determine when the last group is done.

B. Output the sum that you generated each time you process a row for which the LastRow() function returns True.

C. Within each group sort the Flag column in ascending order. Output the sum each time you process the row with a "1" in the Flag column.

D. Output a running total for each group for each row. Follow the Transformer stage by an Aggregator stage. Take the MAX of the QTY column for each group.

E. Output the sum that you generated up to the previous row each time you process a row with a "1" in the Flag column.

正確答案: A,C,D

問題4

Input rows to a Transformer contain a product name field and a field with a list of colors the product can be ordered with. The colors are separated by the pipe character (|). Here is an example of an input row: "Shirt"| ....| "Red, Blue, Black"|... For each input row, you want to output multiple output rows, one for each color in the list. For the above example input row, three rows are to be output, one per color: "Shirt" ... "Red", "Shirt" ... "Blue", "Shirt" ... "Black".
Which three operations will you need to accomplish this? (Choose three.)

A. Use the SaveInputRecord() to save the input row for processing in the loop. Use the GetInputRecord() to extract the row for each iteration of the loop.

B. Use the @ITERATION variable to determine which color in the ColorList field to extract using the Field function.

C. Use the Count() function over the ColorList field to determine the number of loop iterations.

D. Use the LastRowInGroup() function to determine when the last color in the color list has been processed.

E. Specify the following loop condition: @ITERATION <= n, where n is a stage variable initialized with number of loop iterations.

正確答案: B,C,E

問題5

In a Transformer expression for a stage variable, there is a nullable input column. What happens when a row is processed that contains NULL in that input column?

A. The value written to the stage variable is undetermined.

B. NULL is written to the stage variable.

C. The job aborts.

D. The row is rejected.

正確答案: B

問題6

A scenario requires selecting only the most recent transactions for each of 2 million unique customers, from a 20 million row DB2 source table containing order history. Which parallel job design would satisfy this functional requirement?

A. Using the DB2 API stage, select all rows. Use a Sort stage with customer number and order date sort keys in ascending order, then Remove Duplicates with Last Duplicate to retain.

B. Using the DB2 Enterprise stage, select all rows. Perform a unique Sort using customer number and order date sort keys in ascending order.

C. Using the Dynamic Relational stage, use custom SQL to select all DISTINCT customer numbers from the order history table.

D. Select all rows using the ODBC Connector stage, use a Sort Aggregator on customer number key to select the maximum order date.

正確答案: A

問題7

Which statement is true about the Web Services Pack?

A. Web Services Pack communicates by Enterprise Java Beans.

B. Web Services Pack generates a WSDL.

C. Web Services Pack is configured from within the Information Services Director application.

D. Web Services Pack makes a service request using SOAP.

正確答案: D

問題8

Rows of data going into a Transformer stage are sorted and hash partitioned by the Input.Product column. Using stage variables, how can you determine when a new row is the first of a new group of Product rows?

A. Create a stage variable named sv_IsNewProduct and follow it by a second stage variable
named sv_Product. Map the Input.Product column to
sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product = sv_Product THEN "YES"
ELSE "NO".

B. Create a stage variable named sv_Product and follow it by a second stage variable named
sv_IsNewProduct . Map the Input.Product column to
sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product = sv_Product THEN "YES"
ELSE "NO".

C. Create a stage variable named sv_Product and follow it by a second stage variable named
sv_IsNewProduct . Map the Input.Product column to
sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product <> sv_Product THEN "YES"
ELSE "NO".

D. Create a stage variable named sv_IsNewProduct and follow it by a second stage variable
named sv_Product. Map the Input.Product column to
sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product <> sv_Product THEN "YES"
ELSE "NO".

正確答案: D

問題9

Which three actions can improve sort performance in a DataStage job? (Choose three.)

A. Minimize the number of sorts used within a job flow.

B. Specify only the key columns which are necessary.

C. Adjust the "Restrict Memory Usage" option in the Sort stage.

D. Use the stable-sort option to avoid the random ordering of non-key data.

E. Run the job sequentially so that only one sort process is invoked.

正確答案: A,B,C

問題10

Which two statements are true regarding access to a MQ queue? (Choose two.)

A. MQ stage and MQ connector stages support destructive reads.

B. MQ plugin stage can be used to read and write messages from a remote MQ message queue.

C. MQ stage connects to a queue manager in Client mode only.

D. MQ connector stage is capable of connecting to Queue manager in both Server and Client mode.

正確答案: A,D

問題11

The result of a performance review for one of your job designs indicated this job needs to be split into two separate jobs. You also have been given the requirement to ensure you maintain parallelism (no re-partitioning) between these two new jobs.
Which single stage should you consider to accomplish maintaining parallelism and not introduce re-partitioning between these related jobs?

A. Copy stage

B. Sequential File stage

C. Named Pipe stage

D. Data Set stage

正確答案: B

說明：（僅 Fast2test 成員可見）

問題12

How is DataStage Table Metadata shared among DataStage projects?

A. DataStage Tables cannot be shared between projects.

B. Export DataStage Table Definitions from one project and importing them into another project.

C. Use the Import/Export Manager to move the DataStage Table Definition to the projects where it is needed.

D. Use the "Shared Table Creation Wizard" to create a copy of the table in the shared repository.

E. Import another copy of the table metadata into the project where it is required.

正確答案: D

最新的IBM Assessment: InfoSphere DataStage v8.5 - A2090-421免費考試真題

聯系我們

站內鏈接

最新更新