Ensurepass.com : Ensure you pass the IT Exams
2018 Jan IBM Official New Released C2090-614
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/C2090-614.html

DB2 10.1 Advanced DBA for Linux UNIX and Windows

Question No: 51 – (Topic 1)

A storage group named HOT_SG was created as follows:

Ensurepass 2018 PDF and VCE

What does the DATA TAG 1 clause do?

  1. It indicates that the multiple storage paths referenced in the HOT_SG storage group definition exist in one physical location.

  2. It tells the DB2 Optimizer that database objects stored in the HOT_SG storage group are to be given preference over other objects when data access plans are generated.

  3. It indicates that the value 1 is to be assigned to data stored in the HOT_SG storage group, which Workload Manager (WLM) can then use to determine the processing priority to assign to database activities that interact with this data.

  4. It assigns a unique identifier to the instance of the HOT_SG storage group being defined; this identifier can then be used when moving table spaces to and from the storage group, when dropping the storage group, or when commenting on the storage group.

Answer: C

Question No: 52 – (Topic 1)

Which statement about dropped table recovery is correct?

  1. Multiple dropped tables can be recovered with a single table space-level restore operation.

  2. By default, the DROPPED TABLE RECOVERY option is off when a new table space is created.

  3. The dropped table recovery feature lets you recover only dropped table data with a database-level restore operation.

  4. For a dropped table to be recoverable, the table space in which the table resides must have the DROPPED TABLE RECOVERY option turned on.

Answer: D

Question No: 53 – (Topic 1)

Which statement about IBM WebSphere Information Integrator Q Replication is correct?

  1. It reads the DB2 recovery log and stores committed transactional data in staging tables.

  2. It reads the DB2 recovery log and converts committed transactional data to SQL statements.

  3. It provides the lowest latency of data in the target databases and lowest throughput of changed data to the target databases.

  4. It provides the lowest latency of data in the target databases and highest throughput of changed data to the target databases.

Answer: D

Question No: 54 – (Topic 1)

Which monitoring tool can be used to obtain stripe set information for database managed storage table spaces?

  1. The MON_GET_CONTAINER table function.

  2. The SNAP_GET_TBSP_PART table function.

  3. The SNAPTBSP_RANGE administrative view.

  4. The TS_GET_CONTAINER administrative view.

Answer: A

Topic 2, Volume B

Question No: 55 – (Topic 2)

A storage group named MED_SG was created as follows: CREATE STOGROUP med_sg ON ?db2fs1? ?db2fs2? #39;/db2fs3#39; Then, a table space named TS1 was created in the storage group and two tables (TAB_A and TAB_B) were created in the TS1 table space. Four months later, a DBA discovered that 90% of the space that had been allocated to the MED_SG storage group had been consumed. So, more space was added to the storage group by executing the following command: ALTER STOGROUP med_sg ADD ?db2fs4? ALTER STOGROUP med_sg ADD ?db2fs4 Shortly afterwards, queries against tables in the TS1 table space began to run slower. Which statement should be executed to correct the performance problem?

  1. ALTER TABLESPACE ts1 REBALANCE

  2. ALTER STOGROUP med_sg ADD ?db2fs5?ALTER STOGROUP med_sg ADD ?db2fs5

  3. ALTER STOGROUP med_sg DROP #39;/db2fs4#39;

  4. ALTER TABLESPACE ts1 ADD #39;/db2fs4#39; REBALANCE

Answer: A

Question No: 56 – (Topic 2)

If the AUDIT_BUF_SZ configuration parameter is set to zero (0), what will happen?

  1. The audit facility writes records to disk at the same time the statements generating the audit records are executing.

  2. Statements generating audit records must wait for the records to be written to disk before they can complete execution.

  3. The writing of audit records to disk will be delayed until a minimum number of records (based on record size and memory available in the database heap) have been generated.

  4. There is no limit to how many audit records can be stored in an internal memory buffer for one single statement generating audit records.

Answer: B

Question No: 57 – (Topic 2)

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

  1. Views cannot be created on ITC tables.

  2. ITC tables do not support row compression.

  3. Block indexes cannot be created for ITC tables.

  4. ITC tables can release their empty pages to the operating system.

Answer: C

Question No: 58 – (Topic 2)

An auditor has requested that all activities performed by those with SYSADM or DBADM authority be tracked. How can this be done with the db2audit tool?

  1. By creating a SYSADM ROLE and capturing SYSMAINT event records.

  2. By creating an AUDIT POLICY and associating it with SYSADM and DBADM authority.

  3. By creating a SYSADM ROLE and capturing SYSADMIN and CHECKING event records.

  4. By creating a AUDIT POLICY and associating it with SYSMAINT, SYSADMIN and CHECKING event records.

Answer: B

Question No: 59 – (Topic 2)

What can be done to prevent applications from failing when DB2 cannot create a new log file?

  1. Set MAX_LOG to 0

  2. Set LOGBUFSZ to -1

  3. Set LOGSECOND to -1

  4. Set BLK_LOG_DSK_FUL to YES

Answer: D

Question No: 60 – (Topic 2)

Which statement about block indexes is correct?

  1. Because of their large size, block indexes are extremely efficient.

  2. Block indexes improve performance when data is not clustered on sequential pages.

  3. Prefetching of data pages relies on sequential detection when block indexes are used.

  4. The records for each block are retrieved using a mini-relational scan of saved data pages.

Answer: C

100% Ensurepass Free Download!
Download Free Demo:C2090-614 Demo PDF
100% Ensurepass Free Guaranteed!
C2090-614 Dumps

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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.