IBM Assessment: IBM InfoSphere DataStage v9.1 Assessment 認定 A2090-303 試験問題:
1. In addition to the table and schema names, what two element names must be specified when you create a shared table definition in DataStage Designer? (Choose two.)
A) Database
B) Database instance
C) Project name
D) Host system
E) DataStage server system name
2. Which two file stages allow you to configure rejecting data to a reject link? (Choose two.)
A) Data Set Stage
B) Complex Flat File Stage
C) Compare Stage
D) Lookup File Set Stage
E) Big Data File Stage
3. Which two statements about using a Load write method in an Oracle Connector stage to tables that have indexes on them are true? (Choose two.)
A) The Load Write method uses "Rebuild" mode with no logging automatically.
B) Set the Index mode property to "Bypass".
C) The Load Write method uses the Parallel Direct Path load method.
D) Set the environment variable APT_ORACLE_LOAD_OPTIONS to "OPTIONS (DIRECT=TRUE, PARALLEL=FALSE)".
E) Set the Upsert mode property to "Index".
4. Rows of data going into a Transformer stage are sorted and hash partitioned by the Input.Product column. Using stage variables, how can you determine when a new row is the first of a new group of Product rows?
A) Create a stage variable named sv_IsNewProduct and follow it by a second stage variable
named sv_Product. Map the Input.Product column to
sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product = sv_Product THEN "YES"
ELSE "NO".
B) Create a stage variable named sv_IsNewProduct and follow it by a second stage variable
named sv_Product. Map the Input.Product column to
sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product <> sv_Product THEN "YES"
ELSE "NO".
C) Create a stage variable named sv_Product and follow it by a second stage variable named
sv_IsNewProduct. Map the Input.Product column to
sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product = sv_Product THEN "YES"
ELSE "NO".
D) Create a stage variable named sv_Product and follow it by a second stage variable named
sv_IsNewProduct. Map the Input.Product column to
sv_Product. The derivation for sv_IsNewProduct is: IF Input.Product <> sv_Product THEN "YES"
ELSE "NO".
5. Which two statements about the Additional Connections Options property in the Teradata Connector stage to specify details about the number of connections to Teradata are true? (Choose two.)
A) Requestedsessions is a number between 1 and the number of vprocs in the operating system.
B) The default for requestedsessions is the maximum number of available sessions.
C) The default for requestedsessions is the minimum number of available sessions.
D) Total requested sessions equals sessions per player multiplied by number of nodes multiplied by players per node. The default value is 4.
E) Sessionsperplayer determines the number of connections each player in the job has to Teradata.
質問と回答：
| 質問 # 1 正解： A、D | 質問 # 2 正解： B、E | 質問 # 3 正解： C、D | 質問 # 4 正解： B | 質問 # 5 正解： B、E |
714 お客様のコメント
品質保証JPexamはIT認定試験のシラバスに従って、試験問題の範囲を正確に絞って、的中率が99％の最新問題集を捧げます。
1年間の無料更新サービスJPexamは1年以内に問題集の無料更新サービスを提供し、お客様がいつでも最新版の問題集を持つことを保証いたします。もし試験の内容が変更されたら、弊社は直ちにお客様にお知らせします。それに、弊社の問題集が更新されたら、早速メールで最新バージョンを送付いたします。
全額返金JPexamの問題集を利用すると、短時間で勉強しても試験に合格できるのを保証いたします。試験に不合格になってしまった場合、弊社は全額返金いたします。(
ご購入前のお試しJPexamは問題集のサンプルを無料で提供いたします。ご購入前にサンプルを試用して製品の品質を確認することができます。ご遠慮なく利用してください。
