0

technology Online Quiz - 1559

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

These are created separately and are stored in the Repository

  1. Shared container

  2. Local container

  3. Both

  4. None of the above


Correct Option: A
  1. Constraints -->Derivations-->Stage variables

  2. Constraints -->Stage variables-->Derivations

  3. Derivations-->Stage variables-->Constraints

  4. Stage variables-->Constraints -->Derivations


Correct Option: D

Which two statements are true about the join stage?

  1. All the inputs to join stage must be sorted by join key

  2. The join stage supports inner, left outer, and right outer joins

  3. Both

  4. None of the above


Correct Option: C

Which stage allows field names to be specified using job parameters?

  1. Funnel stage

  2. Transformer stage

  3. None of the above

  4. Filter stage


Correct Option: D

Which “Reject Mode” option in the sequential File Stage will write records to a reject link?

  1. Output

  2. Fail

  3. Drop

  4. Continue


Correct Option: A

AI Explanation

To answer this question, we need to understand the concept of "Reject Mode" in the sequential File Stage.

The "Reject Mode" option in the sequential File Stage determines how the stage handles records that do not meet the specified criteria or fail to be processed successfully.

Let's go through each option to understand why it is correct or incorrect:

Option A) Output - This option is correct because selecting the "Output" reject mode will write the rejected records to a reject link. This means that any records that do not meet the specified criteria or fail during processing will be sent to the reject link for further analysis or handling.

Option B) Fail - This option is incorrect because selecting the "Fail" reject mode will cause the job to fail when a record is rejected. It does not write the rejected records to a reject link.

Option C) Drop - This option is incorrect because selecting the "Drop" reject mode will simply discard the rejected records. It does not write them to a reject link for further analysis or handling.

Option D) Continue - This option is incorrect because selecting the "Continue" reject mode will allow the job to continue processing even when a record is rejected. It does not write the rejected records to a reject link.

The correct answer is Option A) Output. This option is correct because it will write the rejected records to a reject link for further analysis or handling.

Which one is keyless partitioning method?

  1. Modulus

  2. Hash

  3. Both

  4. None of the above


Correct Option: D

What is the use of job activity stage?

  1. Specifies an operating system command to execute.

  2. Specifies a DataStage server or parallel job.

  3. Both

  4. None of the above


Correct Option: B
  1. Pipeline

  2. Partitioning

  3. Node

  4. None of the above


Correct Option: A,B
  1. Single mode processing

  2. Symmetric multiprocessing

  3. Multi parallel processing

  4. Cluster or MPP


Correct Option: B,D

DataStage learns about the shape and size of the system from?

  1. Hash file

  2. System file

  3. Configuration file

  4. None of the above


Correct Option: C
  1. A function can be executed once per record

  2. A function can be executed once per run

  3. Identify the first row of an input group

  4. All the Above

  5. None of the above


Correct Option: D

We can’t export metadata, such as field definitions of a sequential file?

  1. True

  2. False

  3. Depends on project

  4. Depends on file


Correct Option: B

What is the default data type produced by the Aggregator stage?

  1. Integer

  2. Douple precision floating point

  3. Single precision floating point

  4. None of the above


Correct Option: B
  1. Constraints

  2. Derivations

  3. Directory and file names

  4. All of the above


Correct Option: D

Annotation stage is used for _________ process.

  1. Extraction

  2. Transformation

  3. Loading

  4. Documentation


Correct Option: D

Using DataStage Director, we __________ a job.

  1. Can compile but can’t run

  2. can run but can’t compile

  3. can compile and run

  4. can’t compile or run


Correct Option: B

Which handles the process of scheduling, running and monitoring jobs?

  1. DataStage Administrator

  2. DataStage Director

  3. DataStage Designer

  4. All the Above


Correct Option: B

Which is the best partition technique we will use for join stage?

  1. Round robin

  2. Auto

  3. Hash

  4. Entire


Correct Option: C
- Hide questions