C2090-614 Online Practice Questions and Answers

Which statement about the initiation of parallel I/O is correct?

A. For list prefetching, each list of data pages is divided into smaller lists according to extent boundaries and assigned to different I/O servers.

B. For read-ahead prefetching, each list of data pages is divided into smaller lists according to extent boundaries and assigned to different I/O servers.

C. For sequential prefetching, parallel I/O is initiated when the prefetch size is a multiple of the extent size for a table space. Each prefetch request is divided into smaller requests and assigned to different I/O servers.

D. For sequential prefetching, parallel I/O is initiated when the extent size is a multiple of the prefetch size for a table space. Each prefetch request is divided into smaller requests and assigned to different I/O servers.

Which diagnostic tool can be used to collect metrics on individual SQL statement executions?

A. db2dart

B. A snapshot monitor

C. A statement event monitor

D. The MON_GET_UNIT_OF_WORK_DETAILS table function

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?

A. Drop the current data type mapping.

Create the new data type mapping.

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

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

D. 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.

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?

A. Automatic storage (AS) table spaces

B. System managed space (SMS) table spaces

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

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

What must be done to convert an existing table into an Insert-Time-Clustered (ITC) table?

A. Call the ADMIN_MOVE_TABLE procedure.

B. Call the ADMIN_REVALIDATE_DB_OBJECTS procedure.

C. Issue a REORG TABLE statement with the ORGANIZE BY INSERT TIME option.

D. Issue an ALTER TABLE statement with the ORGANIZE BY INSERT TIME option.

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

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

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

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

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

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)

Which is a poor choice for a clustering dimension of a multidimensional clustering (MDC) table?

A. Columns with low cardinalities

B. Columns with high cardinalities

C. Columns involved in roll-in or roll-out of data

D. Columns involved in equality or range predicate queries

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?

A. ORGANIZE BY DIMENSIONS

B. ORGANIZE BY INSERT TIME

C. ORGANIZE BY TIME PERIOD

D. ORGANIZE BY KEY SEQUENCE

With HADR, IBM Tivoli System Automation for Multiplatforms (SA MP) automated failover can be used with which database(s)?

A. The primary database only.

B. The auxiliary standby database only.

C. The principal standby database only.

D. The primary, auxiliary standby, and principal standby database.