Data Stage Beginner Quiz
1
Types of jobs in Datastage
- parallel
- sequence
- server
- 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
- inner Join
- Left Outer Join
- Full Outer
- all of the above
3
which action for lookup failure in lookup stage will send the row to reject link
- Drop
- Continue
- Reject
- fail
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.
- Sequence
- Sort
- Continuous
- all of the above
5
Output row only once option in Filter stage is
- Set to True to specify that rows are only output down the link of the first Where clause they satisfy.
- Set to false to have rows output down the links of all Where clauses that they satisfy.
- Set to true to output rows that satisfy no Where clauses down the reject link
- A and B
6
Which of the following activities allows one to specify the name of the job the activity is to run
- Exec Command Activity
- Job Actvity
- WaitforFile activity
- all of the above
7
Using Waitfor File Activity one can specify
- Wait for file to appear
- wait for file to disappear
- copy file to another location
- A and B
8
Which of the following can be used to filter input dataset
- Sequential File Stage
- filter Stage
- transformer Stage
- B and C
9
Which table action option in ODBC connector stage will diacard existing rows and append new rows
- Create
- append
- truncate
- none of the above
10
The Change Capture stage takes
- 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
- 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
- two input data sets, denoted before and after, and outputs a single data set whose records are union of both before and after dataset
- none of the above
11
Which one is true
- inner Join and drop option in lookup failure option will result in same output
- inner Join and continue option in lookup failure option will result in same output
- inner Join and fail option in lookup failure option will result in same output
- none of the above
12
execute command activity can be used to execute
- Operating system command
- batch command file
- executable
- all of the above
13
SCD stage has
- single input link, a single output link, a dimension reference link, and a dimension update link
- single input link, a single output link, a reject link, and a dimension update link
- single input link, a single output link, a dimension reference link, and a reject link
- all of the above
14
SCD stages support
- Type 1 processing
- Type 2 Processing
- both SCD Type 1 and SCD Type 2 processing
- Type 3 Processing
15
The aggregator stage gives
- access to grouping and summary operations
- access to perform joining of input datasets
- access to perform union of input datasets
- none of the above
16
In which cases is the usage of sparse lookup appropriate ?
- Lookup on a flat file with sparse values
- Lookup on a database with sparse values
- Lookup on a large table
- Lookup on a table with few records
17
Which partitioning technique is appropriate for aggregator stage ?
- Random
- Round Robin
- Hash
- All the above
18
Which partitioning technique is appropriate for sorting duplicate records ?
- Hash
- Round Robin
- Random
- Range
19
Which property is used to read set of files ?
- Set READ METHOD property to File List
- Set READ METHOD property to File Pattern
- Set READ METHOD property to Directory
- none of the above
20
Which of the following partitioning method is key based ?
- Entire
- Round Robin
- Hash
- Random
21
Which of the following partitioning method does not require keys ?
- Hash
- Modulus
- Range
- Random
22
Which statements are true regarding Runtime Column Propogation in jobs ?
- A schema file is not required for flat file sources
- Only required columns are propogated to the target table
- Only columns required in data flow need to be specified
- Schema file is required for Database sources
23
Which stage allows multiple reject links ?
- Sort stage
- lookup stage
- Joiner stage
- Merge stage
24
Which command is used to run job from command line ?
- dsrun
- dsjob
- orchadmin
- orchutil
25
Which of the following is true about Persistent DataSet ?
- Stores data in datastage internal format
- Data can be viewed using Dataset Viewer
- Dataset retains partitioning information
- All the above
26
Funnel Stage can have how many input links?
- Three
- Four
- Any Number
- one
27
When there is single Input and OutPut link for Copy Stage one should ensure to set Force Property to
- TRUE
- FALSE
- Reject
- None of the above
28
Duplicate to Retain property in Remove Duplicate Stage can have which of the following values?
- Only first record
- Only Last Record
- First/Last
- Any Record
29
Which of the following activities will make parallel or Sequence or Server Job to run
- Job Activity
- Wait for file activity
- Parameters Activity
- None of the above
30
Filter Stage will send the input dataset records that are not satified by any where clause criteria to
- Reject link
- Other link
- Fail link
- None of the above
31
which of the following is not correct about loop stages?
- Used to build loops into your job sequences
- Has Numeric and List loop types in startloop activity
- All Stages between Start Loop Stage and End Loop Stage are included in loop
- End Loop activity has special properties
32
Which of the following is correct about terminator stage?
- used to ensure that the sequence is stopped cleanly if certain situations arise
- Connected to other stages by triggers, which specify when a terminator will be invoked.
- Multiple Terminator activities can be used in the sequence job
- all of the above
33
Which of the following is correct regarding Sequential file Stage?
- Is an Active stage
- Can have any number of reject links
- Cannot be used as Intermediate stage
- Is a processing stage
34
Types of Pivots supported in Pivot Enterprise Stage
- Only Horizontal Pivot
- Only Vertical Pivot
- Both Horizontal and vertical Pivot
- None of the above
35
Which partitioning technique is appropriate for RemoveDuplicate stage ?
- Random
- Round Robin
- Hash
- All the above
36
which of the following collecting methods Reads all rows from the first partition, then all rows from the second partition, and so on
- ordered
- sequence
- Roundrobin
- None of the above
37
Which environment variables Configures InfoSphere DataStage to print a report showing the operators, processes, and data sets in a running job.
- APT_CONFIG_FILE
- APT_DUMP_SCORE
- APT_ORCHHOME
- None of the above
38
Which partitioning technique is often a preprocessing step to performing a total sort on a data set?
- Random
- Modulus
- Range
- RoundRobin
39
Which Collection method of InfoSphere DataStage will read any row from any input partition as it becomes available?
- Auto
- Round Robin
- Continuous
- sequence
40
What will happen when both inputs of JOIN stage are Round Robin Partitioned?
- Job will fail
- Output that gets generated will be always accurate
- OutPut that gets generated may be inaccurate
- Output that gets generated will be always inaccurate
41
If a dimension contains only Type 1 columns which purpose codes are allowed for dimension columns on reference link
- Current Indicator
- Effective Date
- Expiration Date
- None of the above
42
Which of the following are options for UnMatched Master Mode property in Merge Stage?
- keep
- Drop
- Reject
- A&B
43
Which of the following are funnel types in funnel stage?
- Sequence
- Sort
- Continuous
- All the above
44
Which of the following types of jobs can be run from Job Activity?
- Parallel job
- Sequence
- Server Job
- all of the above
45
Which one of following allows to branch the execution of a sequence depending on a condition?
- Waitforfile Activity
- Nested Condition Activity
- Job Activity
- All the above