Data Stage | Testing | Mock Test

1
_____ stage is useful to read from excel file?
a. Sequential file
b. Complex flat file
c. ODBC
d. Datastage Admistrator
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : ODBC [/bg_collapse]
2
Data Stage Configuration tasks are carried out by
a. Data Stage Administrators
b. Data Stage Directors
c. Data Stage Designers
d. Database Tables
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Data Stage Administrators [/bg_collapse]
3
DataStage allows to define your own stage types using ________________, which can be uses in parallel jobs
a. Datastage Director
b. Datastage Designer
c. Datastage Manager
d. COBAL
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Datastage Manager [/bg_collapse]
4
Datastage Log files are held in
a. Sequential files
b. Hash files
c. Datasets
d. Transporter
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Hash files [/bg_collapse]
5
Datastage Native operators are developed in
a. C ++
b. C
c. BASIC
d. by killing the respective PORT ID
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C ++ [/bg_collapse]
6
How do u convert the columns to rows in Data Stage
a. Using Excel sheets
b. Using Pivot Stage
c. Using Sequential load generator
d. Cant Say
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Using Pivot Stage [/bg_collapse]
7
How to kill the job in data stage
a. Restart the server
b. by killing the respective process ID
c. by killing the respective Job ID
d. APT configuration file
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : by killing the respective process ID [/bg_collapse]
8
In a parallel job scenario, more nodes means better performance.
a. Yes
b. No
c. Depends
d. Link Administrator
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Depends [/bg_collapse]
9
——–is the parameter that defines the number of ways of parallelism of a given job.
a. Parameter File
b. Sequential File
c. Hash File
d. APT configuration file
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : APT configuration file [/bg_collapse]
10
It actually splits data into various partitions or data flows using various Partition methods
a. Link Partitioner
b. Link Collector
c. Link Director
d. Link Administrator
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Link Administrator [/bg_collapse]