IBM C2090-424 考試概覽:

認證廠商:	IBM
考試名稱:	InfoSphere DataStage v11.3
考試代碼:	C2090-424
相關認證:	IBM Certified Solution Developer - InfoSphere DataStage v11.3
考試形式:	選擇題
及格分數:	64題中答對41題
考試時間:	90 minutes
實際考試題數:	64
支援語言:	English
範例考題:	IBM C2090-424 範例考題
考試方式:	已停辦，不再開放報考
必備條件:	熟悉DataStage設計、平行處理、組態設定及作業效能調校
官方大綱網址:	https://www.ibm.com/training/certification/ibm-certified-solution-developer-infosphere-datastage-v113-28000404

IBM C2090-424 考試大綱主題:

章節	權重	目標
主題 1: 永續性儲存體	15%
主題 2: 中繼資料	5%
主題 3: 組態設定	6%
主題 4: 作業元件	8%
主題 5: 平行架構	9%
主題 6: 作業管理與部署	8%
主題 7: 資料庫	6%
主題 8: 作業控制與執行期管理	8%
主題 9: 資料轉換	12%
主題 10: 作業設計	14%
主題 11: 監控與疑難排解	9%

最新的 IBM Certified Solution Developer C2090-424 免費考試真題：

1. Which of the following environment variables can help in verifying whether data is evenly partitioned across all nodes?

A) $APT_DEBUG_OPERATOR
B) $APT_RECORD_COUNTS
C) $APT_PARTITION_COUNT
D) $OSH_PRINT_SCHEMAS

2. The APT_SubProcessOperator is used for what purpose?

A) It provides the capability to define custom operators at the sub process level
B) It allows you to incorporate a third-party executable into the framework
C) It provides the capability to break predefined operators into sub processes
D) It allows you to incorporate composite operators, which contain more than one operator

3. When building an UPDATE statement in SQL Query builder, which of the following is TRUE?

A) Columns to update must be selected individually from the column selection grid
B) Predicates cannot refine what rows are updated
C) Table(s) referenced must have table definitions imported previously
D) Column values can be job parameters or input columns but not expressions

4. Which one of the following is NOT an XML Pack stage?

A) XML Connector
B) XML Transformer
C) XML Output
D) XML Input

5. A job is designed with 3 Join stages in sequence.
Join_1 keys are "Account", "Customer" and "PO_Date"
Join_2 keys are "Account", "Customer" and "Txn"
Join_3 keys are "Account", "Product_CD" and "Txn"
Which of the following will lead to the best run time performance?

A) Both left and right links are Hash partitioned as follows:
Join_1 by "Account" and "Customer"
Join_2 by "Account" and "Customer"
Join_3 by "Account"
B) Left links are Hash partitioned on "Account" for all joins Right links are Hash partitioned on "Account" for all joins
C) Both left and right links are Hash partitioned as follows:
Join_1 by "Account", "Customer" and "PO_Date"
Join_2 by "Account", "Customer" and "Txn"
Join_3 by "Account", "Product_CD" and "Txn"
D) Left links are Hash partitioned on "Account" for the first two joins and on "Product_CD" for the third.
Right links are Hash partitioned on "Account" for all joins