최신 IBM Information Management C2090-548 무료샘플문제:

1. Which of the following options does NOT describe a benefit of DB2's Row Compression?

A) Compression allows you to store the same amount of data in less space, which can significantly save storage costs.
B) Compression allows you to reduce CPU workload because there is less data to process.
C) Compression allows you to cache more data in the buffer pools using the same amount of space.
D) Compression allows you to retrieve the same amount of data using fewer disk operations (I/O).

2. Which statement about the use of Database Image Copy 2 (IC2) is FALSE?

A) The databases copied by IC2 must be registered to DBRC.
B) The database being copied by IC2 cannot be HISAM.
C) The control statements used for IC2 are the same as those for Batch Image Copy.
D) The database being copied by IC2 cannot be an Index database.

3. What is a DB2 instance?

A) DB2 does not use instances. It requires only databases to operate.
B) A DB2 instance is just another name for DB2 Database.
C) A DB2 instance is a copy of a database that can be accessed standalone from the database server.
D) A DB2 instance is a logical database manager environment where you catalog databases and set configuration parameters.

4. What is the DB2 design advisor?

A) DB2 has no design advisor tool.
B) The DB2 design advisor is a tool that can help you improve your workload performance. Thetool asks you questions about your workload and other options it should take into account, and then recommends performance changes to your database.
C) The DB2 design advisor is a tool that automatically analyzes your running database andcontinuously makes changes to your database, so that the database is running at peakperformance.
D) The DB2 design advisor is a help desk facility that is available to all licensed DB2 owners thathave paid their maintenance agreements with IBM. The tool is a Web site that guides youthrough the design of your database, with the DBA responding to a series of questions. Itproduces a database schema that allows for quick database creation.

5. Which one of the following options is CORRECT about Temporal Tables?

A) Application-period temporal tables combine the historical tracking of a system-period temporal table with the time-specific data storage capabilities of a bitemporal table. They are used to keep user-based period information as well as system-based historical information.
B) Application-period temporal tables are used to keep historical versions of records in a table. They use a history table to transparently store updated and deleted data rows.
C) System-period temporal tables are used to keep historical versions of records in a table. They use a history table to transparently store updated and deleted data rows.
D) System-period temporal tables combine the historical tracking of an Application-period temporal table with the time-specific data storage capabilities of a bitemporal table. They are used to keep user-based period information as well as system-based historical information.

질문과 대답: