IBM Information Management DB2 10 Technical Mastery Test v3 認定 P2090-018 試験問題:
1. Which one of the following options is FALSE about DB2's Multi-Temperature Data Storage capability?
A) Multi-temperature data management reduces the total cost of ownership by allowing efficient deployment of storage hardware with minimal administrative overhead.
B) You can use storage groups to implement multi-temperature data management in DB2.
C) Multi-temperature data management integrates with DB2's Workload Manager feature to let you prioritize your workloads based on the data being accessed.
D) Multi-temperature data management best practices recommend that cold data should be stored in faster devices in order to maximize overall system performance.
2. DB2's High Availability and Disaster Recovery (HADR) feature provides a high availability solution for both partial and complete site failures. Given the sentences below, select the CORRECT statement about HADR.
A) HADR protects against data loss by saving data changes from a source database into a local recovery log file.
B) HADR protects against data loss by replicating data changes from a backup database file to a standby database.
C) HADR protects against data loss by replicating data changes from a source database, called the primary, to a target database, called the standby.
D) HADR feature is only available for DB2 Advanced Enterprise Edition.
3. What is the purpose of the Self Tuning Memory Manager (STMM) in DB2?
A) This feature detects memory expansion in the database and delivers a warning to the DBA to let them know when the database is nearing a threshold memory allocation limit.
B) This feature reduces the task of configuring your DB2 server by continuously updating memory configuration parameters, resizing buffer pools, and dynamically determining the total amount of memory to be used by the database.
C) STMM allows DBAs to inspect the current memory allocation by buffer pools.
D) The purpose of this feature is for the system to deliver to you a report of database tuning recommendations so that you can update the configuration parameters by hand.
4. The following are true about the Configuration Advisor, EXCEPT:
A) By default, the Configuration Advisor is automatically executed when you create a new database.
B) It creates database objects such as indexes and MQTs to improve performance.
C) To use the Configuration Advisor, you can execute the AUTOCONFIGURE command from the DB2 Command Line Processor.
D) It offers recommendations for the initial values of buffer pool size, database configuration parameters, and database manager configuration parameters.
質問と回答：
| 質問 # 1 正解： D | 質問 # 2 正解： C | 質問 # 3 正解： B | 質問 # 4 正解： B |
595 お客様のコメント
品質保証JPexamはIT認定試験のシラバスに従って、試験問題の範囲を正確に絞って、的中率が99％の最新問題集を捧げます。
1年間の無料更新サービスJPexamは1年以内に問題集の無料更新サービスを提供し、お客様がいつでも最新版の問題集を持つことを保証いたします。もし試験の内容が変更されたら、弊社は直ちにお客様にお知らせします。それに、弊社の問題集が更新されたら、早速メールで最新バージョンを送付いたします。
全額返金JPexamの問題集を利用すると、短時間で勉強しても試験に合格できるのを保証いたします。試験に不合格になってしまった場合、弊社は全額返金いたします。(
ご購入前のお試しJPexamは問題集のサンプルを無料で提供いたします。ご購入前にサンプルを試用して製品の品質を確認することができます。ご遠慮なく利用してください。
