IBM C2090-614 Online Practice Questions and Exam Preparation

IBM C2090-614 Online Questions & Answers

• Question 31:

  Given the following database design:

  

  A Explain plan shows that a broadcast join is being used by a query that joins the DATE_DIM dimension table and the SALES fact table. Which action should be performed to improve query performance?

  A. Create a replicated summary table for the SALES table using the table space TS_REPL.
  B. Create a replicated summary table for the DATE_DIM table using the table space TS_REPL.
  C. Create an index on both the DATE_DIM and the SALES table for the column that is used in the collocated join.
  D. Create a replicated summary table for the SALES table using the table space TS_DIM and create an index on the DATE_DIM table.
  B. Create a replicated summary table for the DATE_DIM table using the table space TS_REPL.

• Question 32:

  What type of file system is used to store data and logs in a DB2 pureScale environment?

  A. Network File System (NFS)
  B. General Parallel File System (GPFS)
  C. Common Internet File System (CIFS)
  D. Enhanced Journaled File System (JFS2 or EXT4)
  B. General Parallel File System (GPFS)

• Question 33:

  After starting a series of LOAD operations it appears that one LOAD is failing. What diagnostic tool would you use to determine which LOAD operation is being problematic?

  A. db2pd
  B. db2dart
  C. db2fodc
  D. db2ls
  A. db2pd

• Question 34:

  Which type of storage is utilized in the implementation of an effective and flexible multi- temperature database?

  A. System managed storage
  B. Automatic storage utilizing storage groups
  C. System managed storage utilizing storage groups
  D. Database managed storage with file system caching
  B. Automatic storage utilizing storage groups

• Question 35:

  What is the recommended method for removing old backup images and log files for a DB2 10.1 database?

  A. Manually delete old backups and logs.
  B. Utilize the PRUNE LOGFILE PRIOR TO command to remove old backups and logs.
  C. Utilize the PRUNE HISTORY AND DELETE command to remove old backups and logs.
  D. Set the DB2PRUNE_ACTION_LOG configuration parameter to a desired date before generating a new backup.
  C. Utilize the PRUNE HISTORY AND DELETE command to remove old backups and logs.

• Question 36:

  Which would not significantly benefit from having the RUNSTATS command run on it?

  A. Tables that have had little change.
  B. Tables where a new index has been created.
  C. Tables that have been reorganized (using REORG).
  D. Tables that have been populated with a LOAD operation.
  A. Tables that have had little change.

• Question 37:

  Which item is NOT eligible for adaptive compression?

  A. Indexes
  B. Base tables
  C. Temporary tables
  D. Inline LOB values
  C. Temporary tables

• Question 38:

  Prior to migrating to DB2 10.1, a DBA executed the following command on a daily basis:

  db2_all "<<-1< db2 BACKUP DATABASE sales TO /mnt/backup" Which command can now be used to perform the same backup operation?

  A. BACKUP DATABASE sales ON DBPARTITIONNUM (1) TO /mnt/backup
  B. BACKUP DATABASE sales ON ALL DBPARTITIONNUMS TO /mnt/backup
  C. BACKUP DATABASE sales ON ALL DBPARTITIONNUMS EXCEPT CATPARTITION TO /mnt/backup
  D. BACKUP DATABASE sales ON ALL DBPARTITIONNUMS EXCEPT DBPARTITIONNUM (1) TO /mnt/backup
  D. BACKUP DATABASE sales ON ALL DBPARTITIONNUMS EXCEPT DBPARTITIONNUM (1) TO /mnt/backup

• Question 39:

  Which statement about Insert-Time-Clustered (ITC) is correct?

  A. Views cannot be created on ITC tables.
  B. ITC tables do not support row compression.
  C. Block indexes cannot be created for ITC tables.
  D. ITC tables can release their empty pages to the operating system.
  C. Block indexes cannot be created for ITC tables.

• Question 40:

  Which table configuration CANNOT utilize multi-temperature storage?

  A. A range-partitioned table utilizing multiple table spaces that map to DMS containers.
  B. Multiple tables containing the same data at different ages placed into the same table space.
  C. Multiple tables containing the same data at different ages placed into separate table spaces.
  D. A range-partitioned table utilizing multiple table spaces that map to individual storage groups.
  B. Multiple tables containing the same data at different ages placed into the same table space.