Data Stage Beginner Quiz

Data Stage Beginner Quiz




1
Types of jobs in Datastage

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

Answer : all of the above

 
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

Answer : Full Outer

 
3
which  action for lookup failure in lookup stage will send the row to reject link

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

Answer : Reject

 
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

Answer : Sequence

 
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

Answer : A and B

 
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

Answer : Job Actvity

 
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

Answer : A and B

 
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

Answer : B and C

 
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

Answer : truncate




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

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

 
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

Answer : inner Join and drop option in lookup failure option will result in same output

 
12
execute command activity can be used to execute

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

Answer : all of the above

 
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

Answer : single input link, a single output link, a dimension reference link, and a dimension update link

 
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

Answer :both SCD Type 1 and SCD Type 2 processing

 
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

Answer : access to grouping and summary operations

 
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

Answer : Lookup on a large table

 
17
Which partitioning technique is appropriate for aggregator stage ?

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

Answer : Hash

 
18
Which partitioning technique is appropriate for sorting duplicate records ?

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

Answer : Hash

 
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

Answer : Set READ METHOD property to File Pattern




20
Which of the following partitioning method is key based ?

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

Answer : Hash

 
21
Which of the following partitioning method does not require keys ?

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

Answer : Random

 
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

Answer : Only columns required in data flow need to be specified

 
23
Which stage allows multiple reject links ?

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

Answer : Merge stage

 
24
Which command is used to run job from command line ?

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

Answer : dsjob

 
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

Answer : All the above

 
26
Funnel Stage can have how many input links?

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

Answer : Any Number

 
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

Answer : TRUE

 
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

Answer : First/Last

 
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

Answer : Job Activity




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

Answer : Reject link

 
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

Answer : End Loop activity has special properties

 
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

Answer : all of the above

 
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

Answer : Cannot be used as Intermediate stage

 
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

Answer : Both Horizontal and vertical Pivot

 
35
Which partitioning technique is appropriate for RemoveDuplicate stage ?

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

Answer : Hash

 
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

Answer : ordered

 
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

Answer : APT_DUMP_SCORE

 
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

Answer : Range

 
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

Answer : Auto




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

Answer : OutPut that gets generated may be inaccurate

 
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

Answer : None of the above

 
42
Which of the following are options for UnMatched Master Mode property in Merge Stage?

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

Answer : A&B

 
43
Which of the following are funnel types in funnel stage?

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

Answer : All the above

 
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

Answer : All the above

 
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

Answer : Nested Condition Activity