IBM Websphere Datastage V.8.0 認定 000-418 試験問題:
1. You have a job named MyJob in project ProdProject and directory /xmlReportDir. Which two return an XML report containing complete performance data for MyJob? (Choose two.)
A) $APT_PERFORMANCE_DATA=/xmlReportDir
B) dsjob -report ProdProject MyJob XML > /xmlReportDir/MyJob.xml
C) dsjob -report ProdProject MyJob DETAIL > /xmlReportDir/MyJob.xml
D) $APT_DUMP_SCORE=true
2. Which three statements are true about File Sets? (Choose three.)
A) File sets are readable by external applications.
B) File sets are stored as header file and data files.
C) File sets are partitioned.
D) File sets are stored as a single file.
E) File sets are unpartitioned.
3. Click the Exhibit button.
In the exhibit, you have three jobs: J1,J2,J3. The Job Sequencer compilation option, "Automatically Handle Activities that fail" is checked. Which two methods shown in the
exhibit ensure J1 and J2 finish successfully before J3? (Choose two.)
A) Exhibit A
B) Exhibit D
C) Exhibit C
D) Exhibit B
4. Your job is using the DB2 Enterprise stage as a target. In this job you are inserting data into a single existing table on a remote database. You are using Run-Time Column Propagation (RCP) on all of the links. Which two job design configuration actions would you consider to effectively use RCP? (Choose two.)
A) In the DB2 Enterprise stage use Connection properties to manage column mappings.
B) Use a Modify stage prior to the DB2 Enterprise stage in order to drop the columns not found in the table.
C) In the DB2 Enterprise stage set the option named "Silently Drop Columns Not In Table" to "True".
D) Use DB2 partitioning properties on the input link to the DB2 Enterprise stage to control column layout in partitions.
5. A credit card company has about 10 million unique accounts. The company needs to determine the outstanding balance of each account (Account_id) by aggregating the previous balance with current charges. A multi-node DataStage job with an Aggregator stage is being used to perform this calculation. Which three tasks are required for optimal performance? (Choose three.)
A) Sort data on Account_id going into the Aggregator stage.
B) Use "Round Robin" partition on Account_id for even distribution of records.
C) Use "Hash" partition on Account_id going into the Aggregator stage.
D) Use "Sort" Aggregator method.
E) Use "Hash" Aggregator method.
質問と回答：
| 質問 # 1 正解： A、B | 質問 # 2 正解： A、B、C | 質問 # 3 正解： A、C | 質問 # 4 正解： B、C | 質問 # 5 正解： A、C、D |
0 お客様のコメント
品質保証JPexamはIT認定試験のシラバスに従って、試験問題の範囲を正確に絞って、的中率が99％の最新問題集を捧げます。
1年間の無料更新サービスJPexamは1年以内に問題集の無料更新サービスを提供し、お客様がいつでも最新版の問題集を持つことを保証いたします。もし試験の内容が変更されたら、弊社は直ちにお客様にお知らせします。それに、弊社の問題集が更新されたら、早速メールで最新バージョンを送付いたします。
全額返金JPexamの問題集を利用すると、短時間で勉強しても試験に合格できるのを保証いたします。試験に不合格になってしまった場合、弊社は全額返金いたします。(
ご購入前のお試しJPexamは問題集のサンプルを無料で提供いたします。ご購入前にサンプルを試用して製品の品質を確認することができます。ご遠慮なく利用してください。
