P2090-018 by IBM Actual Free Exam Q&As

Question 1

Which one of the following options is CORRECT?

A. HADR persists data in the cluster caching facilities (CFs). B. In both DB2 pureScale and HADR environments data is available all the time. C. In a pureScale environment, the data is available all the time, while in a HADR environment the data is available most of the time. D. DB2 pureScale transfers log files from a primary database to a standby database.

Discussion 0

Correct Answer: C Vote an answer

Question 2

What is the DB2 Load utility?

A. The DB2 Load utility is a tool that stores all scripts that are required to create the database. It does not load data, but just loads the database metadata that was exported for a site backup. B. The DB2 Load utility is a tool that allows you to directly transfer data and objects from another database into the one you are currently working with. C. The DB2 Load utility can be used to load and create external functions in a DB2
database. D. The DB2 Load utility is a high-speed, low-level, data loading utility that loads data into a DB2 database.

Discussion 0

Correct Answer: D Vote an answer

Question 3

Which one of the following options is FALSE about DB2's Multi-Temperature Data Storage capability?

A. Multi-temperature data management integrates with DB2's Workload Manager feature to let you prioritize your workloads based on the data being accessed. B. You can use storage groups to implement multi-temperature data management in DB2. C. Multi-temperature data management reduces the total cost of ownership by allowing efficient deployment of storage hardware with minimal administrative overhead. D. Multi-temperature data management best practices recommend that cold data should be stored in faster devices in order to maximize overall system performance.

Discussion 0

Correct Answer: D Vote an answer

Question 4

What are some of the benefits of DB2 Express?

A. DB2 Express is fastest and most powerful DB2 edition. B. DB2 Express is designed for development and testing. It is not used as a production database. C. DB2 Express is a tool that allows DBAs to quickly solve complex database issues. D. DB2 Express has affordable licensing terms with all of the core features of the DB2 engine.

Discussion 0

Correct Answer: D Vote an answer

IBM Information Management DB2 10 Technical Mastery Test v3 - P2090-018 Exam Practice Test