A2090-614 Exam Questions
109 real A2090-614 exam questions with expert-verified answers and explanations. Page 1 of 3.
- Question #1
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?
- Question #2
What is the FAILARCHPATH database configuration parameter used for?
- Question #3
An auxiliary HADR standby database must use which HADR sync mode?
- Question #4
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?
- Question #5
What must you do before an online table space backup operation can be performed?
- Question #6
Which category must be enabled before db2audit will record the creation of new buffer pools?
- Question #7
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?
- Question #8
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...
- Question #10
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...
- Question #11
On which two operating systems can DB2 pureScale run? (Choose two.)
- Question #12
Which statement about data type mappings is true in a federated system? BrainDumps.com 13 IBM C2090-614 Exam
- Question #13
Which statement about IBM WebSphere Information Integrator Q Replication is correct?
- Question #14
Which table configuration CANNOT utilize multi-temperature storage?
- Question #15
What is the preferred method for reclaiming unused storage in a DMS table space?
- Question #16
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...
- Question #17
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?
- Question #18
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...
- Question #19
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...
- Question #20
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...
- Question #21
When using table partitioning, which three operations are valid? (Choose three.)
- Question #22
What are three implementations for DB2 Workload Management? (Choose three.)
- Question #23
What are three authorization categories in DB2? (Choose three.)
- Question #24
What is the purpose of a role?
- Question #25
You want to federate communication between two databases. What are two key requirements? (Choose two.)
- Question #27
What are two services that the cluster caching facility (CF) provides in a DB2 pureScale environment? (Choose two.)
- Question #28
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?
- Question #29
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...
- Question #30
Which statement about Q Replication is correct?
- Question #31
Which command will be executed successfully on every database partition if db2_all is used?
- Question #32
When will the existing data for a new partition be visible to applications querying a range- partitioned table?
- Question #33
Given the following CREATE TABLE statement: Which statement is correct?
- Question #34
Which is a poor choice for a clustering dimension of a multidimensional clustering (MDC) table?
- Question #35
Which statement about Range-Clustered Tables (RCTs) is correct?
- Question #36
A table named MYTAB was created as follows: How many rows will be inserted into the MYTAB table?
- Question #37
Which statement about Insert-Time-Clustered (ITC) is correct?
- Question #38
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...
- Question #39
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...
- Question #40
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...
- Question #42
Which would not significantly benefit from having the RUNSTATS command run on it?
- Question #43
Which tool provides the simplest method for monitoring buffer pool hit ratios?
- Question #44
Which is NOT a valid method for prefetching data?
- Question #45
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...
- Question #46
Which item is NOT eligible for adaptive compression?
- Question #47
Which statement about block indexes is correct?
- Question #48
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...
- Question #49
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?
- Question #50
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...
- Question #51
If the following commands complete successfully for a single partition database: CREATE DATABASE mydb; CREATE BUFFERPOOL mybp; Which statement is true?
- Question #52
You recently added more storage to a table space and a rebalance operation was started automatically. How can you pause the rebalance operation?
- Question #53
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...