Question 1
Complete
Mark 0.00 out of 1.00
What is the purpose of UV command in a UNIX Datastage server?
Select one:
a. Start and Stop the Datastage Engine
b. Report Datastage Client connections
c. Cleanup resources from a datastage failed job
d. Provide read access to a Datastage configuration file
Question 2
Complete
Mark 0.00 out of 1.00
Does Link Collector in Server version of DataStage is equivalent to Funnel Stage in parallel
Version of DataStage?
Select one:
a. Yes
b. No
c. Can't Say
d. None of the above
Question 3
Complete
Mark 1.00 out of 1.00
Which of the following language used in Transformer functions in Datastage Server?
Select one:
a. COBOL
b. BASIC
c. C
d. None of the above
Question 4
Complete
Mark 1.00 out of 1.00
Which of the following is NOT TRUE about the Compress Stage?
Select one:
a. The Compress stage uses the UNIX compress or GZIP utility to compress a data set
b. Compress stage converts a data set from a sequence of records into a stream of raw
binary data
c. A compressed data set is similar to an ordinary data set and can be used by other stages
of Datastage for further processing of data
d. Compressing a data set removes its normal record boundaries
Question 5
Complete
Mark 1.00 out of 1.00
Column import stage belongs to which one of the following?
Select one:
a. Processing Stage
b. File Stage
c. Restructure Stage
d. None of the above
Question 6
Complete
Mark 1.00 out of 1.00
Ascending and Descending operations on data can be performed using the following stage in
Datastage
Select one:
a. Sort Stage
b. Transformer stage
c. Sequential file Stage
d. None of the above
Question 7
Complete
Mark 1.00 out of 1.00
How do you convert a string in to internal storage format in Datastage?
Select one:
a. TRIM function
b. ICONV ( )
c. EREPLACE function
d. Exchange function
Question 8
Complete
Mark 1.00 out of 1.00
Which of the following is TRUE about Array Size in Oracle OCI stage?
Select one:
a. Maximum number of rows to transfer in each read or write operation
b. Minimum number of rows to transfer in each read or write operation
c. Decreasing the array size increases the performance of DataStage Job
d. Array Size and Transaction Size are one and same in the Oracle OCI Stage
Question 9
Complete
Mark 0.00 out of 1.00
What is the difference between Change and Ereplace functions?
Select one:
a. In Change, if substring is empty,the value of string is returned
b. In Ereplace, if substring is empty,the value of string is returned
c. Both are Same
d. None of the above
Question 10
Complete
Mark 0.00 out of 1.00
Which of the following tasks will create Datastage projects?
Select one or more:
a. Import a project through the Datastage Administrator
b. Add new projects from the Datastage Administrator
c. Copy a Project in the Datastage Administrator
d. Install the Datastage Engine
Question 11
Complete
Mark 1.00 out of 1.00
What is the lowest CPU cost partitioning method for parallel stage to parallel stage?
Select one:
a. Range
b. Modulus
c. Entire
d. Same
Question 12
You are working on a job in which sequential file cannot be read in parallel.In an attempt to
improve job performance,you first define a single large string column for non-parallel
sequential file read.Which stage may be used to parse the large string in parallel?
Select one:
a. the column import stage
b. the column export stage
c. the make vector stage
d. the split vector stage
Question 13
Complete
Mark 1.00 out of 1.00
Where is the Degugger run from?
Select one:
a. Administrator
b. Director
c. Designer
d. Third Party vendor Tool
Question 14
Complete
Mark 1.00 out of 1.00
Which Edition of Datastage can be used to handle XML data?
Select one:
a. Server Edition
b. Parallel Edition
c. Both of the above
d. None of the above
Question 15
Complete
Mark 1.00 out of 1.00
A job needs to split one data set into three data sets based on conditions that are supplied at
run-time.Which stage would allow you to parameterise the condition for splitting the input
data set?
Select one:
a. Filter stage
b. Switch Stage
c. Transformer Stage
d. Split vector stage
Question 16
Complete
Mark 0.00 out of 1.00
Which 'Reject Mode' option in sequential file stage will write records to a reject link?
Select one:
a. Fail
b. Drop
c. Output
d. Continue
Question 17
Complete
Mark 1.00 out of 1.00
What are three valid join operations for the Join Stage?(Choose Three)
Select one or more:
a. Inner Join
b. Top Outer Joiin
c. Left Outer Join
d. Right Outer Join
e. Bottom Inner Join
Question 18
Complete
Mark 1.00 out of 1.00
Is it possible to use server components in a parallel job?
Select one:
a. Yes
b. No
c. Can't Say
d. None of the above
Question 19
Complete
Mark 1.00 out of 1.00
Which could be the output of the following EREPLACE function?
A = "AAABBBCCCDDDBBB"
PRINT EREPLACE (A,"BBB","ZZZ”, [1,1])
Select one:
a. AAAZZZCCCDDDZZZ
b. AAAZZZCCCDDDBBB
c. ZZZAAAZZZCCCDDDZZZ
d. None of the above
Question 20
Complete
Mark 0.00 out of 1.00
Which of the following is NOT TRUE about the FILTER stage?
Select one:
a. Filter Stage can have many outputs
b. Filter Stage can also handle rejected data
c. Filter Stage supports Unix command for filtering the data
d. Filter Stage supports Boolean expressions and operations for filtering operation
Question 21
Complete
Mark 1.00 out of 1.00
Datastage is a
Select one:
a. ETL Tool
b. Reporting Tool
c. OLAP System
d. OLTP System
Question 22
Complete
Mark 1.00 out of 1.00
What is the range limit using a Range look up?
Select one:
a. 2
b. 3
c. 4
d. Multiple
Question 23
Complete
Mark 1.00 out of 1.00
Which Stage allows for more than one reject link?
Select one:
a. Peek Stage
b. Join Stage
c. Merge Stage
d. Lookup Stage
e. Funnel Stage
Question 24
Complete
Mark 1.00 out of 1.00
Which of the following is not a partitioning technique in Datastage 8.5?
Select one:
a. Hash
b. Round Robin
c. List
d. Range
Question 25
Complete
Mark 1.00 out of 1.00
Which of the following is the format of the files that are imported/exported from DataStage?
Select one:
a. .rtf format
b. .dsx format
c. .rep format
d. .txt format
Question 26
Complete
Mark 1.00 out of 1.00
How do you schedule or monitor the Datastage job?
Select one:
a. Datastage Director
b. Datastage Designer
c. Datastage Manager
d. Datastage Administrator
Question 27
Complete
Mark 0.00 out of 1.00
In the Join stage, how the input data sets are notionally identified as?
Select one:
a. Right, Left and Outer Sets
b. Full Outer, Left Outer, Right Outer and Inner sets
c. Intermediate, Outer, and Center Sets
d. Intermediate, Left, and Right Sets
Question 28
Complete
Mark 0.00 out of 1.00
What is DS Administrator used for?
Select one:
a. to set up DataStage users
b. to view and manage the contents of the DataStage Repository
c. to build Datastage jobs
d. to run the datastage Jobs
Question 29
Complete
Mark 1.00 out of 1.00
What is the functionality of TrimF?
Select one:
a. Trims leading spaces and tabs from a string
b. Trims trailing spaces and tabs from a string
c. Trims both leading and trailing spaces
d. None of the above
Question 30
Complete
Mark 0.00 out of 1.00
How does the Complex Flat file stage(CFF) support the use of "OCCURS DEPENDING
ON" clause?
Select one:
a. CFF does not support this clause
b. The related elements are output as arrays
c. The related elements are output as subscribers
d. The related elements are output as denormalized fields
Question 31
Complete
Mark 1.00 out of 1.00
A star schema data warehouse consists of four dimensions and one fact table.How many
slowly changed dimension stages will you need in your jobs to update the star schema tables?
Select one:
a. two
b. three
c. four
d. five
Question 32
Complete
Mark 1.00 out of 1.00
Where do we define/use staging variables in Datastage?
Select one:
a. Aggregator
b. Transformer
c. Filter
d. None of the above
Question 33
Complete
Mark 0.00 out of 1.00
There is a requirement to transfer a large file using an FTP Enterprise stage. How can you
minimize processing time when a transfer failure occurs?
Select one:
a. Specify restartable mode on a transfer of the single file
b. Manually split the file into multiple files and specify restartable mode on a transfer
c. Create multiple readers to transfer file data and specify restartable mode on input link
tab
d. Use sequencer to check transfer status and restart the job from the beginning of failure
Question 34
Complete
Mark 1.00 out of 1.00
Which of the following is NOT TRUE about the Job batch in Datastage?
Select one:
a. A job batch is a group of jobs or separate invocations of the same job(with different
job parameters) that you want to run sequentially
b. Datastage treats a batch as though it were a single job
c. Logs of Job batch contain messages about the progress of the batch, as well as the job
d. If any job in the batch fails to complete successfully, the batch ignores that job and
proceeds to next job
Question 35
Complete
Mark 1.00 out of 1.00
Which two partition methods require keys?
Select one or more:
a. Hash
b. Entire
c. Modulus
d. Round Robin
Question 36
Complete
Mark 1.00 out of 1.00
Which of the following stage is used for read/write operations of a file that resides on remote
system?
Select one:
a. FTP plug-in stage
b. Sequential file stage
c. Hash file
d. None of the above
Question 37
Complete
Mark 0.00 out of 1.00
Which two attributes are found in a Data Set descriptor file? (Choose two.)
Select one or more:
a. A copy of the job score.
b. The schema of the Data Set.
c. A copy of the partitioned data.
d. A copy of the configuration file used when Data Set was created
Question 38
Complete
Mark 0.00 out of 1.00
Which of the following is NOT TRUE about the Datastage Repository?
Select one:
a. A Repository can be a place where multiple databases, routines and files are located
for distribution over a network
b. We can clean the Datastage repository by using the Clean Up Resources functionality
in the Datastage Manager
c. It is maintained by Datastage Administrator
d. Routines and metadata of tables are maintained in the Datastage repository
Question 39
Complete
Mark 1.00 out of 1.00
How many types of containers are available in Datastage?
Select one:
a. 3
b. 2
c. 1
d. None of the above
Question 40
Complete
Mark 1.00 out of 1.00
How many baisc types of parallel processing exist in Datastage?
Select one:
a. 1
b. 2
c. 3
d. 4
Question 41
Complete
Mark 0.00 out of 1.00
Which of the following are the characteristics of Containers in Datastage?(Choose 3)
Select one or more:
a. Containers are used to reduce the complexity of jobs
b. Containers allow multiple users to access a single job
c. Containers allow you to provide Pre-configured job design logic that can be reused
d. Shared containers can be re-used in any of the jobs in a particular project
Question 42
Complete
Mark 0.00 out of 1.00
Which two stages allow field names to be specified using job parameters?Choose two.
Select one or more:
a. Filter Stage
b. Modify Stage
c. Funnel Stage
d. Transformer Stage
Question 43
Complete
Mark 0.00 out of 1.00
Which of the following Unix command is used to start the Datastage Server?
Select one:
a. uv–admin–stop
b. uv–admin–start
c. uv–admin–initiate
d. uv–admin–run
Question 44
Complete
Mark 1.00 out of 1.00
Is it possible to run two versions of datastage on the same pc?
Select one:
a. Yes
b. No
c. Can't Say
d. None of the above
Question 45
Complete
Mark 0.00 out of 1.00
Which component of Datastage is used to release the Job locks?
Select one:
a. Designer
b. Administrator
c. Director
d. Repository
Question 46
Complete
Mark 0.30 out of 1.00
When invoking a job from a third—party scheduler, it is often desirable to invoke a job and
wait for its completion in order to return the job‘s completion status. Which three commands
would invoke a job named "BuiIdWarehouse" in project DevProject and wait for thejob's
completion? (Choose three.)
Select one or more:
a. dsjob -run —Iog DevProject BuiIdWarehouse
b. dsjob -run -jobstatus DevProject BuiIdWarehouse
c. dsjob -run —userstatus DevProject BuiIdWarehouse
d. dsjob -run DevProject BuiIdWarehouse
e. dsjob -run -wait DevProject BuiIdWarehouse
Question 47
Complete
Mark 0.00 out of 1.00
Can Datastage accepts a excel file as source?
Select one:
a. Yes
b. No
c. Can't Say
d. None of the above
Question 48
Complete
Mark 0.50 out of 1.00
Row splitter and Row Merger stages are available in
Select one or more:
a. Server edition
b. Parallel Edition
c. Both Server and Parallel editions
d. None of the above
Question 49
Complete
Mark 1.00 out of 1.00
Which of the following is not one among the client components of Datastage?
Select one:
a. Datastage Designer
b. Datastage Administrator
c. Datastage Repository
d. Datastage Director
Question 50
Complete
Mark 0.00 out of 1.00
Unlocking a Job can be done by
Select one or more:
a. Datastage Director
b. Datastage Administrator
c. Datastage Manager
d. Datastage Designer
