IBM C2090-600 Exam Practice Test Instant Access

Question 1

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?

Adb2cluster -verify

Bdb2cluster -cm -list -alert

Cdb2cluster -verify -configuration

Ddb2cluster -cm -verify -resource

Answer : D

Question 2

What does dsmtop use to gather metrics?

Adb2pd

Bdb2dart

Cthe system catalog

Dmonitoring tablefunctions

Answer : D

Question 3

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

ASYSIBM

BSYSFUN

CSYSCAT

DSYSIBMADM

Answer : A

Question 4

How would you enable self-tuning of memory areas that are controlled by memory configuration parameters?

ASet the DB2_WORKLOAD aggregate registry variable to ANALYTICS for self-tuning of the sort parameter on workloads that access column-organized tables.

BSet the SELF_TUNING_MEM database configuration parameter to ON using the UPDATE DATABASECONFIGURATION command or the db2CfgSet API.

CSet the sortheap or the sheapthres_shr configuration parameters to AUTOMATIC using the UPDATE DATABASE CONFIGURATION command or the db2CfgSet API with sheapthres set to at least 4K.

DUse AUTOMATIC keyword for the buffer pool size on the CREATE BUFFERPOOL statement or the ALTER BUFFERPOOL statement after making sure that at least one entry is present in SYSCAT.BUFFERPOOLDBPARTITIONS.

Answer : B

Question 5

Which of the following enables the user to connect to the HADR standby database and execute select statements?

ADB2_HADR_ROS

BHADR_SPOOL_LIMIT

CDB2_HADR_SOSNDBUF

DDB2_HADR_PEER_WAIT_LIMIT

Answer : A

Question 6

Which statement regarding event monitors is TRUE?

AEvent monitor data can be reviewed while the event monitor is active

BEvent monitors must always be started manually after activating a database

CEvent monitors must write data to .EVT files before the data can be loaded into database tables

DEvent monitors are used to obtain information about how a database system looks at a specific point in time

Answer : B

Question 7

Which command can be used to view the configured global registry settings for all installed DB2 copies found on a Linux server?

Adb2val

Bdb2set

Cdb2look

Ddb2greg

Answer : B

IBM C2090-600 IBM DB2 11.1 DBA for LUW Exam Practice Test