IBM C2090-421 考試概覽:

認證廠商:	IBM
考試名稱:	IBM InfoSphere DataStage v8.5 基礎 / 解決方案設計師考試
考試代碼:	000-421
支援語言:	英文
考試形式:	選擇題, 情境式試題
相關認證:	IBM 認證解決方案開發人員 - InfoSphere DataStage IBM 認證資料倉庫工程師
範例考題:	IBM C2090-421 範例考題
考試方式:	透過 Pearson VUE 進行監考式考試（依地區提供線上應考或實體考場應考方式）
必備條件:	無強制先修條件，但建議具備 ETL 概念與 IBM InfoSphere DataStage 的相關使用經驗。

IBM C2090-421 考試大綱主題:

章節	目標
DataStage 架構	- InfoSphere DataStage 元件 1. 平行版與伺服器版的概念比較 2. Designer、Director 與 Administrator 用戶端
作業執行與問題排除	- 監控與除錯 1. Director 記錄檔分析 2. 常見作業失敗原因
效能與平行處理	- 平行處理概念 1. 緩衝與效能調校技巧 2. 資料分割方法
作業設計與開發	- 階段與連結 1. 查閱與聯結操作 2. Transformer 階段的使用方式 - 作業類型 1. 伺服器作業 2. 序列作業 3. 平行作業
資料轉換與 ETL 邏輯	- 資料對應與轉換規則 1. 資料型別處理 2. 欄位衍生與運算式

最新的 IBM Specialist C2090-421 免費考試真題：

問題 #1

Which three DataStage elements allow you to create Shared MetaData? (Select three)

A. DataStage table definition
B. Sequential file stage
C. Dataset stage
D. DB2 Connector
E. Oracle Connector

問題 #2

Configuring the weighting column of an Aggregator stage affects which three options. (Choose three.)

A. Corrected Sum of Squares
B. Sum
C. Percent Coefficient of Variation
D. Sum of Weights
E. Maximum Value

問題 #3

You are responsible for the projects Source Code Repository. When a developer notifies you that changes are ready to deploy you must first check them in. You will use the Information Server Source Code integration features to check in the changed assets. How will you identify the DataStage assets the developer modified in order to send them to the workspace?

A. Use Designer client Advanced Find, specify a modification date and the developer's username in the Modified by fields.
B. From the workspace perspective select the project Right-click then Refresh from repository, specify a modification date and the developer's username in the Modified by fields.
C. From Information Server Manager use Search with advanced options, specify a date modified and the developer's user name in the Modified by fields.
D. From the Information Server Manager Select the project then right-click on Synchronize with source code control system.

問題 #4

You have a dataset hash-partitioned and sorted on CustID. You need to create a Sequential File sorted on CustID from this dataset. Which technique is the most appropriate?

A. Use SortMerge collector for the Sequential File input link.
B. Use Copy stage.
C. Insert Sort stage before the final Sequential File stage and use Ordered collector for the Sequential File stage input link.
D. Insert Sort stage before the final Sequential File stage and use Round Robin collector for the Sequential File stage input link.

問題 #5

A job reads from a sequential file using a SequentialFile stage with option "number of readers" set to 2. This data goes to a Transformer stage and then is written to a dataset using the DataSet stage. The default configuration file has three nodes. The environment variable $APT_DISABLE_COMBINATION is set to "True" and partitioning is set to "Auto". How many processes will be created?

A. 9
B. 7
C. 12
D. 5

問題與答案：

問題 #1
答案： A,C,D

問題 #2
答案： B,C,D

問題 #3
答案： C

問題 #4
答案： A

問題 #5
答案： A