최신 DB2 C2090-544 무료샘플문제:

1. If instance DB2INST1 is created and its authentication type is set to KRB_SERVER_ENCRYPT, which statement is true?

A) Client connections to databases on DB2INST1 will fail unless they are attempted through an LDAP connection.
B) Databases created in DB2INST1 will use SERVER_ENCRYPT authentication if KERBEROS authentication is not available.
C) Databases created in DB2INST1 will use KERBEROS authentication if SERVER_ENCRYPT authentication is not available.
D) Client connections from Windows machines to databases on DB2INST1 will flow clear text passwords.

2. A DBA has established connectivity to a DB2 for z/OS database and is exploiting a System z sysplex for load balancing and fault-tolerance. Which series of statements and commands can be issued to ensure that agents remain allocated to help maintain the sysplex server list?

A) UPDATE DBM CFG USING NUM_POOLAGENTS 0;
db2stop;
db2start;
B) UPDATE DBM CFG USING NUM_POOLAGENTS 200;
db2stop;
db2start;
C) UPDATE DBM CFG USING NUM_INITAGENTS 0;
db2stop;
db2start;
D) UPDATE DBM CFG USING NUM_INITAGENTS 200;
db2stop;
db2start;

3. If table space TBSP1 is using automatic storage, and the existing storage paths are full, which command would increase the available storage?

A) ALTER DATABASE ADD STORAGE ON '/db2/filesystem1'
B) ALTER TABLESPACE tbsp1 ADD ('/db2/filesystem1')
C) ALTER DATABASE ADD STORAGE FOR tbsp1 ('/db2/filesystem1')
D) ALTER TABLESPACE tbsp1 EXTEND USING ('/db2/filesystem1')

4. When the DBA chooses the dimensions for a multi-dimensional clustering (MDC) table, which two characteristics should be considered? (Choose two.)

A) extent size
B) numeric data versus character data
C) prefetch size
D) the combined cardinality of the candidate columns
E) the query transaction rate

5. Which command would be used to obtain the name of the first active log file for a database with log retain enabled?

A) GET CURRENT ACTIVE LOGFILE
B) GET DATABASE CONFIGURATION
C) LIST LOGFILES
D) LIST INDOUBT TRANSACTIONS

질문과 대답: