What is the DB2 Design Advisor?
A. The DB2 Design Advisor is a tool that can help you improve your database workload performance. Given a set of SQL statements in a workload, the Design Advisor can generate recommendations to improve the performance of SQL execution.
B. The DB2 Design Advisor is a tool that automatically analyzes your running database and continuously makes changes to your database to give it peak performance.
C. The DB2 Design Advisor is a help desk facility that is available to all licensed DB2 owners that have paid their maintenance agreements with IBM. The tool is a web site that guides you through the design of your database, with the DBA responding to a series of questions. It produces a database schema that allows for quick database creation.
D. The DB2 Design Advisor is a tool that can be used to automatically create tables based on a physical data diagram.
正解:A
質問 2:
Which one of the following options is correct about the differences between the IMPORT and INGEST utilities?
A. The IMPORT utility is now deprecated and INGEST is the recommended alternative.
B. The INGEST is capable of transforming and streaming data from files and pipes at high speeds into DB2 tables. The IMPORT utility cannot transform the data.
C. The IMPORT utility can import data into a database, while the INGEST can only create database objects based on a script file.
D. The IMPORT utility can perform lightweight transformations on the data being processed. The INGEST utility cannot transform data.
正解:B
質問 3:
Which one of the following options is CORRECT about DB2 pureScale feature?
A. DB2 pureScale persists data in the cluster caching facilities (CFs).
B. DB2 pureScale uses the same concept of HADR where the data is replicated from a primary database to a standby database.
C. DB2 pureScale reduces the risk and cost associated with growing your distributed database solution by providing extreme capacity and application transparency.
D. DB2 pureScale is only available for DB2 Express-C and DB2 Advanced Enterprise Edition.
正解:C
質問 4:
Which one of the following options is CORRECT?
A. DB2 pureScale transfers log files from a primary database to a standby database.
B. In a pureScale environment, the data is available all the time, while in a HADR environment the data is available most of the time.
C. In both DB2 pureScale and HADR environments data is available all the time.
D. HADR persists data in the cluster caching facilities (CFs).
正解:B