Online Access Free C2090-421 Practice Test

Which condition is required to use the LastRowInGroup() function to determine a key break on a field?

• A.The input data has to be sorted by the key field, but it is not required that DataStage be able to detect this. For example, the input data might be sorted before it is input to the job. (However, the job will abort at runtime if the data isn't sorted.)
• B.The input data has to be sorted by the key field and DataStage must be able to detect that the data is sorted, for example, by the presence of a Sort stage.
• C.The LastRowInGroup() function does not require the data to be either sorted or grouped by the key field. If necessary the LastRowInGroup() function will perform a sort.
• D.The LastRowInGroup() function requires the data to be grouped by the key field, but the data does not have to be sorted.

In your DB2 database you have column names that use characters # and $. Which two steps should be completed to allow DataStage to convert these characters into internal format and back as necessary? (Select two)

• A.Set environment variable $DS_ENABLE_RESERVED_CHAR_CONVERT to true.
• B.Avoid using the strings_025_and_026_in your IBM DB2 column names.
• C.Set environment variable $DS_ENABLE_RESERVED_NUM_CONVERT to true.
• D.Avoid using the strings_035_and_036_in your IBM DB2 column names.

Which two partitioning methods require keys? (Choose two.)

• A.Modulus
• B.Hash
• C.Round Robin
• D.Entire

You have a dataset that is range-partitioned and sorted. Which technique is most efficient to create globally sorted data file?

• A.Insert Funnel stage before the final Sequential File stage and select Sequence as Funnel Type.
• B.Select Ordered collector method for the input link of the final Sequential File stage.
• C.Select SortMerge collector method for the input link of the final Sequential File stage.
• D.Insert Funnel stage before the final Sequential File stage and select Sort Funnel as Funnel Type.

In which two situations is it appropriate to use a Sparse Lookup? (Choose two.)

• A.When invoking a stored procedure within a database per row in the streaming link.
• B.When accessing DB2 data using the DB2 API stage.
• C.When reference data is significantly larger than the streaming data (100:1).
• D.When the output of the Lookup stage needs to be hashed partitioned.