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
質問 2:
What does the table partitioning feature in DB2 allow you to do?
A. Table partitioning allows you to make smaller tables automatically from large tables, thereby increasing the performance of your DB2 database.
B. Table partitioning allows you to create result set tables from a join query, which automatically splits the data into smaller chunks, thereby increasing the performance of your DB2 database.
C. Table partitioning allows you to partition the table data based on the hash values of the primary key.
D. Table partitioning allows you to create very large tables that are divided across multiple storage objects so that you can quickly attach and detach large quantities of data from the tables.
正解:D
質問 3:
What are some of the benefits of DB2 Express?
A. DB2 Express is designed for development and testing. It is not used as a production database.
B. DB2 Express has affordable licensing terms with all of the core features of the DB2 engine.
C. DB2 Express is a tool that allows DBAs to quickly solve complex database issues.
D. DB2 Express is fastest and most powerful DB2 edition.
正解:B
質問 4:
What is the DB2 Load utility?
A. The DB2 Load utility can be used to load and create external functions in a DB2
database.
B. The DB2 Load utility is a high-speed, low-level, data loading utility that loads data into a DB2 database.
C. The DB2 Load utility is a tool that allows you to directly transfer data and objects from another database into the one you are currently working with.
D. The DB2 Load utility is a tool that stores all scripts that are required to create the database. It does not load data, but just loads the database metadata that was exported for a site backup.
正解:B