Ensurepass.com : Ensure you pass the IT Exams
2017 Nov 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: 31 – (Topic 1)

What event category is used with the db2audit command to capture SQL data, such as host variable and parameter marker values, that are associated with an SQL statement?

  1. AUDIT

  2. VALIDATE

  3. EXECUTE

  4. CONTEXT

Answer: C

Question No: 32 – (Topic 1)

In which scenario should a DBA consider creating a multidimensional clustering (MDC) table instead of a regular base table?

  1. To improve access performance for tables in an OLTP database.

  2. To improve index performance in a data warehouse environment.

  3. To improve query performance in a data warehouse environment.

  4. To improve insert/delete performance for tables in an OLTP database.

Answer: C

Question No: 33 – (Topic 1)

Which procedure is used to Explain an SQL statement using information obtained from the package cache or the package cache event monitor?

  1. EXPLAIN_FROM_DATA

  2. EXPLAIN_FROM_ACTIVITY

  3. EXPLAIN_FROM_SECTION

  4. EXPLAIN_FROM_CATALOG

Answer: C

Question No: 34 – (Topic 1)

What contributes to the efficient use of block-based buffer pools?

  1. The application does not use sequential prefetching.

  2. The application performs a lot of random I/O operations.

  3. The table space extent size is equal to the block size specified for the buffer pool.

  4. The table space prefetch size is equal to the block size specified for the buffer pool.

Answer: C

Question No: 35 – (Topic 1)

Where is the HADR_TARGET_LIST configuration parameter set?

  1. On the primary database only.

  2. On all participating databases.

  3. On the tertiary standby databases.

  4. On the auxiliary standby databases only.

Answer: B

Question No: 36 – (Topic 1)

What is a benefit of multi-temperature data storage?

  1. It helps reduce redundant I/O.

  2. It helps improve data compression ratios.

  3. It helps reduce storage costs for infrequently accessed data.

  4. It helps identify data access patterns to aid in storage planning.

Answer: C

Question No: 37 – (Topic 1)

What is the preferred method for reclaiming unused storage in a DMS table space?

  1. Perform an ALTER TABLESPACE…REDUCE operation.

  2. Perform a REORG on each table within the table space, then perform an ALTER TABLESPACE…REDUCE operation.

  3. Perform an ALTER TABLESPACE…LOWER HIGH WATER MARK operation, and then an ALTER TABLESPACE…REDUCE operation.

  4. Perform a REORG on each table within the table space, then perform an ALTER TABLESPACE…LOWER HIGH WATER MARK operation.

Answer: C

Question No: 38 – (Topic 1)

What advantage do block-based buffer pools offer compared to regular buffer pools?

  1. They improve the performance of sequential prefetching by reading contiguous pages from disk and writing them into contiguous pages in a buffer pool.

  2. They improve the performance of random I/O by reading non-contiguous pages from disk and writing them into near-contiguous free space in a buffer pool.

  3. They improve the performance of vectored reads by retrieving non-contiguous pages from disk, combining them into extent-sized blocks, and writing the blocks into contiguous pages in a buffer pool.

  4. They improve the performance of scattered writes by retrieving non-contiguous pages from a buffer pool, combining them into extent-sized blocks, and writing the blocks into contiguous pages on disk.

Answer: A

Question No: 39 – (Topic 1)

What are two supported methods for providing a low latency, high speed interconnect between DB2 members and the cluster caching facility (CF) in a DB2 pureScale environment? (Choose two.)

  1. InfiniBand with RDMA (IB)

  2. SCSI RDMA Protocol (SRP)

  3. iSCSI Extensions for RDMA (iSER)

  4. RDMA over Converged Ethernet (RoCE)

  5. Internet Wide Area RDMA Protocol (iWARP)

Answer: A,D

Question No: 40 – (Topic 1)

What must you do before an online table space backup operation can be performed?

  1. Create a full database backup image.

  2. Create one or more tables in the table space.

  3. Create an incremental backup image of the table space.

  4. Set the DB2_ENABLE_ONLINEBKUP registry variable to ON.

Answer: A

100% Ensurepass Free Download!
Download Free Demo:C2090-614 Demo PDF
100% Ensurepass Free Guaranteed!
Download 2017 EnsurePass 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

2017 EnsurePass IT Certification PDF and VCE