It is more faster and easier to pass the IBM C2090-614 exam by using Real IBM DB2 10.1 Advanced DBA for Linux UNIX and Windows (C2090-614) questuins and answers. Immediate access to the Avant-garde C2090-614 Exam and find the same core area C2090-614 questions with professionally verified answers, then PASS your exam with a high score now.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for IBM C2090-614 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW C2090-614 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/C2090-614-exam-dumps.html
Q51. 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?
A. db2dart
B. db2diag
C. db2caem
D. db2fmcu
Answer: B
Q52. The following query is executed frequently against the SALES table: SELECT sales_person, region FROM sales WHERE region = 'Quebec' Which statement will create an index for optimal query performance?
A. CREATE INDEX sales_idx ON sales (region)
B. CREATE INDEX sales_idx ON sales (sales_person)
C. CREATE INDEX sales_idx ON sales (region, sales_person)
D. CREATE INDEX sales_idx ON sales (region) INCLUDE (sales_person)
Answer: C
Q53. You recently added more storage to a table space and a rebalance operation was started automatically. How can you pause the rebalance operation?
A. Set the dynamic instance registry variable UTIL_IMPACT_LIM to 0.
B. Set the dynamic instance registry variable UTIL_IMPACT_LIM to 100.
C. Issue a LIST UTILITIES statement with the 'SUSPEND <utility ID>' option specified.
D. Issue an ALTER TABLESPACE statement with the 'REBALANCE SUSPEND' option specified.
Answer: D
Q54. Given the following CREATE TABLE statement: Which statement is correct?
A. A range-clustered table is created and only values from 1 to 1000000 can be stored in the STUDENT_ID column.
B. A range-partitioned table is created and only values from 1 to 1000000 can be stored in the STUDENT_ID column.
C. A range-clustered table is created and values outside the range of 1 to 1000000 can be stored in the STUDENT_ID column.
D. A range-partitioned table is created and values outside the range of 1 to 1000000 can be stored in the STUDENT_ID column.
Answer: C
Q55. Which statement about IBM WebSphere Information Integrator Q Replication is correct?
A. It reads the DB2 recovery log and stores committed transactional data in staging tables.
B. It reads the DB2 recovery log and converts committed transactional data to SQL statements.
C. It provides the lowest latency of data in the target databases and lowest throughput of changed data to the target databases.
D. It provides the lowest latency of data in the target databases and highest throughput of changed data to the target databases.
Answer: D
Q56. Which statement about DB2 Merge Backup is FALSE?
A. It can be used to merge offline backups to build full offline table space backups.
B. It can be used to merge SNAPSHOT and TSM tape backup images to create a full database backup image.
C. It can be used merge multiple offline database backups to build a cumulative single offline database backup.
D. It can be used to merge backups on a machine that is different from the machine where the backup has been created in stand-alone mode.
Answer: B
Q57. If the following commands complete successfully for a single partition database: CREATE DATABASE mydb; CREATE BUFFERPOOL mybp; Which statement is true?
A. Self tuning is enabled for the MYBP buffer pool.
B. The initial size for the MYBP buffer pool is zero pages.
C. The database has to be restarted before the MYBP buffer pool will become active.
D. The page size for the MYBP buffer pool can be changed using the ALTER BUFFERPOOL statement.
Answer: A
Q58. 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 query that joins SALES and DATE_DIM tables (where SALES is a fact table and DATE_DIM is a dimension table) using the DATE_ID column?
A. Reload table SALES and use only one partition with a collocated join to the DATE_DIM table using the primary key DATE_ID.
B. Reload table DATE_DIM and use only one partition with a collocated join to the SALES table using the primary key DATE_ID.
C. Create a replicated table REPL_SALES from the SALES table, refresh REPL_SALES table, create index on DATE_ID column in theREPL_SALES table, and collect statistics on REPL_SALES table.
D. Create a replicated table REPL_DATE_DIM from the DATE_DIM table, refresh REPL_DATE_DIM table, create index on DATE_ID column in theREPL_DATE_DIM table, and collect statistics on REPL_DATE_DIM table.
Answer: D
Q59. An auxiliary HADR standby database must use which HADR sync mode?
A. SYNC
B. ASYNC
C. NEARSYNC
D. SUPERASYNC
Answer: D
Q60. Which category must be enabled before db2audit will record the creation of new buffer pools?
A. OBJMAINT
B. SECMAINT
C. CHECKING
D. OBJCREATE
Answer: A