Testking C2090-614 Questions are updated and all C2090-614 answers are verified by experts. Once you have completely prepared with our C2090-614 exam prep kits you will be ready for the real C2090-614 exam without a problem. We have Renovate IBM C2090-614 dumps study guide. PASSED C2090-614 First attempt! Here What I Did.


♥♥ 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

Q1. Consider the following statement: 

Which indexes should be created for optimal query performance? 

A. CREATE INDEX emp_idx ON employee (workdept); CREATE INDEX dept_idx ON department (deptno); 

B. CREATE INDEX emp_idx ON employee (workdept) CLUSTER; CREATE INDEX dept_idx ON department (deptname, deptno); 

C. CREATE INDEX emp_idx ON employee (workdept, lastname, job); CREATE INDEX dept_idx ON department (deptname, deptno); 

D. CREATE INDEX emp_idx ON employee (lastname, job, workdept) CLUSTER; CREATE INDEX dept_idx ON department (deptname); 

Answer: C 


Q2. Which command(s) should be used to drop database partition 10 from a database named MYDB? 

A. STOP DBM DROP DBPARTITIONNUM 10; DROP DBPARTITIONNUM VERIFY; 

B. DROP DBPARTITIONNUM VERIFY; STOP DBM DROP DBPARTITIONNUM 10; 

C. CONNECT TO mydb; DROP DBPARTITIONNUM 10; CONNECT RESET; 

D. CONNECT TO mydb; DROP DBPARTITIONNUM 10; ACTIVATE DB mydb; 

Answer: B 


Q3. 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 


Q4. 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 


Q5. Which item is NOT eligible for adaptive compression? 

A. Indexes 

B. Base tables 

C. Temporary tables 

D. Inline LOB values 

Answer: C 


Q6. To configure instance-level auditing with db2audit, which authority is required? 

A. SYSADM 

B. SYSCTRL 

C. SECADM 

D. SYSMAINT 

Answer: A 


Q7. Which constraints are used to tell the DB2 Optimizer to consider business rules that are not enforced by the database manager? 

A. Check constraints 

B. Default constraints 

C. Informational constraints 

D. Referential integrity constraints 

Answer: C 


Q8. A DBA wants to create a table named SALES that has the following characteristics: 

-Data for the first half of the year will reside in table space TBSP1; the index for this data will reside in table space TBSP21. -Data for the second half of the year will reside in table space TBSP2; the index for this data will reside in table space TBSP22. 

Which clause must be used with the CREATE TABLE statement to define this table? 

A. DISTRIBUTE BY HASH 

B. PARTITION BY RANGE 

C. ORGANIZE BY DIMENSIONS 

D. ORGANIZE BY KEY SEQUENCE 

Answer: B 


Q9. In which situation would you NOT use a redirected restore? 

A. To redefine the paths of a defined storage group. 

B. To move table space containers onto different physical devices. 

C. To restore a backup image from one operating system to another. 

D. To restore a backup image to a target machine that is different from the source machine. 

Answer: C 


Q10. Which is NOT a valid method for prefetching data? 

A. Smart data prefetching 

B. Read-ahead prefetching 

C. Consecutive prefetching 

D. Sequential detection prefetching 

Answer: C