Exam Code: P2090-018 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: IBM Information Management DB2 10 Technical Mastery Test v3 (P2090-018)
Certification Provider: IBM
Free Today! Guaranteed Training- Pass P2090-018 Exam.
2021 May P2090-018 Study Guide Questions:
Q11. What is a buffer pool in DB2?
A. 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.
B. A buffer pool is a DB2 component that manages connections to databases.
C. A buffer pool is a pool of connection buffers that increases performance of applications connecting to the DB2 server.
D. A buffer pool is a logical storage grouping composed of one or more containers.
Answer: A
Q12. Which one of the following options is CORRECT about Temporal Tables?
A. Temporal tables are complex to maintain and require major application changes.
B. Temporal tables require constant changes to the operating system timestamp in order to navigate through time in the database.
C. Temporal tables are used to model data in the past and present. They cannot be used to model data in the future.
D. Temporal tables are used to model data in the past, present, and future.
Answer: D
Q13. How can you verify that a DB2 installation was successful?
A. Verification is performed by running the VERIFY INSTALL command.
B. Verification is completed by the DBA using the database verification toolkit.
C. Verification is automatically performed by the AUTO_CONFIGURE feature.
D. Verification can be done by successfully creating a SAMPLE database and running SQL commands to retrieve sample data.
Answer: D
Renew P2090-018 free exam:
Q14. The DB2 Storage Optimization feature allows you to save storage by compressing your database data. Which one of the following types of compression is new in DB2 10?
A. Temporary Tables Compression
B. Declared Global Temporary Tables Compression
C. Adaptive Compression
D. Classic Row Compression
Answer: C
Q15. 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
Q16. Which one of the following options is CORRECT about Temporal Tables?
A. System-period temporal tables are used to keep historical versions of records in a table. They use a history table to transparently store updated and deleted data rows.
B. Application-period temporal tables are used to keep historical versions of records in a table. They use a history table to transparently store updated and deleted data rows.
C. System-period temporal tables combine the historical tracking of an Application-period temporal table with the time-specific data storage capabilities of a bitemporal table. They are used to keep user-based period information as well as system-based historical information.
D. Application-period temporal tables combine the historical tracking of a system-period temporal table with the time-specific data storage capabilities of a bitemporal table. They are used to keep user-based period information as well as system-based historical information.
Answer: A
Pinpoint P2090-018 lab:
Q17. What is the DB2 Design Advisor?
A. The DB2 Design Advisor is a tool that automatically analyzes your running database and continuously makes changes to your database to give it peak performance.
B. The DB2 Design Advisor is a help desk facility that is available to all licensed DB2 owners that have paid their maintenance agreements with IBM. The tool is a web site that guides you through the design of your database, with the DBA responding to a series of questions. It produces a database schema that allows for quick database creation.
C. The DB2 Design Advisor is a tool that can help you improve your database workload performance. Given a set of SQL statements in a workload, the Design Advisor can generate recommendations to improve the performance of SQL execution.
D. The DB2 Design Advisor is a tool that can be used to automatically create tables based on a physical data diagram.
Answer: C
Q18. Which of the following questions is FALSE about DB2 Audit facility?
A. The DB2 Audit facility helps monitor data access to protect against unknown or unwanted behavior.
B. The DB2 Audit facility logs configuration changes made by STMM.
C. The DB2 Audit facility helps you comply with business regulation or legal rules requiring companies to keep historical records of database activities.
D. The DB2 Audit facility allows you to export audit data into a table format for easy reporting.
Answer: B
Q19. 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. Table data is protected against direct access to the table. Access using views is unrestricted.
C. In order to take advantage of this feature, applications must be changed to work with the RCAC feature.
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.
Answer: D
Q20. With respect to DB2 security, what is authorization?
A. Authorization is a process that checks whether you have sufficient privileges to perform the desired database operation.
B. Authorization is the process where the DBA gathers information to see who will have access to the database.
C. Authorization is the process where the DB2 database checks with Windows security to see if you have access to the DB2 database.
D. Authorization is a process that validates that you are who you claim to be by verifying your user ID and password.
Answer: A