IBM Information Management DB2 10 Technical Mastery Test v3 認定 P2090-018 試験問題:
1. Which one of the following sentences does NOT describe a benefit of Temporal Tables?
A) Temporal tables allow better data management by letting the application control data integrity and uniqueness.
B) Temporal tables lower costs by eliminating the complexity for businesses to develop their own temporal support infrastructure, such as additional tables, triggers, and application logic.
C) Temporal tables provide a quick and easy way to track and record data changes in the table.
D) Temporal tables increase business insight by letting analysts understand how the business was doing in the past, what has changed in the present, what are the projections for the future.
2. Which one of the following options is CORRECT about DB2 pureScale feature?
A) DB2 pureScale is only available for DB2 Express-C and DB2 Advanced Enterprise Edition.
B) DB2 pureScale persists data in the cluster caching facilities (CFs).
C) DB2 pureScale uses the same concept of HADR where the data is replicated from a primary database to a standby database.
D) DB2 pureScale reduces the risk and cost associated with growing your distributed database solution by providing extreme capacity and application transparency.
3. What is the DB2 Design Advisor?
A) 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.
B) The DB2 Design Advisor is a tool that can be used to automatically create tables based on a physical data diagram.
C) 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.
D) 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.
4. The DB2 Storage Optimization feature allows you to save storage by compressing your database data. Which one of the following types of compression is new in DB2 10?
A) Declared Global Temporary Tables Compression
B) Classic Row Compression
C) Adaptive Compression
D) Temporary Tables Compression
質問と回答：
| 質問 # 1 正解： A | 質問 # 2 正解： D | 質問 # 3 正解： C | 質問 # 4 正解： C |
773 お客様のコメント
品質保証JPexamはIT認定試験のシラバスに従って、試験問題の範囲を正確に絞って、的中率が99％の最新問題集を捧げます。
1年間の無料更新サービスJPexamは1年以内に問題集の無料更新サービスを提供し、お客様がいつでも最新版の問題集を持つことを保証いたします。もし試験の内容が変更されたら、弊社は直ちにお客様にお知らせします。それに、弊社の問題集が更新されたら、早速メールで最新バージョンを送付いたします。
全額返金JPexamの問題集を利用すると、短時間で勉強しても試験に合格できるのを保証いたします。試験に不合格になってしまった場合、弊社は全額返金いたします。(
ご購入前のお試しJPexamは問題集のサンプルを無料で提供いたします。ご購入前にサンプルを試用して製品の品質を確認することができます。ご遠慮なく利用してください。
