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

Show Answer

 
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

Show Answer

 
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

Show Answer

 
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

Show Answer

 
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

Show Answer

 
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

Show Answer

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

Show Answer

 
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

Show Answer

 
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

Show Answer

 
10
A Datastage Project can be created using

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

Show Answer

 
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

Show Answer

 
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

Show Answer

 
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

Show Answer

 
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

Show Answer

 
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

Show Answer