IBM C2090-544 Online Practice Questions and Exam Preparation

IBM C2090-544 Online Questions & Answers

• Question 61:

  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. Configuration Advisor
  B. Partition Assistant
  C. Design Advisor
  D. Workload Manager
  C. Design Advisor

• Question 62:

  Which statement about compression and temporary tables is NOT correct?

  A. When executing queries that require temporary tables, DB2 considers the storage savings and the impact to query performance to determine whether compression is worthwhile.
  B. Compression is only applied to created temporary tables that were defined with the CREATE TEMPORARY TABLE -COMPRESS YES statement.
  C. The minimum size that a table must be before compression is used is larger for temporary tables than for regular tables.
  D. The explain facility and the db2pd utility can be used to determine whether a temporary table has been compressed.
  B. Compression is only applied to created temporary tables that were defined with the CREATE TEMPORARY TABLE -COMPRESS YES statement.

• Question 63:

  Which factor should influence your selection of distribution key(s)?

  A. The distribution key(s) should include the most frequently accessed XML column(s).
  B. The distribution key(s) should include the longest column(s).
  C. The distribution key(s) should include column(s) with the smallest number of distinct values.
  D. The distribution key(s) should include the most frequently joined column(s).
  D. The distribution key(s) should include the most frequently joined column(s).

• Question 64:

  Which conditions must be met to implement HADR?

  A. Operating systems on primary and standby servers must be the same; DB2 versions need not be the same; and the databases must have the same bit-size (32 or 64 bit).
  B. Operating systems on primary and standby servers need not be the same; DB2 versions must be the same; and the databases need not have the same bit-size (32 or 64 bit).
  C. Operating systems on primary and standby servers must be the same; DB2 versions must be the same; and the databases need not have the same bit-size (32 or 64 bit).
  D. Operating systems on primary and standby servers must be the same; DB2 versions must be the same; and the databases must have the same bit-size (32 or 64 bit).
  D. Operating systems on primary and standby servers must be the same; DB2 versions must be the same; and the databases must have the same bit-size (32 or 64 bit).

• Question 65:

  Which command will back up a database named SAMPLE to a TSM server using two concurrent TSM client sessions?

  A. BACKUP DATABASE sample USE TSM OPEN 2 SESSIONS WITH 4 BUFFERS
  B. BACKUP DATABASE sample USE TSM OPEN 4 SESSIONS WITH 2 BUFFERS
  C. BACKUP DATABASE sample USE TSM OPEN 2 SERVERS WITH 4 BUFFERS
  D. BACKUP DATABASE sample USE TSM OPEN 4 SERVERS WITH 2 BUFFERS
  A. BACKUP DATABASE sample USE TSM OPEN 2 SESSIONS WITH 4 BUFFERS

• Question 66:

  Given INTRA_PARALLEL is OFF, average row length is 900 bytes, and temporary table cardinality is 1000, which setting would prevent a SORTHEAP overflow when the temporary table is sorted?

  A. SORTHEAPTHRES 10000K, SORTHEAP 250K
  B. SORTHEAPTHRES 10000K
  C. SORTHEAP AUTOMATIC, SHEAPTHRES 10000K
  D. SORTHEAP AUTOMATIC, SHEAPTHRES 0
  D. SORTHEAP AUTOMATIC, SHEAPTHRES 0

• Question 67:

  Given the following table definition in a multi-partitioned database:

  

  Which column(s) will be chosen by DB2 as a distribution key (partitioning key)?

  A. SS_ID
  B. EMP_ID
  C. NAME
  D. SS_ID, EMP_ID, and NAME
  A. SS_ID

• Question 68:

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

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

• Question 69:

  Given a SHEAPTHRES value of 2560, in which two cases will a SHEAPTHRES_SHR value of 1024 be meaningful? (Choose two.)

  A. INTRA_PARALLEL NO
  B. MAX_CONNECTIONS 2000, MAX_COORDAGENTS 100
  C. MAX_AGENTS 100, MAX_CONNECTIONS 2000
  D. MAX_CONNECTIONS 500, MAX_COORDAGENTS 1000
  E. INTRA_PARALLEL YES
  B. MAX_CONNECTIONS 2000, MAX_COORDAGENTS 100
  E. INTRA_PARALLEL YES

• Question 70:

  If LOGSECOND=-1 then which of the following statements is true?

  A. You still use LOGPRIMARY and LOGFILSIZ configuration parameters to specify how many log files the database manager should keep in the active log path.
  B. You must configure the OVERFLOWLOGPATH configuration parameter if your active log path is not on a raw device.
  C. The database will reserve active log space for transactions that may need to roll back and write log records.
  D. An infinite number of overflow log files will be used with archival logging.
  A. You still use LOGPRIMARY and LOGFILSIZ configuration parameters to specify how many log files the database manager should keep in the active log path.