IBM P2090-047 考試概覽:

認證廠商:	IBM
考試名稱:	IBM PureData System for Transactions 技術專業測驗 v1
考試代碼:	P2090-047
相關認證:	IBM PureData System for Transactions 專業人員認證
考試時間:	75 minutes
考試費用:	≈200 美元
支援語言:	英文
及格分數:	70
考試形式:	選擇題（MCQs）
實際考試題數:	50
範例考題:	IBM P2090-047 範例考題
考試方式:	實地考場或線上監考測驗
必備條件:	未指定

IBM P2090-047 考試大綱主題:

章節	目標
主題 1: PureData System for Transactions 資訊安全
主題 2: PureData System for Transactions 效能與最佳化調校
主題 3: PureData System for Transactions 架構
主題 4: PureData System for Transactions 概覽
主題 5: PureData System for Transactions 故障排除與維護
主題 6: PureData System for Transactions 安裝與設定

最新的 IBM Information Management P2090-047 免費考試真題：

1. The PureData System for Analytics implements which level of transaction isolation?

A) Committed read
B) Serializable
C) Uncommitted read
D) Repeatable read

2. A SELECT statement spends all its time returning 1 billion rows. What can be done to make this faster?

A) Use a CURSOR.
B) Use an EXTERNAL table.
C) Increase the PreFetch Count.
D) Use the COPY command.

3. When working with sequences, which statement will always be true?

A) Integers (whole numbers) are generated.
B) The sequence number assigned will be unique across all tables and databases.
C) One-up numbers are generated.
D) The first value generated is the number 1.

4. Given a plan ID, how would you obtain the query execution plan? (Choose two.)

A) Go to the query history within the Windows NzAdmin GUI tool.
B) Issue "SHOW PLANFILE <nn>;" after the query has been submitted.
C) Turn ODBC tracing ON.
D) Issue "SELECT * FROM _V_SESSION;"
E) Run EXECUTION PLAN before the query has been submitted.

5. OLE-DB based applications requires which PureData System for Analytics software?

A) Install the OLE-DB Driver for windows.
B) Install the nzload bulk load for windows.
C) Install the ODBC driver for windows.
D) Install the JDBC driver for windows.

問題與答案：

問題 #1
答案： B

問題 #2
答案： B

問題 #3
答案： A

問題 #4
答案： A,B

問題 #5
答案： A