IBM IBM Certified Advanced Database Administrator C2090-614 Questions & Answers

• Question 71:

  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?

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

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

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

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

  Correct Answer: B

• Question 72:

  If the following statements are executed:

  CREATE STOGROUP sg_hot ON '/path1', '/path2', '/path3'; CREATE STOGROUP sg_med ON '/path4', '/path5', '/path6'; 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?

  A. Issue an ALTER TABLESPACE statement with the 'USING sg_med' option.

  B. Issue an ALTER STOGROUP statement with the 'MOVE tbsp1 TO sg_med' option.

  C. Perform a table space RESTORE operation with the 'USING STOGROUP sg_hot' option.

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

  Correct Answer: A

• Question 73:

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

  A. Perform an ALTER TABLESPACE...REDUCE operation.

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

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

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

  Correct Answer: C

• Question 74:

  Which table configuration CANNOT utilize multi-temperature storage?

  A. A range-partitioned table utilizing multiple table spaces that map to DMS containers.

  B. Multiple tables containing the same data at different ages placed into the same table space.

  C. Multiple tables containing the same data at different ages placed into separate table spaces.

  D. A range-partitioned table utilizing multiple table spaces that map to individual storage groups.

  Correct Answer: B

• Question 75:

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

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

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

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

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

  Correct Answer: D

• Question 76:

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

  A. AIX

  B. Linux

  C. HP-UX

  D. Solaris

  E. Windows

  Correct Answer: AB

• Question 77:

  Which statement about data type mappings is true in a federated system?

  A. The Oracle DOUBLE data type maps to the DB2 type FLOAT by default.

  B. Data types can be mapped in both directions between a remote and local data type.

  C. Cast functions can be pushed down to remote servers even if a counterpart function does not exist there.

  D. For relational data sources, the degree to which you can override existing data type mappings or create mappings is limited.

  Correct Answer: B

• Question 78:

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

  A. InfiniBand with RDMA (IB)

  B. SCSI RDMA Protocol (SRP)

  C. iSCSI Extensions for RDMA (iSER)

  D. RDMA over Converged Ethernet (RoCE)

  E. Internet Wide Area RDMA Protocol (iWARP)

  Correct Answer: AD

• Question 79:

  To configure instance-level auditing with db2audit, which authority is required?

  A. SYSADM

  B. SYSCTRL

  C. SECADM

  D. SYSMAINT

  Correct Answer: A

• Question 80:

  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.

  Correct Answer: B