C2090-311 - IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 Exam
Go back to IBM
Which type of compression is typically used with column-organized tables?
When can a high availability disaster recovery (HADR) role switch operation be performed in a DB2 pureScale environment?
All the log streams are in remote catchup state and the synchronization mode is NEARASYNC.
Which scenario does NOT require intraquery parallelism?
The addition of a primary key constraint to an empty column-organized table.
How is the Query Workload Tuner license installed and enabled?
With Data Studio, using the license activation kit.
What does the monitor element POOL_FAILED_ASYNC_TEMP_COL_REQS track?
The number of times a temporary error occurred while trying to queue a column-organized prefetch request for a regular table space.
Which command would be used to finish a rolling FixPack update to a two member DB2 pureScale cluster?
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?
An expression-based index named EMPJND1 and a statistical view named EMP_IND1_V have been created for a table named EMPLOYEE. If the following command is used to set up a statistics profile on the statistical view EMP_IND1_V: RUNSTATS ON VIEW emp_ind1_v WITH DISTRIBUTION DEFAULT UM_FREQVALUES 50 SET PROFILE ONLY Which command will create a statistics profile on the EMPLOYEE table?
RUNSTATS ON TABLE employee WITH DISTRIBUTION AND SAMPLED DETAILED INDEXES ALL
What will cause the creation of a column-organized table to fail?
Setting the AUTO_RUNSTATS database configuration parameter to ON.
What is a DB2 Advanced Copy Services (ACS) script used for?
To test the functionality of a DB2 ACS API vendor library without performing a snapshot backup or restore operation.
What type of table can be converted into a column-organized table with the db2convert command?
A range partitioned table
Which statement about expression-based indexes is true?
The index key values of expression-based indexes are not the same as the values in the corresponding table columns.
Which statement regarding NOT ENFORCED unique constraints is true?
NOT ENFORCED unique constraints enforce uniqueness only for primary key columns.
Which statement about Explicit Hierarchical Locking (EHL) for DB2 pureScale is true?
EHL is enabled by default in DB2 10.5 pureScale environments.
What are the correct steps to capture EXPLAIN information for column-organized tables?
1. Set the ENABLE_COLUMN_TABLES registry variable to YES 2. Execute the command CURRENT EXPLAIN MODE YES 3. Issue the query against column-organized tables 4. Execute the db2exfmt command
Which two HADR synchronization modes are supported in DB2 10.5 pureScale environments?
By default, the Optim Workload Table Organization Advisor will recommend converting row- organized tables to column-organized tables if it determines that the change will improve query performance, as a whole, by how much?
Which two sources can be used to provide input to the InfoSphere Optim Query Workload Tuner that generate EXPLAIN information when creating the query workload?
When does space reclamation for a column-organized table normally occur?
Whenever an individual row is deleted.
In which type of database are column-organized tables supported?
If Self Tuning Memory Manager (STMM) is enabled for a DB2 10.5, FixPack 1 pureScale database, which two capabilities are available?
Broadcasting STMM tuning decisions to all members
Single INSTANCE_MEMORY instance configuration memory setting
What happens when the STATISTICS USE PROFILE option is provided with a LOAD command that will be used to populate a column-organized table and a statistics profile does not exist?
A statistics profile is automatically generated before the load is allowed to continue.
What formula can be used to determine the average number of column-organized pages found in each read request?
POOL_COL_READS/ POOL COL READ REQS
If the DB2_WORKLOAD registry variable has not been set which database manager configuration parameter must be modified, before a query that accesses a column-organized table can be executed?
If the DB2_WORKLOAD registry variable is set to ANALYTICS, what value will be assigned to the DFT_DEGREE database configuration parameter, by default?
Which command, when executed, will enable workload management for column-organized table workloads?
UPDATE DBM CFG USING WLM_DISPATCHER YES
Which statement about column-organized tables is true?
Databases with column-organized tables can be federated.
When the DB2_COMPATIBILITY_VECTOR registry variable is set to ORA, what is the maximum row width size for database tables?
Which type of compression is NOT provided as part of the DB2 Storage Optimization Feature?