C2090-600 Exam Questions

When the DB2_WORKLOAD registry variable is assigned the value ANALYTICS and then a new database is created, what happens? (Choose two.)

Which tool allows users to connect to a DB2 database using a wizard?

Which DB2 product is a database cluster solution for non-mainframe platforms and is best suited for Online Transaction Processing (OLTP) workloads?

Which two of the following functions of DB2 Workload Manager are restricted by license? (Choose two.)

Which of the following are all valid types of trigger?

The HADR_TARGET_LIST parameter enables HADR to run in multiple standby mode. Which of the following statements are TRUE if HADR is active? (Choose two.)

For any given column-organized user table, the associated synopsis table may contain information for which of the following data types? (Choose two.)

Which phase of the LOAD utility is unique to loading column organized tables?

When choosing the dimensions for an MDC table, poor space utilization can occur due to low cell density. What can cause an MDC table to use much more space?

Which of the following actions do you need to acquire the current encryption settings for a database protected by native encryption?

When querying the MON_GET_TABLESPACE table function, the values for many of the performance metrics like POOL_DATA_P_READS and POOL_DATA_L_READS are showing 0, even though there is...

Which statement about Data Server Manager (DSM) is TRUE?

Which type of compression is NOT provided as part of the DB2 Storage Optimization Feature?

What functionality allows users to perform a UNION operation between a DB2 table and an Oracle view?

What is the result of the following scenario?

On Linux and Unix systems, which of the following will set the DB2_FMP_COMM_HEAPSZ registry variable to 1 GB (or 256000 pages), only for the instance db2inst1?

Which of the following statements about audit policies is TRUE?

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

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

What does dsmtop use to gather metrics?