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

• Question 61:

  Which statement is true regarding the workload management dispatcher?

  A. The workload management dispatcher monitors work performed by entities executing in the DB2 system service class.

  B. The workload management dispatcher monitors the allocation of CPU resources between service classes on a system.

  C. The workload management dispatcher monitors non-DB2 work performed in fenced mode processes such as fenced stored procedures.

  D. The workload management dispatcher monitors work performed by applications or middleware products that perform a portion of their workoutside of the DB2 database manager.

  Correct Answer: B

• Question 62:

  By analyzing EXPLAIN data, you notice that a table scan is being performed instead of an index scan even though an index exists. In order to utilize the existing index, what should be done before issuing the RUNSTATS command to collect statistics for both the index and table?

  A. Drop and reload the table.

  B. Drop and recreate the index.

  C. Reorganize the table to cluster its data according to that index.

  D. Reorganize the table to cluster its index according to that query plan.

  Correct Answer: C

• Question 63:

  Which system command can be used to locate and return only ADM4500W messages from the DB2 diagnostics log file?

  A. db2pd

  B. db2diag

  C. db2trace

  D. db2fmtdiag

  Correct Answer: B

• Question 64:

  Which statement about the db2pd tool is true?

  A. It may retrieve data that is not completely accurate.

  B. It collects information from the log buffer and active log files.

  C. It ensures that information is not retrieved on changing data.

  D. It collects information from the snapshot monitor and a predefined set of event monitors.

  Correct Answer: A

• Question 65:

  What authority is required to create, alter and drop workload management objects?

  A. SYSADM

  B. SECADM

  C. WLMADM

  D. ACCESSCTRL

  Correct Answer: C

• Question 66:

  Which statement regarding snapshot administrative views and snapshot monitor table functions is true?

  A. Snapshot administrative views cannot be used with monitor switches or monitor reset commands while snapshot table functions have no suchrestrictions.

  B. Snapshot table functions cannot be used with monitor switches or monitor reset commands while snapshot administrative views have no suchrestrictions.

  C. Snapshot administrative views provide the option to choose between data from a single database partition or a data subset from across alldatabase partitions while snapshot table functions provide access to data from each database partition.

  D. Snapshot administrative views provide access to data from each database partition while snapshot table functions provide the option to choosebetween data from a single database partition or a data subset from across all database partitions.

  Correct Answer: D

• Question 67:

  Given the following statement:

  

  How many constraints are present in the DEPARTMENT table?

  A. 1

  B. 2

  C. 3

  D. 4

  Correct Answer: D

• Question 68:

  Which two server authentication methods are supported by transparent Lightweight Directory Access Protocol (LDAP)? (Choose two.)

  A. CLIENT

  B. SERVER

  C. LDAP_PLUGIN

  D. DATA_ENCRYPT

  E. KERBEROS_PLUGIN

  Correct Answer: BD

• Question 69:

  Which command is used to export connectivity configuration information from a file known as a configuration profile?

  A. db2ca

  B. db2cfexp

  C. db2cfimp

  D. db2cfgexp

  Correct Answer: B

• Question 70:

  Which statement is true regarding client-server database connectivity?

  A. A remote connection uses Interprocess Communication (IPC).

  B. A loopback connection can be made with either the APPC or TCP/IP protocol enabled.

  C. A remote connection is established between a DB2 client in a different location from the database server.

  D. A DB2 client running a lower version of DB2 can establish a local connection to a server running on a newer version.

  Correct Answer: C