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:
Q1. Which of the following options best defines the Label-Based Access Control (LBAC) feature?
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.
Answer: B
Q2. The following are true about the Configuration Advisor, EXCEPT:
A. It offers recommendations for the initial values of buffer pool size, database configuration parameters, and database manager configuration parameters.
B. It creates database objects such as indexes and MQTs to improve performance.
C. By default, the Configuration Advisor is automatically executed when you create a new database.
D. To use the Configuration Advisor, you can execute the AUTOCONFIGURE command from the DB2 Command Line Processor.
Answer: B
Q3. Which one of the following sentences does NOT describe a benefit of Temporal Tables?
A. Temporal tables increase business insight by letting analysts understand how the business was doing in the past, what has changed in the present, what are the projections for the future.
B. Temporal tables lower costs by eliminating the complexity for businesses to develop their own temporal support infrastructure, such as additional tables, triggers, and application logic.
C. Temporal tables allow better data management by letting the application control data integrity and uniqueness.
D. Temporal tables provide a quick and easy way to track and record data changes in the table.
Answer: C
Updated P2090-018 test:
Q4. Which of the following options does NOT describe a benefit of DB2's Row Compression?
A. Compression allows you to reduce CPU workload because there is less data to process.
B. Compression allows you to retrieve the same amount of data using fewer disk operations (I/O).
C. Compression allows you to cache more data in the buffer pools using the same amount of space.
D. Compression allows you to store the same amount of data in less space, which can significantly save storage costs.
Answer: A
Q5. What is a DB2 instance?
A. A DB2 instance is just another name for DB2 Database.
B. A DB2 instance is a copy of a database that can be accessed standalone from the database server.
C. A DB2 instance is a logical database manager environment where you catalog databases and set configuration parameters.
D. DB2 does not use instances. It requires only databases to operate.
Answer: C
Q6. What are some of the benefits of DB2 Express?
A. DB2 Express has affordable licensing terms with all of the core features of the DB2 engine.
B. DB2 Express is designed for development and testing. It is not used as a production database.
C. DB2 Express is fastest and most powerful DB2 edition.
D. DB2 Express is a tool that allows DBAs to quickly solve complex database issues.
Answer: A
Real P2090-018 training tools:
Q7. 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
Q8. What is a table space in DB2?
A. A table space 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 table space is a DB2 component that manages access to databases.
C. A table space is a space reserved for catalog tables and base table data.
D. A table space is a logical storage grouping that can be composed of one or more containers.
Answer: D
Q9. 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
Q10. Which one of the following options is TRUE about DB2 pureScale?
A. DB2 pureScale feature does not support range-partitioning tables.
B. A DB2 pureScale installation is only supported on AIX platform.
C. DB2 pureScale feature supports multiple interconnects for both members and cluster caching facilities (CFs).
D. DB2 pureScale feature supports multiple interconnects for the cluster caching facilities (CFs).
Answer: D