2017 Nov IBM Official New Released C2090-614
100% Free Download! 100% Pass Guaranteed!

DB2 10.1 Advanced DBA for Linux UNIX and Windows

Question No: 21 – (Topic 1)

Given the following database design:

Ensurepass 2017 PDF and VCE

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?

  1. Create a replicated summary table for the SALES table using the table space TS_REPL.

  2. Create a replicated summary table for the DATE_DIM table using the table space TS_REPL.

  3. Create an index on both the DATE_DIM and the SALES table for the column that is used in the collocated join.

  4. Create a replicated summary table for the SALES table using the table space TS_DIM and create an index on the DATE_DIM table.

Answer: B

Question No: 22 – (Topic 1)

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

10.1 database?

  1. Manually delete old backups and logs.

  2. Utilize the PRUNE LOGFILE PRIOR TO command to remove old backups and logs.

  3. Utilize the PRUNE HISTORY AND DELETE command to remove old backups and logs.

  4. Set the DB2PRUNE_ACTION_LOG configuration parameter to a desired date before generating a new backup.

Answer: C

Question No: 23 – (Topic 1)

If the following statements are executed: CREATE STOGROUP sg_hot ON #39;/path1#39;, #39;/path2#39;, #39;/path3#39;; CREATE STOGROUP sg_med ON #39;/path4#39;, #39;/path5#39;, #39;/path6#39;; CREATE TABLESPACE tbsp1 USING STOGROUP sg_hot; What is the recommended way to move table space TBSP1 from storage group SG_HOT to storage group SG_MED?

  1. Issue an ALTER TABLESPACE statement with the #39;USING sg_med#39; option.

  2. Issue an ALTER STOGROUP statement with the #39;MOVE tbsp1 TO sg_med#39; option.

  3. Perform a table space RESTORE operation with the #39;USING STOGROUP sg_hot#39; option.

  4. Use the ADMIN_MOVE_TABLESPACE procedure to move table space TBSP1 to SG_HOT.

Answer: A

Question No: 24 – (Topic 1)

A DB2 9 database named MYDB that does not use automatic storage was migrated to DB2

10.1. When will a default storage group be defined for this database?

  1. The first time the database is accessed after the migration.

  2. The first time the CREATE STOGROUP statement is executed.

  3. When the ALTER DATABASE mydb CONVERT statement is used to convert the database to an automatic storage database.

  4. When the ALTER TABLESPACE statement is used to convert the table space that holds the system catalog for the database to automatic storage.

Answer: B

Question No: 25 – (Topic 1)

Which statement about value compression is correct?

  1. To use value compression, you must have a license for the DB2 Storage Optimization Feature.

  2. Value compression uses a page-level dictionary-based compression algorithm to compress data based on repetition of values found in a single column.

  3. Value compression involves removing duplicate entries for a value, only storing one copy, and keeping track of the location of any references to the stored copy.

  4. When value compression is used, the byte count of compressed NULLs, zeros, and blanks might be larger than that of the uncompressed version of the same values.

Answer: C

Question No: 26 – (Topic 1)

A DBA wants to create a table named SALES that has the following characteristics:

?effective data clustering and management of space utilization ?rows in the table should be clustered based on when they are added to the table Which clause must be used with the CREATE TABLE statement to define this table?





Answer: B

Question No: 27 – (Topic 1)

The following message is frequently seen in the DB2 Diagnostics Log file (db2diag.log): MESSAGE : ADM5502W The escalation of quot;28581quot; locks on table quot;TEST.TABLE1quot; to lock intent quot;Xquot; was successful. Which two database configuration parameter settings should be checked? (Choose two.)






Answer: A,C

Question No: 28 – (Topic 1)

Which constraints are used to tell the DB2 Optimizer to consider business rules that are not enforced by the database manager?

  1. Check constraints

  2. Default constraints

  3. Informational constraints

  4. Referential integrity constraints

Answer: C

Question No: 29 – (Topic 1)

The following statement was used to create a table space named USER_TMP in a non- partitioned database: CREATE USER TEMPORARY TABLESPACE user_tmp MANAGED BY SYSTEM USING (?mnt/fsystem4? ?mnt/fsystem5? Which operation can be performed on the USER_TMP table space with an ALTER TABLESPACE statement?

  1. New storage containers can be added to it.

  2. A different buffer pool can be associated with it.

  3. A hard limit can be placed on the size to which its storage containers can grow.

  4. Its high water mark can be lowered and its size can be reduced to the high water mark.

Answer: B

Question No: 30 – (Topic 1)

Which statement about Range Clustered Tables (RCT) is correct?

  1. Storage space is not pre-allocated for an RCT.

  2. The ALTER TABLE statement can be used to change the physical structure of an RCT.

  3. When defining a range of key values for an RCT, a minimum value is optional.

  4. The minimum value of a key column for an RCT cannot be a negative value.

Answer: C

100% Free Download!
Download Free Demo:C2090-614 Demo PDF
100% Pass Guaranteed!
Download 2017 EnsurePass C2090-614 Full Exam PDF and VCE

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2017 EnsurePass IT Certification PDF and VCE