IBM C2090-421 Online Practice Questions and Exam Preparation

IBM C2090-421 Online Questions & Answers

• Question 161:

  You are connected to a domain and must configure it for Source Code Integration. What are the two things that must be done to associate your DataStage repository with a source control system? (Select two)

  A. From Designer Client choose Team Share Project.
  B. From Information Server Manager choose Team Import.
  C. From Information Server Manager choose Team Share Project.
  D. Create a source code control project with the same name as the domain. Choose Integrate Source Control.
  B. From Information Server Manager choose Team Import.
  D. Create a source code control project with the same name as the domain. Choose Integrate Source Control.

• Question 162:

  You have run ten instances of the same job the previous evening. You want to examine the job logs for all instances but can only find five of them. How can you avoid this in the future for this job?

  A. Change the Auto-purge settings in Administrator.
  B. Change the Auto-purge settings for the job in Director.
  C. Set the $APT_AUTOPURGE_LOG environment variable to False.
  D. Set the $APT_AUTOLOG_PURGE environment variable to False.
  B. Change the Auto-purge settings for the job in Director.

• Question 163:

  How is DataStage Table Metadata shared among DataStage projects?

  A. DataStage Tables cannot be shared between projects.
  B. Import another copy of the table metadata into the project where it is required.
  C. Use the "Shared Table Creation Wizard" to create a copy of the table in the shared repository.
  D. Export DataStage Table Definitions from one project and importing them into another project.
  E. Use the Import/Export Manager to move the DataStage Table Definition to the projects where it is needed.
  C. Use the "Shared Table Creation Wizard" to create a copy of the table in the shared repository.

• Question 164:

  You have a dataset hash-partitioned and sorted on CustID. You need to create a Sequential File sorted on CustID from this dataset. Which technique is the most appropriate?

  A. Use Copy stage.
  B. Use SortMerge collector for the Sequential File input link.
  C. Insert Sort stage before the final Sequential File stage and use Ordered collector for the Sequential File stage input link.
  D. Insert Sort stage before the final Sequential File stage and use Round Robin collector for the Sequential File stage input link.
  B. Use SortMerge collector for the Sequential File input link.

• Question 165:

  You are setting up project defaults. Which three items can be set in DataStage Administrator? (Choose three.)

  A. suite roles
  B. default for compile options
  C. defaults for environment variables
  D. default for Runtime Column Propagation
  E. default prompting options,such as Autosave job before compile
  B. default for compile options
  C. defaults for environment variables
  D. default for Runtime Column Propagation

• Question 166:

  You are using the Change Capture stage in your job design to identify changes made to the input link (before image) to obtain the results in the output link. This job will be using a multi-node configuration file when executed.

  What are two requirements on the input link data for the Change Capture stage? (Select two)

  A. Sorted
  B. Merged links
  C. Key partitioned
  D. Sequential mode
  B. Merged links
  D. Sequential mode

• Question 167:

  In which two situations would you use the Web Services Client stage? (Choose two.)

  A. You need to create a WSDL.
  B. You want to deploy a service.
  C. You do not need both input and output links in a single web service operation.
  D. You need the Web service to act as either a data source or a data target during an operation.
  C. You do not need both input and output links in a single web service operation.
  D. You need the Web service to act as either a data source or a data target during an operation.

• Question 168:

  Which two features of Data Sets make them suitable for job restart points? (Choose two.)

  A. They are persistent.
  B. They are indexed to improve access.
  C. They are compressed to minimize storage space.
  D. They use the same data types as the parallel framework.
  A. They are persistent.
  D. They use the same data types as the parallel framework.

• Question 169:

  You are asked to convert a relational source, as shown in the exhibit, into three separate XML files. How would you accomplish this task?

  

  A. Set "Output mode" setting" Split rows" under "Transformation Settings" of the Output link of an XML Output stage.
  B. Set "Output mode" setting "Single row" under "Transformation Settings" of the Output link of an XML Output stage.
  C. Set "Output mode" setting "Segregate" on column "Customer ID" under "Transformation Settings" of the Output link of an XML Output stage.
  D. Set "Output mode" setting "Break" on column "Customer ID" under "Transformation Settings" of the Output link of an XML Output stage.
  B. Set "Output mode" setting "Single row" under "Transformation Settings" of the Output link of an XML Output stage.

• Question 170:

  Which requirement must be met to read from a database in parallel using the ODBC connector?

  A. ODBC connector always reads in parallel.
  B. Set the Enable partitioning property to Yes.
  C. Configure environment variable $APT_PARTITION_COUNT.
  D. Configure environment variable $APT_MAX_TRANSPORT_BLOCK_SIZE.
  B. Set the Enable partitioning property to Yes.