データベース環境の最適化のために
戦略的な意思決定や、業務の一層の効率化のためには、個別のアプリケーションやシステムを越えた統合的な情報基盤の構築が必要となります。IBM は、日経コンピュータの顧客満足度調査 RDBソフト(オープン系)でNo.1に選ばれたハイブリッド・データベース、DB2®をはじめ、SolidDB®、Optim™など、多彩なソリューションをご提供します。これらのソリューションを適切な場所で活用することで、お客様のデータベース環境全体の最適化(Optimize)を実現することができます。
000-418 の問題集みんなと分かち合います
4. What describes the column information specified in Orchestrate schemas? (Choose two.)
A. C++ data types, such as string[max 145]
B. column properties, such as nullability
C. SQL data types, such as Char(20)
D. record format information, such as record delimiter
Answer: AB
5. In which two situations would you use the Web Services Client stage? (Choose two.)
A. You want to deploy a service.
B. You need the Web service to act as either a data source or a data target during an operation.
C. You do not need both input and output links in a single web service operation.
D. You need to create a WSDL.
Answer: BC
6. Which three statements are true about File Sets? (Choose three.)
A. File sets are partitioned.
B. File sets are unpartitioned.
C. File sets are stored as a single file.
D. File sets are readable by external applications.
E. File sets are stored as header file and data files.
Answer: ADE
7. When tuning a parallel process, it is necessary to measure the amount of system resources that are
used by each instance of a stage. Which two methods enable the collection of CPU time used by each
instance of a stage? (Choose two.)
A. Set the environment variable $APT_PM_PLAYER_TIMING=true.
B. Invoke vmstat before the job run and after the job completes.
C. Select the Record job performance data check box from Job Properties.
D. Set the environment variable $DS_MAKE_JOB_REPORT=2.
Answer: AC
8. Which three lookup types may be performed in the Lookup stage? (Choose three.)
A. Equality match
B. Negative match
C. Range on stream link
D. Range on the reject link
E. Range on the reference link
Answer: ACE
11. You are working on a job in which a sequential file cannot be read in parallel. In an attempt to improve
job performance, you first define a single large string column for the non-parallel sequential file read.
Which stage may be used to parse the large string in parallel?
A. the Column Import stage
B. the Column Export stage
C. the Make Vector stage
D. the Split Vector stage
Answer: A
12. What is the lowest CPU cost partitioning method for parallel stage to parallel stage?
A. Range
B. Modulus
C. Entire
D. Same
Answer: D
戦略的な意思決定や、業務の一層の効率化のためには、個別のアプリケーションやシステムを越えた統合的な情報基盤の構築が必要となります。IBM は、日経コンピュータの顧客満足度調査 RDBソフト(オープン系)でNo.1に選ばれたハイブリッド・データベース、DB2®をはじめ、SolidDB®、Optim™など、多彩なソリューションをご提供します。これらのソリューションを適切な場所で活用することで、お客様のデータベース環境全体の最適化(Optimize)を実現することができます。
000-418 の問題集みんなと分かち合います
4. What describes the column information specified in Orchestrate schemas? (Choose two.)
A. C++ data types, such as string[max 145]
B. column properties, such as nullability
C. SQL data types, such as Char(20)
D. record format information, such as record delimiter
Answer: AB
5. In which two situations would you use the Web Services Client stage? (Choose two.)
A. You want to deploy a service.
B. You need the Web service to act as either a data source or a data target during an operation.
C. You do not need both input and output links in a single web service operation.
D. You need to create a WSDL.
Answer: BC
6. Which three statements are true about File Sets? (Choose three.)
A. File sets are partitioned.
B. File sets are unpartitioned.
C. File sets are stored as a single file.
D. File sets are readable by external applications.
E. File sets are stored as header file and data files.
Answer: ADE
7. When tuning a parallel process, it is necessary to measure the amount of system resources that are
used by each instance of a stage. Which two methods enable the collection of CPU time used by each
instance of a stage? (Choose two.)
A. Set the environment variable $APT_PM_PLAYER_TIMING=true.
B. Invoke vmstat before the job run and after the job completes.
C. Select the Record job performance data check box from Job Properties.
D. Set the environment variable $DS_MAKE_JOB_REPORT=2.
Answer: AC
8. Which three lookup types may be performed in the Lookup stage? (Choose three.)
A. Equality match
B. Negative match
C. Range on stream link
D. Range on the reject link
E. Range on the reference link
Answer: ACE
11. You are working on a job in which a sequential file cannot be read in parallel. In an attempt to improve
job performance, you first define a single large string column for the non-parallel sequential file read.
Which stage may be used to parse the large string in parallel?
A. the Column Import stage
B. the Column Export stage
C. the Make Vector stage
D. the Split Vector stage
Answer: A
12. What is the lowest CPU cost partitioning method for parallel stage to parallel stage?
A. Range
B. Modulus
C. Entire
D. Same
Answer: D