ExamTopics Logo
Mail Us[email protected]
Menu
 

C2090-424 Actual Exam Questions

Last updated on Dec. 15, 2024.
Vendor:IBM
Exam Code:C2090-424
Exam Name:InfoSphere DataStage v11.3
Exam Questions:64
97% Passed the exam with this material
 

Topic 1 - Single Topic

Question #1 Topic 1

Assume you have before and after data sets and want to identify and process all of the changes between the two data sets. Assuming data is properly partitioned and sorted, which of the following should be used?

  • A. Difference
  • B. Change Apply
  • C. Change Capture
  • D. Change Capture and Change Apply
Reveal Solution Hide Solution   Discussion   4

Correct Answer: C 🗳️
Reference: https://www-01.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.ds.parjob.dev.doc/topics/ c_deeref_Change_Capture_Stage.html

Question #2 Topic 1

In the Masking Policy Editor in the Data Masking stage of your job, you have specified for a column containing credit card numbers the Random Replacement masking policy. For the Copy option you have specified "(1,2)(3,4)".
What changes will be made to a credit card number, such as 6327664369, to mask it?

  • A. Digits 1 through 2 and digits 3 through 4 will be randomly changed. The rest of the digits will remain the same.
  • B. Digits 1 through 2 and digits 3 through 4 will remain the same. The rest of the digits will be randomly changed.
  • C. The 2 digits starting at digit 1 and the 4 digits starting at digit 3 will remain the same. The rest of the digits will be randomly changed.
  • D. The 2 digits starting at digit 1 and the 4 digits starting at digit 3 will be randomly changed. The rest of the digits will remain the same.
Reveal Solution Hide Solution   Discussion   1

Correct Answer: D 🗳️

Question #3 Topic 1

What is the primary advantage of creating data rules within Information Analyzer as opposed to creating them within the Data Rules stage?

  • A. Data rules cannot be created within the Data Rules stage. They must first be created in Information Analyzer before they can be used in the Data Rules stage.
  • B. Rules created within Information Analyzer can be tested and debugged on non-operational data in a testing environment before they are put into production.
  • C. Rules created in the DataStage Data Rules stage have to be compiled into an executable form before they can be used.
  • D. The variables in rules created in DataStage Data Rules stage must first be bound to data columns or literals before they can be run.
Reveal Solution Hide Solution   Discussion  

Correct Answer: B 🗳️

Question #4 Topic 1

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

  • A. Data Set
  • B. Column Import
  • C. Internal Source
  • D. External Target
  • E. Make Subrecord
Reveal Solution Hide Solution   Discussion   2

Correct Answer: BD 🗳️
Reference: https://www-01.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.ds.parjob.dev.doc/topics/ c_deeref_using_rcp_with_sequential_stages.html

file Viewing page 1 out of 16 pages.
Viewing questions 1-4 out of 64 questions
Next Questions
Browse atleast 50% to increase passing rate cup
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago