Data Stage Beginner Quiz

Posted on: | By: – Comments Off

Data Stage Beginner Quiz




1
Types of jobs in Datastage

  1. parallel
  2. sequence
  3. server
  4. all of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : all of the above[/bg_collapse]
 
2
Which type of join in Join stage return all rows that match the join condition, plus the unmatched rows from both input tables

  1. inner Join
  2. Left Outer Join
  3. Full Outer
  4. all of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Full Outer[/bg_collapse]
 
3
which  action for lookup failure in lookup stage will send the row to reject link

  1. Drop
  2. Continue
  3. Reject
  4. fail

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Reject[/bg_collapse]
 
4
Which funnel stage mode  copies all records from the first input data set to the output data set, then all the records from the second input data set, and so on.
 

  1. Sequence
  2. Sort
  3. Continuous
  4. all of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Sequence[/bg_collapse]
 
5
Output row only once option in Filter stage is

  1. Set to True to specify that rows are only output down the link of the first Where clause they satisfy.
  2. Set to false to have rows output down the links of all Where clauses that they satisfy.
  3. Set to true to output rows that satisfy no Where clauses down the reject link
  4. A and B

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A and B[/bg_collapse]
 
6
Which of the following activities allows one to specify the name of the job the activity is to run

  1. Exec Command Activity
  2. Job Actvity
  3. WaitforFile activity
  4. all of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Job Actvity[/bg_collapse]
 
7
Using Waitfor File Activity one can specify

  1. Wait for file to appear
  2. wait for file to disappear
  3. copy file to another location
  4. A and B

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A and B[/bg_collapse]
 
8
Which of the following can be used to filter input dataset

  1. Sequential File Stage
  2. filter Stage
  3. transformer Stage
  4. B and C

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B and C[/bg_collapse]
 
9
Which table action option in ODBC connector stage will diacard existing rows and append new rows

  1. Create
  2. append
  3. truncate
  4. none of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : truncate[/bg_collapse]



10
The Change Capture stage takes

  1. two input data sets, denoted before and after, and outputs a single data set whose records represent the changes made to the after data set to obtain the before data set
  2. two input data sets, denoted before and after, and outputs a single data set whose records represent the changes made to the before data set to obtain the after data set
  3. two input data sets, denoted before and after, and outputs a single data set whose records are union of both before and after dataset
  4. none of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : two input data sets, denoted before and after, and outputs a single data set whose records represent the changes made to the before data set to obtain the after data set[/bg_collapse]
 
11
Which one is true

  1. inner Join and drop option in lookup failure option will result in same output
  2. inner Join and continue option in lookup failure option will result in same output
  3. inner Join and fail option in lookup failure option will result in same output
  4. none of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : inner Join and drop option in lookup failure option will result in same output[/bg_collapse]
 
12
execute command activity can be used to execute

  1. Operating system command
  2. batch command file
  3. executable
  4. all of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : all of the above[/bg_collapse]
 
13
SCD stage has

  1. single input link, a single output link, a dimension reference link, and a dimension update link
  2. single input link, a single output link, a reject link, and a dimension update link
  3. single input link, a single output link, a dimension reference link, and a reject link
  4. all of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : single input link, a single output link, a dimension reference link, and a dimension update link[/bg_collapse]
 
14
SCD stages support

  1. Type 1 processing
  2. Type 2 Processing
  3. both SCD Type 1 and SCD Type 2 processing
  4. Type 3 Processing

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer :both SCD Type 1 and SCD Type 2 processing[/bg_collapse]
 
15
The aggregator stage gives

  1. access to grouping and summary operations
  2. access to perform joining of input datasets
  3. access to perform union of input datasets
  4. none of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : access to grouping and summary operations[/bg_collapse]
 
16
In which cases is the usage of sparse lookup appropriate ?

  1. Lookup on a flat file with sparse values
  2. Lookup on a database with sparse values
  3. Lookup on a large table
  4. Lookup on a table with few records

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Lookup on a large table[/bg_collapse]
 
17
Which partitioning technique is appropriate for aggregator stage ?

  1. Random
  2. Round Robin
  3. Hash
  4. All the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Hash[/bg_collapse]
 
18
Which partitioning technique is appropriate for sorting duplicate records ?

  1. Hash
  2. Round Robin
  3. Random
  4. Range

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Hash[/bg_collapse]
 
19
Which property is used to read set of files ?

  1. Set READ METHOD property to File List
  2. Set READ METHOD property to File Pattern
  3. Set READ METHOD property to Directory
  4. none of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Set READ METHOD property to File Pattern[/bg_collapse]



20
Which of the following partitioning method is key based ?

  1. Entire
  2. Round Robin
  3. Hash
  4. Random

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Hash[/bg_collapse]
 
21
Which of the following partitioning method does not require keys ?

  1. Hash
  2. Modulus
  3. Range
  4. Random

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Random[/bg_collapse]
 
22
Which statements are true regarding Runtime Column Propogation in jobs ?

  1. A schema file is not required for flat file sources
  2. Only required columns are propogated to the target table
  3. Only columns required in data flow need to be specified
  4. Schema file is required for Database sources

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Only columns required in data flow need to be specified[/bg_collapse]
 
23
Which stage allows multiple reject links ?

  1. Sort stage
  2. lookup stage
  3. Joiner stage
  4. Merge stage

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Merge stage[/bg_collapse]
 
24
Which command is used to run job from command line ?

  1. dsrun
  2. dsjob
  3. orchadmin
  4. orchutil

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : dsjob[/bg_collapse]
 
25
Which of the following is true about Persistent DataSet ?

  1. Stores data in datastage internal format
  2. Data can be viewed using Dataset Viewer
  3. Dataset retains partitioning information
  4. All the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : All the above[/bg_collapse]
 
26
Funnel Stage can have how many input links?

  1. Three
  2. Four
  3. Any Number
  4. one

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Any Number[/bg_collapse]
 
27
When there is single Input and OutPut link for Copy Stage one should ensure to set Force Property to

  1. TRUE
  2. FALSE
  3. Reject
  4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : TRUE[/bg_collapse]
 
28
Duplicate to Retain property in Remove Duplicate Stage can have which of the following values?

  1. Only first record
  2. Only Last Record
  3. First/Last
  4. Any Record

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : First/Last[/bg_collapse]
 
29
Which of the following activities will make parallel or Sequence or Server Job to run

  1. Job Activity
  2. Wait for file activity
  3. Parameters Activity
  4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Job Activity[/bg_collapse]



30
Filter Stage will send the input dataset records that are not satified by any where clause criteria to

  1. Reject link
  2. Other link
  3. Fail link
  4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Reject link[/bg_collapse]
 
31
which of the following is not correct about loop stages?

  1. Used to build loops into your job sequences
  2. Has Numeric and List loop types in startloop activity
  3. All Stages between Start Loop Stage and End Loop Stage are included in loop
  4. End Loop activity has special properties

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : End Loop activity has special properties[/bg_collapse]
 
32
Which of the following is correct about terminator stage?

  1. used to ensure that the sequence is stopped cleanly if certain situations arise
  2. Connected to other stages by triggers, which specify when a terminator will be invoked.
  3. Multiple Terminator activities can be used in the sequence job
  4. all of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : all of the above[/bg_collapse]
 
33
Which of the following is correct regarding Sequential file Stage?

  1. Is an Active stage
  2. Can have any number of reject links
  3. Cannot be used as Intermediate stage
  4. Is a processing stage

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Cannot be used as Intermediate stage[/bg_collapse]
 
34
Types of Pivots supported in Pivot Enterprise Stage

  1. Only Horizontal Pivot
  2. Only Vertical Pivot
  3. Both Horizontal and vertical Pivot
  4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Both Horizontal and vertical Pivot[/bg_collapse]
 
35
Which partitioning technique is appropriate for RemoveDuplicate stage ?

  1. Random
  2. Round Robin
  3. Hash
  4. All the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Hash[/bg_collapse]
 
36
which of the following collecting methods Reads all rows from the first partition, then all rows from the second partition, and so on

  1. ordered
  2. sequence
  3. Roundrobin
  4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : ordered[/bg_collapse]
 
37
Which environment variables Configures InfoSphere DataStage to print a report showing the operators, processes, and data sets in a running job.

  1. APT_CONFIG_FILE
  2. APT_DUMP_SCORE
  3. APT_ORCHHOME
  4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : APT_DUMP_SCORE[/bg_collapse]
 
38
Which partitioning technique  is often a preprocessing step to performing a total sort on a data set?

  1. Random
  2. Modulus
  3. Range
  4. RoundRobin

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Range[/bg_collapse]
 
39
Which Collection method of InfoSphere DataStage will read any row from any input partition as it becomes available?

  1. Auto
  2. Round Robin
  3. Continuous
  4. sequence

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Auto[/bg_collapse]



40
What will happen when both inputs of JOIN stage are Round Robin Partitioned?

  1. Job will fail
  2. Output that gets generated will be always accurate
  3. OutPut that gets generated may be inaccurate
  4. Output that gets generated will be always inaccurate

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : OutPut that gets generated may be inaccurate[/bg_collapse]
 
41
If a dimension contains only Type 1 columns which purpose codes are allowed for dimension columns on reference link

  1. Current Indicator
  2. Effective Date
  3. Expiration Date
  4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : None of the above[/bg_collapse]
 
42
Which of the following are options for UnMatched Master Mode property in Merge Stage?

  1. keep
  2. Drop
  3. Reject
  4. A&B

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A&B[/bg_collapse]
 
43
Which of the following are funnel types in funnel stage?

  1. Sequence
  2. Sort
  3. Continuous
  4. All the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : All the above[/bg_collapse]
 
44
Which of the following types of jobs can be run from Job Activity?

  1. Parallel job
  2. Sequence
  3. Server Job
  4. all of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : All the above[/bg_collapse]
 
45
Which one of following allows to branch the execution of a sequence depending on a condition?

  1. Waitforfile Activity
  2. Nested Condition Activity
  3. Job Activity
  4. All the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Nested Condition Activity[/bg_collapse]


Related Articles

Advanced Manufacturing Process Quiz

Web analytics, Adobe Analytics, Google Analytics Quiz

SailPoint Quiz