Summer Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Note! Following P2090-018 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

Verified By IT Certified Experts

CertsTopics.com Certified Safe Files

Up-To-Date Exam Study Material

99.5% High Success Pass Rate

100% Accurate Answers

Instant Downloads

Exam Questions And Answers PDF

Try Demo Before You Buy

Certification Exams with Helpful Questions And Answers

IBM Information Management DB2 10 Technical Mastery Test v3 Questions and Answers

Question 1

Which one of the following options is CORRECT?

Options:

A.

In both DB2 pureScale and HADR environments data is available all the time.

B.

DB2 pureScale transfers log files from a primary database to a standby database.

C.

HADR persists data in the cluster caching facilities (CFs).

D.

In a pureScale environment, the data is available all the time, while in a HADR environment the data is available most of the time.

Buy Now
Question 2

Which of the following options best defines the Label-Based Access Control (LBAC) feature?

Options:

A.

DB2 LBAC allows you to use labels to reference database objects by a short name instead of the full qualified name.

B.

DB2 LBAC lets you decide exactly who has write/read access to individual rows and columns by comparing the security labels between database objects and users.

C.

DB2 LBAC monitors table data access and tables modifications made by database users.

D.

DB2 LBAC is the DB2 authority in charge of issuing GRANT and REVOKE statements.

Question 3

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

Options:

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.