Free IBM A2090-544 Exam Dumps Questions & Answers

Which description is correct when discussing the DB2_MEM_TUNING_RANGE registry variable?

• A.It is recommended to set this variable only when the Self-Tuning Memory Manager (STMM) is disabled.
• B.It is recommended that this variable be used to set the maximum percentage of memory that DB2 can use on the system.
• C.It is recommended to set this variable only when using STMM, when DATABASE_MEMORY is set to AUTOMATIC, and if insufficient system memory problems are occurring.
• D.It is recommended that this variable be enabled at all times in order to prevent DB2 from taking too much physical memory.

What are two authorities and/or privileges required for replaying SQL audit logs? (Choose two.)

• A.EXECUTE privilege on audit routines with DATA
• B.SYSADM authority
• C.DBADM authority
• D.EXECUTE privilege on audit routines with NO DATA
• E.SECADM authority

Given a database created as follows:

If each table (T1 and T2) has 50,000 rows, which of the following commands will ensure that the temporary table created by the select statement will fit entirely in the buffer pool, assuming that there is a primary key/foreign key relationship between column C1 in table T1, and column C1 in table T2?

• A.CREATE BUFFERPOOL bp1 size 10000 PAGESIZE 8k;
• B.CREATE BUFFERPOOL bp1 size 5000 PAGESIZE 16k; ALTER TABLESPACE tempspace1 BUFFERPOOL bp1;
• C.CREATE BUFFERPOOL bp1 size 25000 PAGESIZE 32k;
• D.CREATE BUFFERPOOL bp1 SIZE 20000 PAGESIZE 4k; ALTER TABLESPACE tempspace1 BUFFERPOOL bp1;

If you know that the table space containers for your database reside on RAID-5 3+p arrays, which registry variable should be assigned the value *:3 to help improve performance?

• A.DB2_EXTENDED_IO_FEATURES
• B.DB2_PARALLEL_IO
• C.DB2_APM_PERFORMANCE
• D.DB2_RESOURCE_POLICY

What is required to successfully use the check backup utility (db2ckbkp)?

• A.system administrator authority
• B.system maintenance authority
• C.read permission on the backup image
• D.read permission on the database