Pass4sure offers free demo for C2090-614 exam. "DB2 10.1 Advanced DBA for Linux UNIX and Windows (C2090-614)", also known as C2090-614 exam, is a IBM Certification. This set of posts, Passing the IBM C2090-614 exam, will help you answer those questions. The C2090-614 Questions & Answers covers all the knowledge points of the real exam. 100% real IBM C2090-614 exams and revised by experts!
♥♥ 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
Q31. What type of file system is used to store data and logs in a DB2 pureScale environment?
A. Network File System (NFS)
B. General Parallel File System (GPFS)
C. Common Internet File System (CIFS)
D. Enhanced Journaled File System (JFS2 or EXT4)
Answer: B
Q32. The following message is frequently seen in the DB2 Diagnostics Log file (db2diag.log): MESSAGE : ADM5502W The escalation of "28581" locks on table "TEST.TABLE1" to lock intent "X" was successful. Which two database configuration parameter settings should be checked? (Choose two.)
A. LOCKLIST
B. MAXAPPLS
C. MAXLOCKS
D. MAXAGENTS
E. LOCKTIMEOUT
Answer: A,C
Q33. 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
Q34. An auxiliary HADR standby database must use which HADR sync mode?
A. SYNC
B. ASYNC
C. NEARSYNC
D. SUPERASYNC
Answer: D
Q35. What statement regarding Asynchronous index cleanup (AIC) is correct?
A. AIC removes all invalid index entries that refer to the attached partitions.
B. AIC is initiated if a range-partitioned table contains one or more nonpartitioned indexes.
C. AIC activates a newly attached partition after the index entries have been synchronized.
D. AIC will not be initiated if a range-partitioned table has dependent materialized query tables (MQTs).
Answer: B
Q36. 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
Q37. If the AUDIT_BUF_SZ configuration parameter is set to zero (0), what will happen?
A. The audit facility writes records to disk at the same time the statements generating the audit records are executing.
B. Statements generating audit records must wait for the records to be written to disk before they can complete execution.
C. The writing of audit records to disk will be delayed until a minimum number of records (based on record size and memory available in the database heap) have been generated.
D. There is no limit to how many audit records can be stored in an internal memory buffer for one single statement generating audit records.
Answer: B
Q38. What is the recommended method for removing old backup images and log files for a DB2 10.1
database?
A. Manually delete old backups and logs.
B. Utilize the PRUNE LOGFILE PRIOR TO command to remove old backups and logs.
C. Utilize the PRUNE HISTORY AND DELETE command to remove old backups and logs.
D. Set the DB2PRUNE_ACTION_LOG configuration parameter to a desired date before generating a new backup.
Answer: C
Q39. Which statement about dropped table recovery is correct?
A. Multiple dropped tables can be recovered with a single table space-level restore operation.
B. By default, the DROPPED TABLE RECOVERY option is off when a new table space is created.
C. The dropped table recovery feature lets you recover only dropped table data with a database-level restore operation.
D. For a dropped table to be recoverable, the table space in which the table resides must have the DROPPED TABLE RECOVERY option turned on.
Answer: D
Q40. 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. By creating a SYSADM ROLE and capturing SYSMAINT event records.
B. By creating an AUDIT POLICY and associating it with SYSADM and DBADM authority.
C. By creating a SYSADM ROLE and capturing SYSADMIN and CHECKING event records.
D. By creating a AUDIT POLICY and associating it with SYSMAINT, SYSADMIN and CHECKING event records.
Answer: B