IBM P2090-018 Actual Free Exam Questions & Community Discussion

Exam Code/Number: P2090-018
Exam Name/Title: IBM Information Management DB2 10 Technical Mastery Test v3
Certification Provider: IBM
Corresponding Certification: IBM Mastery

Exam Questions: 35
Updated On: May 26, 2026

Question #9

Which of the following options is TRUE about the Row and Column Access Control (RCAC) feature?

A. In order to take advantage of this feature, applications must be changed to work with the RCAC feature.

B. Users with DATAACCESS authority are exempt from the Row and Column Access Control rules.

C. Table data is protected against direct access to the table. Access using views is unrestricted.

D. Row and column level access control allows the creation of column masks that can control what column values a user is permitted to see.

Discussion 0

Correct Answer: D Vote an answer

Question #10

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

A. 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.

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

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

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

Discussion 0

Correct Answer: A Vote an answer

Question #11

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

A. You can use storage groups to implement multi-temperature data management in DB2.

B. Multi-temperature data management best practices recommend that cold data should be stored in faster devices in order to maximize overall system performance.

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 integrates with DB2's Workload Manager feature to let you prioritize your workloads based on the data being accessed.

Discussion 0

Correct Answer: B Vote an answer

Question #12

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 feature is only available for DB2 Advanced Enterprise Edition.

B. HADR protects against data loss by saving data changes from a source database into a local recovery log file.

C. HADR protects against data loss by replicating data changes from a backup database file to a standby database.

D. HADR protects against data loss by replicating data changes from a source database, called the primary, to a target database, called the standby.

Discussion 0

Correct Answer: D Vote an answer

Download Free IBM P2090-018 Demo

Simply submit your e-mail address below to get started with our free demo of your IBM P2090-018 exam.