A2090-614 Exam Questions

Which monitoring tool can be used to find out how many data pages have been read from the table space containers for regular, large, and temporary table spaces?

What is the FAILARCHPATH database configuration parameter used for?

An auxiliary HADR standby database must use which HADR sync mode?

A table space creation operation was unsuccessful because DB2 failed to allocate a container in a path. Which diagnostic tool can be used to help resolve the problem?

What must you do before an online table space backup operation can be performed?

Which category must be enabled before db2audit will record the creation of new buffer pools?

What event category is used with the db2audit command to capture SQL data, such as host variable and parameter marker values, that are associated with an SQL statement?

A database administrator created all of the necessary federated objects for an SQL Server data source in a federated system. Which steps must be performed if the data types of seve...

What are two supported methods for providing a low latency, high speed interconnect between DB2 members and the cluster caching facility (CF) in a DB2 pureScale environment? (Choos...

On which two operating systems can DB2 pureScale run? (Choose two.)

Which statement about data type mappings is true in a federated system? BrainDumps.com 13 IBM C2090-614 Exam

Which statement about IBM WebSphere Information Integrator Q Replication is correct?

Which table configuration CANNOT utilize multi-temperature storage?

What is the preferred method for reclaiming unused storage in a DMS table space?

If the following statements are executed: CREATE STOGROUP sg_hot ON '/path1', '/path2', '/path3'; CREATE STOGROUP sg_med ON '/path4', '/path5', '/path6'; CREATE TABLESPACE tbsp1 US...

A DB2 9 database named MYDB that does not use automatic storage was migrated to DB2 10.1. When will a default storage group be defined for this database?

The following statement was used to create a table space named USER_TMP in a non- partitioned database: CREATE USER TEMPORARY TABLESPACE user_tmp MANAGED BY SYSTEM USING (?mnt/fsys...

A DBA wants to create a set of tables in a storage group named SG_1, but no table spaces have been assigned to this group. What kind of table spaces must the DBA assign to the stor...

A DBA wants to create a table named SALES that has the following characteristics: ?effective data clustering and management of space utilization ?rows in the table should be cluste...

When using table partitioning, which three operations are valid? (Choose three.)

What are three implementations for DB2 Workload Management? (Choose three.)

What are three authorization categories in DB2? (Choose three.)

What is the purpose of a role?

You want to federate communication between two databases. What are two key requirements? (Choose two.)

What are two services that the cluster caching facility (CF) provides in a DB2 pureScale environment? (Choose two.)

An auditor has requested that all activities performed by those with SYSADM or DBADM authority be tracked. How can this be done with the db2audit tool?

A database administrator needs to create a federated database and configure access to join data from 3 Oracle instances, 2 SQL Server instances, and 1 DB2 database. Which objects a...

Which statement about Q Replication is correct?

Which command will be executed successfully on every database partition if db2_all is used?

When will the existing data for a new partition be visible to applications querying a range- partitioned table?

Given the following CREATE TABLE statement: Which statement is correct?

Which is a poor choice for a clustering dimension of a multidimensional clustering (MDC) table?

Which statement about Range-Clustered Tables (RCTs) is correct?

A table named MYTAB was created as follows: How many rows will be inserted into the MYTAB table?

Which statement about Insert-Time-Clustered (ITC) is correct?

A database named TEST was created and two buffer pools named BP_GENERAL and BP_AUDITING were created as follows: The majority of the database tables were created in table space TS1...

A storage group named MED_SG was created as follows: CREATE STOGROUP med_sg ON ?db2fs1? ?db2fs2? '/db2fs3' Then, a table space named TS1 was created in the storage group and two ta...

A query against the system catalog revealed that data for a table named SALES in a partitioned database is distributed as follows: What can be done to improve the performance of a...

Which would not significantly benefit from having the RUNSTATS command run on it?

Which tool provides the simplest method for monitoring buffer pool hit ratios?

Which is NOT a valid method for prefetching data?

The following query is executed frequently against the EMPLOYEE table: SELECT empid, salary, bonus FROM employee ORDER BY bonus, salary; Which statement will create an index for op...

Which item is NOT eligible for adaptive compression?

Which statement about block indexes is correct?

The following query is executed frequently against the SALES table: SELECT sales_id, sales_date, sales_person FROM sales; If data in the SALES_ID column is unique, which statement...

A database named TEST and a storage group named SG_1 were created with these statements: an error was produced.Why did the error occur?

When defining storage groups for multi-temperature data, storage paths are usually grouped according to their quality of service characteristics. What are three common quality of s...

If the following commands complete successfully for a single partition database: CREATE DATABASE mydb; CREATE BUFFERPOOL mybp; Which statement is true?

You recently added more storage to a table space and a rebalance operation was started automatically. How can you pause the rebalance operation?

The following statement was used to create a table space named TBSP1 in a non-partitioned database: Which statement(s) will successfully lower the high water mark in table space TB...