IBM P2090-018 - IBM Information Management DB2 10 Technical Mastery Test v3 Exam
Page: 2 / 7
Total 35 questions
Question #6 (Topic: )
What is the purpose of the Self Tuning Memory Manager (STMM) in DB2?
A. 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.
B. 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.
C. 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.
D. STMM allows DBAs to inspect the current memory allocation by buffer pools.
Answer: A
Question #7 (Topic: )
Which one of the following statements is TRUE about DB2 Workload Management (WLM)?
A. DB2 Workload Management requires several application changes in order to make the application aware of the WLM feature.
B. DB2 Workload Management guarantees the availability of data by replicating it to a stand-by server.
C. DB2 Workload Management can be used to schedule maintenance tasks such as BACKUPs, REORGs, or RUSTATS.
D. DB2 Workload Management allows you to assign resources to different workloads, which leads to a stable and predictable execution environment.
Answer: D
Question #8 (Topic: )
Which one of the following options is FALSE about DB2's Multi-Temperature Data Storage
capability?
capability?
A. You can use storage groups to implement multi-temperature data management in DB2.
B. Multi-temperature data management reduces the total cost of ownership by allowing efficient deployment of storage hardware with minimal administrative overhead.
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.
Answer: D
Question #9 (Topic: )
Which one of the following options contains a benefit of the Java Generic Table Functions?
A. Java Generic Table Functions allow you to specify the output of a table function when you create it, rather than when you reference it.
B. Java Generic Table Functions allow you to specify the output of a table function when you reference it, rather than when you create it.
C. Java Generic Table Functions must run on a separate server, thus they don't consume DB2 resources.
D. Java Generic Table Functions can be implemented in any programming language.
Answer: B
Question #10 (Topic: )
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 uses the same concept of HADR where the data is replicated from a primary database to a standby database.
C. DB2 pureScale persists data in the cluster caching facilities (CFs).
D. DB2 pureScale reduces the risk and cost associated with growing your distributed database solution by providing extreme capacity and application transparency.
Answer: D
