0

technology Online Quiz - 1555

Description: technology Online Quiz - 1555
Number of Questions: 20
Created by:
Tags: technology
Attempted 0/20 Correct 0 Score 0

Which of the following is valid about shared containers?

  1. These are reusable job elements.

  2. They can only be used within a project

  3. When shared containers are modified. Modifications are reflected in all the jobs that use them.

  4. None of the above


Correct Option: C
  1. What are the ways to execute datastage jobs? a. From Datastage Director (menu Job -> Run now...) b. From command line using a dsjob command c. Datastage routine can run a job (DsRunJob command) d. By a job sequencer
  1. a, b & d

  2. a & b

  3. a & d

  4. a, b, c &d


Correct Option: D

How copying of data between Parallel Stage Operators be minimized

  1. Combinability mode

  2. Preserve partitioning

  3. Execution Mode

  4. Don’t combine mode


Correct Option: B

A graph parameter whose value can be overwritten with user input is a formal parameter

  1. True

  2. False


Correct Option: A

A rule is an instruction in a transform function that directs the construction of one field in an output record

  1. True

  2. False


Correct Option: A

Choose package file extensions

  1. mp

  2. cfg

  3. xfr

  4. dml


Correct Option: C,D

At phase break temporary files are written in the layout of component upstream of the phase break

  1. True

  2. False


Correct Option: B

Subgraphs and Macros are both reusable graph segments constructed with Ab Initio pre-built components.

  1. True

  2. False


Correct Option: A

which one is not a dedup sort parameter

  1. select

  2. output_select

  3. keep

  4. check-sort


Correct Option: B

Select the odd man out

  1. Broadcast

  2. Replicate

  3. Partition by Round-Robin

  4. Partition by Key


Correct Option: B

which one is not a defined component tolerance for reject event.

  1. Abort on first reject

  2. Never abort

  3. Abort on predefiend event

  4. Use limit/ramp


Correct Option: C

Checkpointed Sort sorts and merges data records, inserting a checkpoint between the sorting and merging phases.

  1. True

  2. False


Correct Option: A

AI Explanation

To answer this question, let's understand the concept of Checkpointed Sort.

Checkpointed Sort is a technique used in distributed systems to efficiently sort and merge data records. It involves inserting a checkpoint between the sorting and merging phases to ensure fault tolerance and recovery.

During the sorting phase, the data records are divided into smaller chunks and sorted independently on different nodes or processors. Once the sorting is complete, a checkpoint is inserted to mark the progress made so far.

In the merging phase, the sorted chunks are combined and merged to produce the final sorted output. If a failure occurs during the merging phase, the system can recover by starting from the last checkpoint and resume the merging process.

Therefore, the statement "Checkpointed Sort sorts and merges data records, inserting a checkpoint between the sorting and merging phases" is true. The checkpoint ensures fault tolerance and recovery in case of failures during the merging phase.

Whats ICONV?

  1. Converts string to user defined format.

  2. Converts string to internal storage format.

  3. Converts internal storage format to String.

  4. None of the above


Correct Option: B

Is it possible to run a server job in parallel mode?

  1. True

  2. False


Correct Option: A

Environment Variables can be over-ridden at the job level?

  1. True

  2. False


Correct Option: A

Which of the following Stages have Reject link option?

  1. Transformer Stage

  2. Join Stage

  3. Lookup Stage

  4. Merge Stage


Correct Option: A,C,D

Which of the following Stages do not transform the data?

  1. Transform Stage

  2. Sort Stage

  3. File Stage

  4. Copy Stage


Correct Option: B,C,D

What is the default DataStage cache size?

  1. 256 MB

  2. 128 MB

  3. 64 MB

  4. 512 MB


Correct Option: A

AI Explanation

To answer this question, you need to have knowledge of IBM InfoSphere DataStage, which is a data integration and transformation tool.

The default DataStage cache size is 256 MB.

Option A) 256 MB - This option is correct because it represents the default DataStage cache size. Option B) 128 MB - This option is incorrect because it does not represent the default DataStage cache size. Option C) 64 MB - This option is incorrect because it does not represent the default DataStage cache size. Option D) 512 MB - This option is incorrect because it does not represent the default DataStage cache size.

The correct answer is A) 256 MB. This option is correct because it represents the default DataStage cache size.

How do you execute Datastage job from command line prompt?

  1. dsjob run

  2. dsjobrun

  3. dsjob -run

  4. run jobname


Correct Option: C

AI Explanation

To execute a Datastage job from the command line prompt, you can use the "dsjob" command with the "-run" option.

The correct answer is C) dsjob -run.

Here is an explanation of each option:

A) dsjob run - This option is incorrect because the correct syntax is "dsjob -run".

B) dsjobrun - This option is incorrect because it does not follow the correct syntax. The correct syntax is "dsjob -run".

C) dsjob -run - This option is correct. The "-run" option is used to execute a Datastage job from the command line prompt.

D) run jobname - This option is incorrect because it does not follow the correct syntax. The correct syntax is "dsjob -run".

Therefore, the correct answer is C) dsjob -run.

How to manage Datastage DataSets?

  1. Datastage Designer GUI

  2. orchadmin Command

  3. dsrecords Command

  4. all of the above


Correct Option: D
- Hide questions