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: 41 – (Topic 1)

On which two operating systems can DB2 pureScale run? (Choose two.)

  1. AIX

  2. Linux

  3. HP-UX

  4. Solaris

  5. Windows

Answer: A,B

Question No: 42 – (Topic 1)

A table space creation operation was unsuccessful because DB2 failed to allocate a container in a path. Which diagnostic tool can be used to help resolve the problem?

  1. db2dart

  2. db2diag

  3. db2caem

  4. db2fmcu

Answer: B

Question No: 43 – (Topic 1)

Which statement about compression dictionaries is FALSE?

  1. Page-level dictionaries are stored in hidden rows within the table.

  2. Table-level dictionaries are stored in hidden rows within the table.

  3. Page-level dictionaries are automatically created or recreated by the database manager as pages are filled.

  4. Table-level dictionaries are automatically created or recreated as by the database manager as pages are filled.

Answer: D

Question No: 44 – (Topic 1)

A database administrator created all of the necessary federated objects for an SQL Server data source in a federated system. Which steps must be performed if the data types of several columns in the SQL Server data source are changed?

  1. Drop the current data type mapping. Create the new data type mapping.

  2. Drop the nickname to the table. Create the new data type mapping. Recreate the nickname to the table.

  3. Drop the current data type mapping. Create the new data type mapping. Drop the nickname to the table. Recreate the nickname to the table.

  4. Drop the current user mapping.

Drop the current data type mapping. Create the new user mapping.

Create the new data type mapping. Recreate the nickname to the table.

Answer: B

Question No: 45 – (Topic 1)

Which category must be enabled before db2audit will record the creation of new buffer pools?

  1. OBJMAINT

  2. SECMAINT

  3. CHECKING

  4. OBJCREATE

Answer: A

Question No: 46 – (Topic 1)

A DBA wants to create a set of tables in a storage group named SG_1, but no table spaces have been assigned to this group. What kind of table spaces must the DBA assign to the storage group before the desired tables can be created?

  1. Automatic storage (AS) table spaces

  2. System managed space (SMS) table spaces

  3. Database managed space (DMS) table spaces that use FILE containers

  4. Database managed space (DMS) table spaces that use RAW containers

Answer: A

Question No: 47 – (Topic 1)

Which statement about DB2 Merge Backup is FALSE?

  1. It can be used to merge offline backups to build full offline table space backups.

  2. It can be used to merge SNAPSHOT and TSM tape backup images to create a full database backup image.

  3. It can be used merge multiple offline database backups to build a cumulative single offline database backup.

  4. It can be used to merge backups on a machine that is different from the machine where the backup has been created in stand-alone mode.

Answer: B

Question No: 48 – (Topic 1)

In which situation would you NOT use a redirected restore?

  1. To redefine the paths of a defined storage group.

  2. To move table space containers onto different physical devices.

  3. To restore a backup image from one operating system to another.

  4. To restore a backup image to a target machine that is different from the source machine.

Answer: C

Question No: 49 – (Topic 1)

What is the FAILARCHPATH database configuration parameter used for?

  1. To specify a path that DB2 will use to look for archive log files that are needed for a rollforward recovery operation.

  2. To specify a path to which DB2 will attempt to store a copy of archive log files to protect against accidental deletion.

  3. To specify a path to which DB2 will attempt to store a copy of both active and archive log files to protect against disk failure and power outages.

  4. To specify a path to which DB2 will attempt to store archive log files if they cannot be written to the primary or secondary archive destination because of a media problem.

Answer: D

Question No: 50 – (Topic 1)

What statement regarding Asynchronous index cleanup (AIC) is correct?

  1. AIC removes all invalid index entries that refer to the attached partitions.

  2. AIC is initiated if a range-partitioned table contains one or more nonpartitioned indexes.

  3. AIC activates a newly attached partition after the index entries have been synchronized.

  4. AIC will not be initiated if a range-partitioned table has dependent materialized query tables (MQTs).

Answer: B

100% Ensurepass Free Download!
Download Free Demo:C2090-614 Demo PDF
100% Ensurepass Free 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
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2017 EnsurePass IT Certification PDF and VCE