IBM C2090-600 Exam Practice Test Instant Access

Question 1

Which statement regarding setting up a local keystore for DB2 native encryption is TRUE?

AA local keystore is not needed if a Hardware Security Module (HSM) is used to managemaster keys.

BIf a local keystore is used to store data encryption keys, a stash file must be used to store master keys temporarily.

CA master key must be generated and placed in an existing local keystore before a new encrypted database will be created.

DAfter a local keystore is created, you will be prompted for a password whenever the database manager accesses the keystore.

Answer : C

Question 2

Which statement about NOT ENFORCED unique constraints is TRUE?

ANOT ENFORCED unique constraints can not be defined on primary key columns

BThe query optimizer will consider a NOT ENFORCED unique constraint when selecting an optimal data access plan

CWhen attempting to insert data that does not conform to a NOT ENFORCED unique constraint, awarning will be returned

DStorage requirements for a NOT ENFORCED unique constraint are no different than the storage requirements for a similar unique index

Answer : A

Question 3

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 4

What is an advantage of using range partitioned tables?

AAbilityto run utilities against the partitions in parallel

BIncreased query performance through data partition elimination

CBlock indexes are much smaller than RID indexes, providing better performance

DTable data is automatically and continuously clustered, requiring minimal reorganization

Answer : B

Question 5

Which statement about label-based access control (LBAC) is TRUE?

ALBAC protection can be applied to a nickname

BLBAC cannot be used to restrict access to a staging table

CLBAC cannot be used to restrict access to data of columns and rows in the same table

DLBAC protection for columns requires a table to contain a column that has a DB2SECURITYLABEL data type

Answer : D

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 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

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