Exam Code: C2090-311 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2090-311 Exam.
2021 May C2090-311 Study Guide Questions:
Q11. When the DB2_COMPATIBILITY_VECTOR registry variable is set to ORA, what is the maximum row width size for database tables?
A. 32 KB
B. 64 KB
C. 1MB
D. 2 MB
Answer: B
Q12. What is a DB2 Advanced Copy Services (ACS) script used for?
A. To install and configure DB2 Advanced Copy Services.
B. To redirect Tivoli Storage FlashCopy Manager commands to DB2 Advanced Copy Services.
C. To test the functionality of a DB2 ACS API vendor library without performing a snapshot backup or restore operation.
D. To perform snapshot backup and restore operations on storage devices that do not have a DB2 ACS API vendor library.
Answer: D
Q13. What does the monitor element POOL_FAILED_ASYNC_TEMP_COL_REQS track?
A. The number of times an attempt to queue a column-organized prefetch request for temporary table spaces was made but failed.
B. The number of times a temporary error occurred while trying to queue a column-organized prefetch request for a regular table space.
C. The number of times DB2 had to retrieve a page from disk for a temporary column-organized table because the page no longer resided in the buffer pool.
IBM C2090-311 : Practice Test
D. The number of times an asynchronous read request failed when attempting to read temporary column-organized data from the buffer pool after the page had been flushed to disk.
Answer: B
Refresh C2090-311 free practice exam:
Q14. Which monitoring function can be used to determine how many times an SQL statement has referenced a particular column-organized table within a specific period of time?
A. MON_GET_TABLE()
B. MON_GET_TABLESPACE()
C. MON_GET_UNIT_OF_WORK()
D. MON_GET_TABLE_USAGE_LIST()
Answer: A
Q15. Which scenario does NOT require intraquery parallelism?
A. The execution of the LOAD command against an empty column-organized table.
B. A DML operation that references a populated column-organized table.
C. The execution of the RUNSTATS command against a populated column-organized table.
D. The addition of a primary key constraint to an empty column-organized table.
Answer: D
Q16. If the DB2_WORKLOAD registry variable is set to ANALYTICS, what value will be assigned to the DFT_DEGREE database configuration parameter, by default?
A. -1
B. 1
C. ON
D. ANY
Answer: A
Actual C2090-311 guidance:
Q17. Which command, when executed, will enable workload management for column-organized table workloads?
A. db2setDB2_WORKLOAD=ANALYTICS
B. db2set DB2_WLM_DISP_CONCUR=START
C. UPDATE DBM CFG USING WLM_DISPATCHER YES
D. UPDATE DBM CFG USING WORKLOAD TYPE ANALYTICAL
Answer: C
Q18. Which two HADR synchronization modes are supported in DB2 10.5 pureScale environments?
A. SYNC
B. ASYNC
C. NEARSYNC
D. SUPERSYNC
E. SUPERASYNC
Answer: B,C
Q19. Which command would be used to finish a rolling FixPack update to a two member DB2 pureScale cluster?
A. db2iupdt-a
B. db2iupdt-update
C. db2iupdt-commit_level
D. db2iupdt-online_update
Answer: B
Q20. When can a high availability disaster recovery (HADR) role switch operation be performed in a DB2 pureScale environment?
A. When crash recovery is occurring on the standby cluster.
B. When all the log streams are in peer or assisted remote catchup state.
C. When the primary database is not connected to the standby database.
D. All the log streams are in remote catchup state and the synchronization mode is NEARASYNC.
Answer: D