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

• Question 51:

  What are two services that the cluster caching facility (CF) provides in a DB2 pureScale environment? (Choose two.)

  A. Global Lock Management (GLM)

  B. Group Transaction Routing (GTR)

  C. Automated Member Restart (AMR)

  D. Buffer Pool Synchronization (BPS)

  E. Shared Communications Area (SGA)

  Correct Answer: AE

• Question 52:

  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)

  Correct Answer: B

• Question 53:

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

  A. SYSADM

  B. SYSCTRL

  C. SECADM

  D. SYSMAINT

  Correct Answer: A

• Question 54:

  Which configuration parameter setting(s) are needed to force authentication to happen at the data source in a federated database environment?

  A. FEDERATED set to YES

  B. FEDERATED set to YES AUTHENTICATION set to SERVER or SERVER_ENCRYPT

  C. FEDERATED set to YES FED_NOAUTH set to YES

  D. FEDERATED set to YES FED_NOAUTH set to YES

  AUTHENTICATION set to SERVER or SERVER_ENCRYPT

  Correct Answer: D

• Question 55:

  Which index(es) are created when a multidimensional clustering (MDC) table is defined with only one dimension?

  A. One composite block index and one unique index.

  B. One composite clustering index and one dimension block index.

  C. One index that serves as both the dimension block index and the composite block index.

  D. One index that serves as both the dimension block index and the composite clustering index.

  Correct Answer: C

• Question 56:

  For a multi-partitioned database, what is the default behavior of the BACKUP DATABASE command?

  A. It will backup just the catalog partition.

  B. It will backup all partitions simultaneously.

  C. It will backup just the partition that the command is executed from.

  D. It will backup just the partitions that reside on the host that the command is executed from.

  Correct Answer: C

• Question 57:

  Which statement about Range Clustered Tables (RCT) is correct?

  A. Storage space is not pre-allocated for an RCT.

  B. The ALTER TABLE statement can be used to change the physical structure of an RCT.

  C. When defining a range of key values for an RCT, a minimum value is optional.

  D. The minimum value of a key column for an RCT cannot be a negative value.

  Correct Answer: C

• Question 58:

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

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

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

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

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

  Correct Answer: C

• Question 59:

  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

  Correct Answer: B

• Question 60:

  A table named SALES was created as follows:

  

  Assuming all table spaces required already exist, which statement(s) must be executed to add a new partition that already contains data for the first quarter of 2013 to the SALES table and leave the table accessible?

  A. ALTER TABLE sales ADD PARTITION part_2013q1 STARTING ('01/01/2013') ENDING ('03/31/2013') IN ts5;

  B. ALTER TABLE sales ATTACH PARTITION part_2013q1 STARTING ('01/01/2013') ENDING ('03/31/2013') FROM TABLE q12013_sales;

  C. ALTER TABLE sales ADD PARTITION part_2013q1 STARTING ('01/01/2013') ENDING ('03/31/2013') IN ts5; SET INTEGRITY FOR sales IMMEDIATE CHECKED;

  D. ALTER TABLE sales ATTACH PARTITION part_2013q1 STARTING ('01/01/2013') ENDING ('03/31/2013') FROM TABLE q12013_sales; SET INTEGRITY FOR sales IMMEDIATE CHECKED;

  Correct Answer: D