下載最新試用版
1103位客戶反饋
我們對我們的產品非常有信心，所以我們不提供会给客户带去麻煩的產品。
IBM A2090-544 考試概覽:
| 認證廠商: | IBM |
| 考試名稱: | IBM DB2 9.7 for LUW 進階資料庫管理師考試 |
| 考試代碼: | C2090-544 |
| 考試形式: | 複選題 |
| 支援語言: | English |
| 相關認證: | IBM Certified Database Associate - DB2 IBM Certified Database Administrator - DB2 |
| 證照有效期限: | 3 年（IBM 認證一般有效期） |
| 推薦課程: | IBM Skills Gateway IBM DB2 9.7 管理課程 |
| 考試報名: | Pearson VUE IBM 考試專區 IBM 認證入口網站 |
| 範例考題: | IBM A2090-544 範例考題 |
| 考試方式: | 透過 Pearson VUE 考試中心或線上監考方式辦理（各地區開放情形可能不同） |
| 必備條件: | 建議具備 IBM DB2 管理相關經驗；已取得 IBM Certified Database Associate 或 Administrator 認證者尤佳，惟非強制要求。 |
| 官方大綱網址: | https://www.ibm.com/certify |
IBM A2090-544 考試大綱主題:
| 章節 | 目標 |
|---|---|
| 主題 1: 效能調校與監控 | - 查詢最佳化與調校
|
| 主題 2: 儲存管理 | - 資料表空間與儲存結構
|
| 主題 3: DB2 架構與概念 | - DB2 執行個體與資料庫結構
|
| 主題 4: 資料庫安裝與設定 | - 安裝規劃與程序
|
| 主題 5: 備份與復原 | - 復原策略
|
| 主題 6: 高可用性與公用程式 | - DB2 公用程式與維護作業
|
| 主題 7: 安全與授權 | - 驗證與授權機制
|
最新的 DB2 A2090-544 免費考試真題：
1. When an agent that is connected to the database finishes its work of successfully processing a query, what happens to the agent?
A) It terminates immediately.
B) It is placed in the agent pool if the connection is terminated.
C) It remains active as long as the MAXAGENTS setting is not exceeded.
D) It automatically releases the database connection and returns to the pool.
2. What determines the degree of inter-partition parallelism used?
A) The value of the DFT_DEGREE database configuration parameter.
B) The value of the INTER_PARALLEL Database Manager configuration parameter.
C) The number of database partitions and the definition of partition groups.
D) The number of database connections and the definition of partitions groups.
3. Table T1 was created by executing the following statement:
Immediately after creation, table T1 was populated with 10 rows. Later, user USER1 ran an application that inserted 100,000 rows into table T1. The following query is frequently ran against the T1 table:
SELECT deptno, empno, deptname FROM t1 WHERE deptno = 'EN' AND empno = '123' Assuming current statics exist for the table and index, which index will provide optimal performance for this query?
A) CREATE INDEX idx1 ON t1 (deptno, empno)
B) CREATE INDEX idx1 ON t1 (deptno) INCLUDE (empno)
C) CREATE INDEX idx1 ON t1 (deptno, empno) INCLUDE (deptname)
D) CREATE INDEX idx1 ON t1 (deptno)
4. A DBA would like to examine repartitioning options for a partitioned database named PRODDB. Which tool can be used to provide recommendations on re-partitioning?
A) Workload Manager
B) Design Advisor
C) Configuration Advisor
D) Partition Assistant
5. Your UNIX system administrator has indicated that there appears to be a lot of I/O wait time associated with your database, which is stored in a 7+p RAID array. An investigation reveals the following information: DB2_PARALLEL_IO=*
Tablespace with ID 7 has a single container and is dedicated to the largest table. It has a page size of 16K, an extent size of 32, and a prefetch size of 64.
Which setting would optimize I/O for the largest table?
A) DB2_PARALLEL_IO=7:7
B) DB2_PARALLEL_IO=7:32
C) DB2_PARALLEL_IO=7:64
D) DB2_PARALLEL_IO=7:16
問題與答案：
| 問題 #1 答案： B | 問題 #2 答案： C | 問題 #3 答案： A | 問題 #4 答案： B | 問題 #5 答案： A |
42.79.82.* -
使用你們網站的考試題庫，我通過了A2090-544考試，這是我唯一的考前準備，讓我在測試中做得很好。