Online Access Free 000-421 Practice Test

You are responsible for the projects Source Code Repository. When a developer notifies you that changes are ready to deploy you must first check them in. You will use the Information Server Source Code integration features to check in the changed assets. How will you identify the DataStage assets the developer modified in order to send them to the workspace?

• A.From the Information Server Manager Select the project then right-click on Synchronize with source code control system.
• B.From the workspace perspective select the project Right-click then Refresh from repository, specify a modification date and the developer's username in the Modified by fields.
• C.From Information Server Manager use Search with advanced options, specify a date modified and the developer's user name in the Modified by fields.
• D.Use Designer client Advanced Find, specify a modification date and the developer's username in the Modified by fields.

How is Runtime Column Propagation (RCP) enabled for use in DataStage Jobs?

• A.Use the DataStage Administrator to enable RCP for the project.
• B.Use the Info Server web console to enable RCP
• C.Use RCP definition wizard to initialize RCP for project use.
• D.RCP is by default available for all DataStage Projects.
• E.Set the APT_ENABLE_RCP environment variable to TRUE.

Which three of the following options does the dsjob command have? (Choose three.)

• A.Listing projects, jobs, stages, links, and parameters
• B.Setting an alias for a job
• C.Stopping a job
• D.Specifying an appropriate log file

What are the three features of Information Server that allow you to deploy DataStage objects? (Select three)

• A.$APT_COPY_TRANSFORMER
• B.Designer Client Export
• C.istool
• D.Information Server Manager
• E.dscc.exe

Rows of data going into a Transformer stage are sorted and hash partitioned by the Input.Product column. Using stage variables, how can you determine when a new row is the first of a new group of Product rows?

• A.Create a stage variable named sv_Product and follow it by a second stage variable named
  sv_IsNewProduct . Map the Input.Product column to
  sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product = sv_Product THEN "YES"
  ELSE "NO".
• B.Create a stage variable named sv_IsNewProduct and follow it by a second stage variable
  named sv_Product. Map the Input.Product column to
  sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product <> sv_Product THEN "YES"
  ELSE "NO".
• C.Create a stage variable named sv_IsNewProduct and follow it by a second stage variable
  named sv_Product. Map the Input.Product column to
  sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product = sv_Product THEN "YES"
  ELSE "NO".
• D.Create a stage variable named sv_Product and follow it by a second stage variable named
  sv_IsNewProduct . Map the Input.Product column to
  sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product <> sv_Product THEN "YES"
  ELSE "NO".