IBM Assessment: InfoSphere DataStage v8.5 Sample Questions:
1. Which two statements are true about project-level configuration for National Language Support (NLS)? (Select two)
A) Change the Parallel job project locale.
B) Choose appropriate NLS map in the stage property.
C) Change the Parallel job project map.
D) Choose NVarChar for string fields.
2. You set environment variable $APT_ORACLE_LOAD_OPTIONS=PTIONS(DIRECT=TRUE, PARALLEL=TRUE)?for loading index organized tables.You set environment variable $APT_ORACLE_LOAD_OPTIONS=?PTIONS(DIRECT=TRUE, PARALLEL=TRUE)?for loading index organized tables. Which statement is accurate regarding the resulting effect of this environment variable setting?
A) The Oracle load will run in parallel using simple direct path mode.
B) Oracle load will run in parallel and bypass DataStage Director.
C) Oracle load will fail when executed.
D) The Oracle database stage will run in parallel using conventional path mode.
3. Which two tasks can the Slowly Changing Dimensions (SCD) stage perform? (Choose two.)
A) Look up whether a record with a matching business key value exists in a fact table. If it does not, retrieve a new surrogate key value and insert a new row into the fact table.
B) Look up whether a record with a matching business key value exists in a dimension table. If it does, add new values for selected fields to values lists for those fields.
C) Look up whether a record with a matching business key value exists in a dimension table. If it does not, retrieve a new surrogate key value and insert a new row into the dimension table.
D) Look up whether a record with a matching business key value exists in a dimension table. If it does, mark the record as not-current, and generate a new record with new values for selected fields.
4. In the job fragment shown in the exhibit, there are two Sort stages: the first (Sort1) sorts the data by state, the second (Sort2) sorts the data by state and area, No repartitioning occurs between the stages.
You have been asked to reduce the number of sorts to improve the performance of the job.
Which two ways might be used to accomplish this without changing how the job functions? (Select two)
A) In the second Sort stage change the Sort Mode property of the area column to "Don't sort, previously sorted.".
B) Remove the first Sort stage. Retain the existing sort keys in the second Sort stage.
C) In the second Sort stage change the Sort Mode property of the state column to "Don't sort, previously sorted.".
D) Remove the second Sort stage. Add area as an additional sort key.
5. A script invokes an update job called "UpdateKeys" via a command line invocation of the dsjob command. The service is to wait for the completion and status of this job before continuing with the rest its tasks. Which three commands would invoke the "UpdateKeys" job in the MigrationProject and wait for its completion status? (Select three)
A) dsjob -run -jobstatus MigrationProject UpdateKeys
B) dsjob-run-userstatus MigrationProject UpdateKeys
C) dsjob -run -log dsjob -run -userstatus MigrationProject UpdateKeys
D) dsjob -run MigrationProject UpdateKeys
E) dsjob-run-wait MigrationProject UpdateKeys
Solutions:
| Question # 1 Answer: B,C | Question # 2 Answer: C | Question # 3 Answer: C,D | Question # 4 Answer: A,B | Question # 5 Answer: B,C,E |
1090 Customer Reviews
Quality and ValueITCertKing Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
Tested and ApprovedWe are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
Easy to PassIf you prepare for the exams using our ITCertKing testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Try Before BuyITCertKing offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.
