Data Stage Admin Quiz

1
Which parameter needs to be set to disable operators being combined ?

1. APT_COMBINE_OPERATORS
2. APT_DISABLE_COMBINATION
3. APT_DISABLE_OPERATORS
4. APT_ENABLE_COMBINATION

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : APT_DISABLE_COMBINATION[/bg_collapse]
 
2
Which of the following is true regarding Conductor process ?

1. One conductor process is started per job
2. Conductor process starts a section leader process for each node
3. Conductor process manages orderly shutdown in the event of fatal error.
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]
 
3
How do you ensure that jobs in QA cannot be modified ?

1. Make the Project Read only in Director
2. Protect the project in QA environment
3. Provide Read only access to all QA users
4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Protect the project in QA environment[/bg_collapse]
 
4
Which of the following cannot be defined in parallel configuration file ?

1. Node Pools
2. Resource Disk
3. Sort Buffer Size
4. Scratch Disk

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Sort Buffer Size[/bg_collapse]
 
5
What kind of files are stored in Resource Disk space ?

1. Temporary files used by operators
2. Data Files used by virtual data sets
3. Data files used by Persistent data sets
4. Buffer cache used by Sort stage

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Data files used by Persistent data sets[/bg_collapse]
 
6
Which of the following actions cannot be specified for a message using message handlers ?

1. Suppress from Log
2. Demote to Warning
3. Demote to Informational
4. Promote to Warning

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



7
Which of the following is true regarding section leader process ?

1. Primary process which runs when a job is started
2. Responsible for Cleanup after a job fails
3. Manages communication between Conductor and player processes
4. Both B & C

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Manages communication between Conductor and player processes[/bg_collapse]
 
8
User with Super Operator Role

1. can Login to designer, but cannot modify jobs
2. Cannot login to Designer
3. Can execute jobs in Director
4. Both A & C

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Both A & C[/bg_collapse]
 
9
User with Production Manager Role

1. Can add and edit jobs in Designer
2. Can import objects into protected projects
3. Can Protect and unprotect projects
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]
 
10
A Datastage Project can be created using

1. Datastage Administrator
2. Infosphere Information server console
3. Datastage Designer
4. Both A & B

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Both A & B[/bg_collapse]
 
11
What kind of files are stored in Scratch Disk space Resource?

1. Temporary files used by Buffer operators
2. Temporary files used by sort stage
3. Data Files used by Datasets
4. Both A & B

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Both A & B[/bg_collapse]
 
12
Persistent Datasets can be deleted using

1. OrchAdmin utility
2. Dataset Management Tool
3. Look in Resource disk area for segment files, identify corresponding descriptor file and use dataset management utility to open and delete file
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]
 
13
Which of the following is not true regarding Data sets ?

1. Persistent Datasets are stored in Resource disk
2. Virtual Datasets are stored in Resource Disk
3. Datasets cannot be read using text editors
4. Datasets are stored as descriptor file and a set of Data files

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Virtual Datasets are stored in Resource Disk[/bg_collapse]
 
14
User with Operator Role can

1. Login to designer, but cannot modify jobs
2. Can Run and Schedule jobs in Director
3. Can Protect and unprotect projects
4. Both A & B

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Can Run and Schedule jobs in Director[/bg_collapse]
 
15
Which of the following is not a service in Datastage ?

1. InfoSphere DataStage Engine Resource Service
2. DSRPC Service
3. Repository Service
4. ASB Agent

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