Exam Code: C2090-611 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: DB2 10.1 DBA for Linux, UNIX, and Windows
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2090-611 Exam.


♥♥ 2021 NEW RECOMMEND ♥♥

Free VCE & PDF File for IBM C2090-611 Real Exam (Full Version!)

★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions

Free Instant Download NEW C2090-611 Exam Dumps (PDF & VCE):
Available on: http://www.surepassexam.com/C2090-611-exam-dumps.html

Q11. What authority must be held to create a trusted context?

A. DBADM

B. SQLADM

C. SECADM

D. CONNECT

Answer: C


Q12. What must a user possess if they want to run a DB2 Command Line Processor (CLP) script against a database using the Job Manager in IBM Data Studio?

A. Permission to log in to the database client using telnet.

B. Permission to log in to the database server using telnet.

C. Permission to log in to the database client using secure shell (SSH).

D. Permission to log in to the database server using secure shell (SSH).

Answer: D


Q13. Which data movement utility is suitable for moving and processing large amounts of real-time data without affecting availability?

A. INGEST

B. REPLICATION

C. LOAD WITH READ ACCESS

D. IMPORT WITH BUFFERED INSERT

Answer: A


Q14. Which statement about adaptive compression is true?

A. When you enable adaptive compression for a table, you enable it for the entire table, even if the table contains more than one partition.

B. You can specify that tables be compressed by using either a table-level dictionary only, pagelevel dictionaries only, or both table-level andpage-level dictionaries.

C. Adaptive compression can only be used to compress base tables, partitioned tables, and temporary tables; MQTs, typed tables and stagingtables cannot be compressed.

D. Adaptive compression uses a page-level dictionary-based compression algorithm to compress data based on repeating patterns found within asampling of data from one extent.

Answer: A


Q15. If a single node database is actively being used by applications when a power failure occurs, what method is used to bring the database back to a consistent state once power has been restored?

A. Crash recovery

B. Version recovery

C. Disaster recovery

D. Roll-forward recovery

Answer: A


Q16. Which statement regarding compression for temporary tables is true?

A. Temporary tables can only be compressed using adaptive compression.

B. Temporary tables can only be compressed using classic row compression.

C. Compression for temporary tables can be dynamically enabled and disabled.

D. The DB2 optimizer automatically decides to use classic row compression or adaptive compression for temporary tables.

Answer: B


Q17. What is the purpose of specifying the RESTART CONTINUE option in an INGEST command?

A. To terminate a failed INGEST command.

B. To restart a failed INGEST command from the beginning.

C. To clean up the log records of a failed INGEST command.

D. To restart a failed INGEST command from the last commit point.

Answer: D


Q18. Which registry variable should be used to specify that 20 percent of each index page is to be left as as free space when building any index in any database?

A. DB2_INDEX_DEFAULT

B. DB2_EXTENDED_OPTIMIZATION

C. DB2_INDEX_PCTFREE_DEFAULT

D. DB2_ENABLE_AUTOCONFIG_DEFAULT

Answer: C


Q19. What are two types of check options that can be used to create views? (Choose two.)

A. Local

B. Client

C. Server

D. Remote

E. Cascaded

Answer: A,E


Q20. Which command is used to export connectivity configuration information from a file known as a configuration profile?

A. db2ca

B. db2cfexp

C. db2cfimp

D. db2cfgexp

Answer: B