IBM Information Management DB2 10 Technical Mastery Test v3 認定 P2090-018 試験問題:
1. Which of the following options is TRUE about the Row and Column Access Control (RCAC) feature?
A) Users with DATAACCESS authority are exempt from the Row and Column Access Control rules.
B) Row and column level access control allows the creation of column masks that can control what column values a user is permitted to see.
C) In order to take advantage of this feature, applications must be changed to work with the RCAC feature.
D) Table data is protected against direct access to the table. Access using views is unrestricted.
2. 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.
3. 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 retrieve the same amount of data using fewer disk operations (I/O).
C) Compression allows you to cache more data in the buffer pools using the same amount of space.
D) Compression allows you to reduce CPU workload because there is less data to process.
4. What is a buffer pool in DB2?
A) A buffer pool is a DB2 component that manages connections to databases.
B) A buffer pool is a logical storage grouping composed of one or more containers.
C) A buffer pool is an area of main memory that has been allocated by the database manager for the purpose of caching table and index data as it is read from the physical media.
D) A buffer pool is a pool of connection buffers that increases performance of applications connecting to the DB2 server.
質問と回答：
| 質問 # 1 正解： B | 質問 # 2 正解： D | 質問 # 3 正解： D | 質問 # 4 正解： C |
892 お客様のコメント
品質保証JPexamはIT認定試験のシラバスに従って、試験問題の範囲を正確に絞って、的中率が99％の最新問題集を捧げます。
1年間の無料更新サービスJPexamは1年以内に問題集の無料更新サービスを提供し、お客様がいつでも最新版の問題集を持つことを保証いたします。もし試験の内容が変更されたら、弊社は直ちにお客様にお知らせします。それに、弊社の問題集が更新されたら、早速メールで最新バージョンを送付いたします。
全額返金JPexamの問題集を利用すると、短時間で勉強しても試験に合格できるのを保証いたします。試験に不合格になってしまった場合、弊社は全額返金いたします。(
ご購入前のお試しJPexamは問題集のサンプルを無料で提供いたします。ご購入前にサンプルを試用して製品の品質を確認することができます。ご遠慮なく利用してください。
