Which one of the following statements is FALSE about DB2 Workload Management (WLM)?
A. When a WLM threshold condition is violated an action is executed in order to maintain stability in the system.
B. DB2 Workload Management uses workloads to identify incoming work based on the connection attributes under which the work is submitted.
C. DB2 Workload Management dispatcher can be used to control sharing of memory resources among active workloads.
D. DB2 Workload Management allows dynamic re-prioritization of work by remapping a workload to a different service class.
Which one of the following options is CORRECT?
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.
Which of the following options best describes the differences between Label Based Access Control (LBAC) and Row and Column Access Control (RCAC)?
A. RCAC is a fixed label security model designed for the US government while LBAC is a general purpose security model best suited for commercial customers.
B. RCAC returns the data based on what is being asked (data centric), while LBAC returns data based on who is asking what (user centric). Users with DATAACCESS authority are exempt from the Row and Column Access Control rules.
C. LBAC allows you to protect access only to rows, while RCAC allows you to protect both rows and columns.
D. With RCAC users do not get an error when accessing protected data, while with LBAC users can get an error if they don't have the necessary credentials to access a LBAC protected column.
Which one of the following options is FALSE?
A. WLM is not supported in DB2 pureScale environments.
B. HADR with multiple standbys supports reads on all standby databases.
C. Implementation of a row and column access control policy is transparent to applications accessing the database.
D. The INGEST utility is capable of transforming and loading data from files and pipes at high speeds into DB2 tables.
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.
Which one of the following statements is TRUE about DB2 Workload Management (WLM)?
A. DB2 Workload Management requires several application changes in order to make the application aware of the WLM feature.
B. DB2 Workload Management guarantees the availability of data by replicating it to a stand-by server.
C. DB2 Workload Management can be used to schedule maintenance tasks such as BACKUPs, REORGs, or RUSTATS.
D. DB2 Workload Management allows you to assign resources to different workloads, which leads to a stable and predictable execution environment.
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.
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.
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.
Which DB2 licensing type is based on the number of users allowed to access the data server?
A. PVU (Processor Value Unit) licensing
B. Sub-capacity licensing
C. Authorized User (AU) licensing
D. Per Server licensing
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only IBM exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your P2090-054 exam preparations and IBM certification application, do not hesitate to visit our Vcedump.com to find your solutions here.