We're so confident of our products that we provide no hassle product exchange.
IBM Certified Solution Developer - IBM InfoSphere DataStage Sample Questions:
1. Click on the Exhibit button.
Provided you have enough system resources, what is the maximum number of jobs that could be running concurrently in this image?
A) 2
B) 3
C) 5
D) 4
2. What two repositories does the Source Code Control Integration for DataStage and QualityStage serve? (Choose two.)
A) Source Code Repository
B) WebSphere Repository
C) Information Analyzer Repository
D) Universe Project Repository
E) Information Server metadata Repository
3. Which statement is true when using the SaveInputRecord() function in a Transformer stage.
A) You must retrieve all saved queue records using the GetSavedInputRecord() function within Stage variable derivations.
B) You can access the saved queue records using Vector referencing in Stage variable derivations.
C) You must retrieve all saved queue records using the GetSavedInputRecord() function within Loop variable derivations.
D) You can only use the SaveInputRecord() function in Loop variable derivations.
4. A 100MB input dataset has even distribution across 400 unique key values. When you run with a 4-node configuration file, which two changes could improve sort performance in this scenario? (Choose two.)
A) Alter the Sort stage properties to perform a stable sort.
B) Set $APT_TSORT_STRESS_BLOCKSIZE to 50M
C) Convert all numeric fields to varchars.
D) Specify Round Robin partitioning on the input link to the Sort stage.
E) Specify "Restrict Memory Usage" to 60MB on the Sort stage properties.
5. What is the purpose of the APT_DUMP_SCORE environment variable?
A) It is a reporting environment variable that adds additional runtime information in the job log.
B) It is an environment variable that turns on the job monitor.
C) It is an environment variable that enables the collection of runtime performance statistics.
D) There is no such environment variable.
Solutions:
| Question # 1 Answer: B | Question # 2 Answer: A,E | Question # 3 Answer: C | Question # 4 Answer: B,E | Question # 5 Answer: A |
By Amos
