IBM C2090-600 Exam Questions Instant Access

Question 1

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

ASet the DB2COMM registry variable to DB2COMM=SSL

BSet the DB2COMM registry variable to DB2COMM=SSL, TCPIP

CSet the AUTHENTICATION configuration parameter to DATA_ENCRYPT

DSet the AUTHENTICATION configuration parameter to SERVER_ENCRYPT

Answer : B

Question 2

Which security mechanism is responsible for verifying that users are indeed who the claim to be?

AAuthentication

BRoles and privileges

CMandatory access control

DDiscretionary access control

Answer : A

Question 3

A DBA has observed that queries executed against SALES table have poor performance. DB2 tools have indicated that the level of data fragmentation in the SALES table is very high. Similar results were detected for indexes defined on the SALES table.

Which of the following commands should be used by the DBA to improve the performance of the queries run against the SALES table?

AREORG TABLE sales AND INDEXES ALL;RUNSTATS ON TABLE sales AND INDEXES ALL;

BREORG TABLE sales INPLACE;REORG INDEXES ALL FOR TABLE sales;RUNSTATS ON TABLE salesAND INDEXES ALL;

CRUNSTATS ON TABLE sales AND INDEXES ALL;REORGCHK ON TABLE sales;

DRUNSTATS ON TABLE sales INPLACE AND INDEXES ALL;

Answer : A

Question 4

Which of the following SQL statements will list table spaces whose utilization is greater than 95% and may potentially fill, returning an error?

ASELECT tbsp_name, tbsp_utilization_percentFROM TABLE(sysproc.mon_tbsp_utilization()) AS tWHERE tbsp_utilization_percent > 95AND tbsp_auto_resize_enabled = 1;

BSELECT tbsp_name, tbsp_utilization_percentFROM syscat.mon_tbsp_utilizationWHERE tbsp_utilization_percent > 95AND tbsp_auto_resize_enabled = 0;

CSELECT tbsp_name, tbsp_utilization_percentFROM syscat.mon_tbsp_utilizationWHERE tbsp_utilization_percent > 95AND tbsp_auto_resize_enabled = 1;

DSELECT tbsp_name, tbsp_utilization_percentFROM sysibmadm.mon_tbsp_utilizationWHERE tbsp_utilization_percent > 95AND tbsp_auto_resize_enabled = 0;

Answer : C

Question 5

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

Question 6

Which two tasks must be done to read data directly from IBM Softlayer Object Storage and insert it into a DB2 database? (Choose two.)

ACatalog a storage access alias in the DB2 database

BCreate an FTP account on IBM Softlayer Object Storage

CUse the DB2REMOTE parameter of the LOAD command

DEstablish a remote connection to IBM Softlayer Object Storage using DB2 Connect

ECreate a local disk alias at the database server operating system level that points to IBM Softlayer Object Storage

Answer : A, C

Question 7

The DBA has observed that queries executed against SALES table have poor performance. SALES is a compressed table and recently there have been a lot of rows inserted and modified in that table. The DBA has detected that lower performance may be the result of sub-optimal compression dictionary for that table.

Which of the following commands should be used to resolve the problem without preventing users from changing data in the SALES table

AREORG TABLE sales INPLACE RESETDICTIONARY

BREORG TABLE sales INPLACE REBUILDDICTIONARY

CREORG TABLE sales ALLOW WRITE ACCESS RESETDICTIONARY

DREORG TABLE sales ALLOW WRITE ACCESS REBUILDDICTIONARY

Answer : C

IBM DB2 11.1 DBA for LUW C2090-600 Exam Questions