Do not worry about your IBM Information Management P2090-018 exam preparation? Hand over your problems to CertBus in change of the IBM Information Management P2090-018 IBM Information Management DB2 10 Technical Mastery Test v3 certifications! CertBus provides the latest IBM IBM Information Management P2090-018 exam preparation materials with PDF and VCEs. We CertBus guarantees you passing IBM Information Management P2090-018 exam for sure.
We CertBus has our own expert team. They selected and published the latest P2090-018 preparation materials from IBM Official Exam-Center: http://www.certgod.com/P2090-018.html
QUESTION NO: 2
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
QUESTION NO: 3
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
2
QUESTION NO: 13
What is the DB2 Load utility?
A. The DB2 Load utility is a tool that stores all scripts that are required to create the database. It
does not load data, but just loads the database metadata that was exported for a site backup.
B. The DB2 Load utility is a tool that allows you to directly transfer data and objects from another
database into the one you are currently working with.
C. The DB2 Load utility is a high-speed, low-level, data loading utility that loads data into a DB2
database.
D. The DB2 Load utility can be used to load and create external functions in a DB2 database.
Answer: C
QUESTION NO: 6
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.
3
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
QUESTION NO: 11
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.
5
Answer: B
QUESTION NO: 1
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
QUESTION NO: 7
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 protects against data loss by saving data changes from a source database into a local
recovery log file.
B. HADR protects against data loss by replicating data changes from a backup database file to a
standby database.
C. HADR protects against data loss by replicating data changes from a source database, called
the primary, to a target database, called the standby.
D. HADR feature is only available for DB2 Advanced Enterprise Edition.
Answer: C
QUESTION NO: 4
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 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.
Answer: D
QUESTION NO: 8
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.
4
Answer: C
QUESTION NO: 9
Which one of the following options is NOT a new feature introduced in DB2 10?
A. Temporal Tables
B. Table Partitioning
C. Multi-Temperature Data Management
D. INGEST utility
Answer: B
CertBus exam braindumps are pass guaranteed. We guarantee your pass for the P2090-018 exam successfully with our IBM materials. CertBus IBM Information Management DB2 10 Technical Mastery Test v3 exam PDF and VCE are the latest and most accurate. We have the best IBM in our team to make sure CertBus IBM Information Management DB2 10 Technical Mastery Test v3 exam questions and answers are the most valid. CertBus exam IBM Information Management DB2 10 Technical Mastery Test v3 exam dumps will help you to be the IBM specialist, clear your P2090-018 exam and get the final success.
P2090-018 Latest questions and answers on Google Drive(100% Free Download): https://drive.google.com/file/d/0B_3QX8HGRR1mN3hBNkZaOW1uLVU/view?usp=sharing
P2090-018 IBM exam dumps (100% Pass Guaranteed) from CertBus: http://www.certgod.com/P2090-018.html [100% Exam Pass Guaranteed]
Why select/choose CertBus?
Millions of interested professionals can touch the destination of success in exams by certgod.com. products which would be available, affordable, updated and of really best quality to overcome the difficulties of any course outlines. Questions and Answers material is updated in highly outclass manner on regular basis and material is released periodically and is available in testing centers with whom we are maintaining our relationship to get latest material.