1. Home
  2. IBM
  3. C2090-424

IBM C2090-424 Online Practice Questions and Exam Preparation

C2090-424 Exam Details

  • Exam Code
    :C2090-424
  • Exam Name
    :InfoSphere DataStage v11.3
  • Certification
    :IBM Certifications
  • Vendor
    :IBM
  • Total Questions
    :64 Q&As
  • Last Updated
    :Jul 12, 2026

IBM C2090-424 Online Questions & Answers

  • Question 11:

    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

  • Question 12:

    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.

  • Question 13:

    Which partitioning method requires a key?

    A. Entire
    B. Same
    C. Range
    D. Random

  • Question 14:

    How do you create a shared table definition from the DataStage client?

    A. Use the save button on the columns tab of the stage editor
    B. Use the shared table creation wizard from the repository window
    C. Do nothing. They are created automatically when table definitions are imported
    D. It cannot be done within the DataStage client. Use the InfoSphere Metadata Asset Manager (IMAM) utility instead.

  • Question 15:

    Which one of the following is NOT an XML Pack stage?

    A. XML Input
    B. XML Output
    C. XML Connector
    D. XML Transformer

  • Question 16:

    Which statement about the ISD input stage is NOT TRUE?

    A. A job must have zero or one ISD input stages
    B. A job with an ISD input stage must have an ISD output stage
    C. Buffer size and timeout values can be supplied as job parameters
    D. Text over JMS binding is only available if you are using Network Deployment

  • Question 17:

    Which statement is TRUE?

    A. The configuration file needs to be copied to all processing nodes
    B. The configuration file needs to be copied to the conductor nodes and all processing nodes
    C. The configuration file needs to be copied to all nodes to which the parallel engine has been configured
    D. The configuration file only needs to be copied to the conductor nodes from which parallel engine applications are started

  • Question 18:

    Which of the following is TRUE about working with assets and artifacts?

    A. Rational Team Connect is not supported at all
    B. Information Server Manager has no logging capability
    C. You cannot lock and unlock assets in Rational Team Concert, regardless of tool used
    D. You must import the source control project into your own source control workspace in Information Server Manager before you can submit assets

  • Question 19:

    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.

  • Question 20:

    Which Slowly Changing Dimension (SCD) stage statement is TRUE?

    A. Surrogate keys are used to join a dimension table to a fact table in a normalized schema database
    B. Each SCD stage processes multiple dimensions and performs lookups by using an equality matching
    C. Purpose codes are part of the table metadata that the SCD stage propagates to the dimension insert link.
    D. Actual dimensions changes are applied to the lookup table in memory and are mirrored to the dimension update link

Related Exams:

Tips on How to Prepare for the Exams

Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only IBM exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your C2090-424 exam preparations and IBM certification application, do not hesitate to visit our Vcedump.com to find your solutions here.