最新のC2090-424問題集で試験を準備する

Which of the following will determine the running row number within a group?

• A. Insert an Aggregator stage, hashing on the key column, prior to the Transformer stage
• B. Use a Surrogate Key Generator stage to generate the running row number prior to the Transformer stage
• C. Use a Sort stage prior to the Transformer stage based on the key break column. Then, use the LastRowinGroup() function to determine the last row in a group
• D. Use a Remove Duplicates stage prior to the Transformer stage based on the key column, with the Duplicate set to retain = last option

Which statement about looping in sequences is TRUE?

• A. The compiler will insert an End Loop as the last stage in the sequence if one is omitted
• B. Numeric loops must increment by one unless you supply a parameter
• C. The current loop counter value can be passed to the stages in the loop
• D. The Start Loop stage only supports numeric loops

Which statement about restartable sequence jobs is TRUE?

• A. Choosing "Reset job" from Director will start the job where it left off.
• B. If a restartable sequence aborts, it can be restarted from Director.
• C. Checkpoints are always added to every eligible Job Activity stage in the sequence.
• D. There is no way to force a Job Activity stage to return if the sequence got beyond it.

Which type of data can be extracted using the Unstructured Data stage?

• A. XML data
• B. Microsoft Excel data
• C. BigInsights HDFS file data
• D. Microsoft Word data

Which stages will require a schema file when runtime column propagation (RCP) is enabled? (Choose two.)

• A. Column Import
• B. External Target
• C. Internal Source
• D. Data Set
• E. Make Subrecord