最新のA2090-544問題集で試験を準備する

IBM A2090-544 試験概要:

IBM A2090-544 試験シラバストピック:

IBM Assessment: DB2 9.7 Advanced DBA for LUW 認定 A2090-544 試験問題：

1. 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:32
B) DB2_PARALLEL_IO=7:7
C) DB2_PARALLEL_IO=7:16
D) DB2_PARALLEL_IO=7:64

2. A database and a table space were created using the following commands:

Afterwards, two tables were created in table space TBSP1 and both tables were populated with 100,000 rows. If a DBA decides that database MYDB should use automatic storage, which command(s) are needed to convert both the database and table space TBSP1?

A) ALTER DATABASE mydb AUTOMATIC STORAGE YES ON ?mnt/path_1? ?mnt/path_2? ALTER TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE;
B) ALTER DATABASE mydb AUTOMATIC STORAGE YES ON ?mnt/path_1? ?mnt/path_2?
C) ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2? ALTER TABLESPACE tbsp1 MANAGED BY AUTOMATIC STORAGE;
D) ALTER DATABASE mydb ADD STORAGE ON ?mnt/path_1? ?mnt/path_2?

3. Which database configuration parameters can be used to limit the amount of memory allocated for the LOAD utility?

A) LOAD_HEAP_SZ and DATABASE_MEMORY
B) UTIL_HEAP_SZ and DATABASE_MEMORY
C) LOAD_HEAP_SZ and STAT_HEAP_SZ
D) UTIL_HEAP_SZ and STAT_HEAP_SZ

4. 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, empno) INCLUDE (deptname)
C) CREATE INDEX idx1 ON t1 (deptno) INCLUDE (empno)
D) CREATE INDEX idx1 ON t1 (deptno)

5. An employee is not able to connect to the PRODDB database using the correct user ID and password. The TCP/IP protocol is running normally; other remote clients are also having problems connecting to this database. Which two could be the cause of the problem? (Choose two.)

A) The client's authentication type is not compatible with the server.
B) The port number is not assigned in the server's services file.
C) The DB2 Administration Server is not started.
D) The server node and/or database are not cataloged correctly on the client.
E) The DB2COMM environment variable at the server is not set to TCPIP.

質問と回答：