C2090-600 Online Practice Questions and Answers

You suspect there is a communications issue between a member and a cluster caching facility (CF) in a DB2 pureScale instance. Which command will provide diagnostic information that can be used to confirm your suspicions?

A. db2cluster -verify

B. db2cluster -cm -list -alert

C. db2cluster -verify -configuration

D. db2cluster -cm -verify -resource

What is the schema name of the DB2 built-in global variable TRUSTED_CONTEXT?

A. SYSIBM

B. SYSFUN

C. SYSCAT

D. SYSIBMADM

When the DB2_WORKLOAD registry variable is assigned the value ANALYTICS and then a new database is created, what happens? (Choose two.)

A. The PAGESIZE database configuration parameter is set to 32K.

B. The AUTO_REORG database configurationparameter is set to NO.

C. The DFT_EXTENT_SZ database configuration parameter is set to 8.

D. The DFT_TABLE_ORG database configuration parameter is set to COLUMN.

E. The INTRA_PARALLEL database manager configuration parameter is set to NO.

Which options are valid for an online reorganization operation?

A. FULL and RECLAIM EXTENTS

B. CLASSIC and RECLAIM EXTENTS

C. FULL and CLEANUP OVERFLOWS

D. CLEAN OVERFLOWS and RECLAIM EXTENTS

Which of the following commands will list all of the disk configurations of the file system DATAFS in a DB2 pureScale cluster?

A. db2cluster –cfs –list –filesystem datafs

B. db2cluster –cfs –display –filesystem datafs

C. db2cluster –cfs –listconfig –filesystem datafs

D. db2cluster –cfs –displayconfig –filesystem datafs

What does dsmtop use to gather metrics?

A. db2pd

B. db2dart

C. the system catalog

D. monitoring tablefunctions

When choosing the dimensions for an MDC table, poor space utilization can occur due to low cell density. What can cause an MDC table to use much more space?

A. The page size is too small.

B. The extent size is too small.

C. Low cardinality of the dimension(s) chosen.

D. High cardinality of the dimension(s) chosen.

Which statement about the db2move command is TRUE?

A. The LOAD actions can be run from a client machine.

B. Object ownership cannot be changed after a successful schema copy operation.

C. Tables containing GENERATED ALWAYS identity columns can be imported or loaded.

D. Loading data into tables containing XML columns is only supported for the LOAD actions.

If Secure Sockets Layer is a requirement, which of the following parameters must be set to encrypt data in transit?

A. Set the DB2COMM registry variable to DB2COMM=SSL

B. Set the DB2COMM registry variable to DB2COMM=SSL, TCPIP

C. Set the AUTHENTICATION configuration parameter to DATA_ENCRYPT

D. Set the AUTHENTICATION configuration parameter to SERVER_ENCRYPT

You receive a large data file that contains large object data values that need to be copied into a table in the shortest amount of time possible. Which utility should be used?

A. LOAD

B. INGEST

C. IMPORT

D. TRANSPORT