[Free] 2018(Jan) EnsurePass Passguide IBM P2090-054 Dumps with VCE and PDF 41-50

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan IBM Official New Released P2090-054
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/P2090-054.html

IBM Information Management DB2 10 pureScale Technical Mastery Test v3

Question No: 41

DB2#39;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.

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

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

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

  4. HADR feature is only available for DB2 Advanced Enterprise Edition.

Answer: C

Question No: 42

What is the DB2 Design Advisor?

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

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

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

  4. The DB2 Design Advisor is a tool that can be used to automatically create tables based on a physical data diagram.

Answer: C

Question No: 43

Which one of the following options is NOT a new feature introduced in DB2 10?

  1. Temporal Tables

  2. Table Partitioning

  3. Multi-Temperature Data Management

  4. INGEST utility

Answer: B

Question No: 44

What are some of the benefits of DB2 Express?

  1. DB2 Express has affordable licensing terms with all of the core features of the DB2 engine.

  2. DB2 Express is designed for development and testing. It is not used as a production database.

  3. DB2 Express is fastest and most powerful DB2 edition.

  4. DB2 Express is a tool that allows DBAs to quickly solve complex database issues.

Answer: A

Question No: 45

The following are true about the Configuration Advisor, EXCEPT:

  1. It offers recommendations for the initial values of buffer pool size, database configuration parameters, and database manager configuration parameters.

  2. It creates database objects such as indexes and MQTs to improve performance.

  3. By default, the Configuration Advisor is automatically executed when you create a new database.

  4. To use the Configuration Advisor, you can execute the AUTOCONFIGURE command from the DB2 Command Line Processor.

Answer: B

Question No: 46

Which one of the following sentences does NOT describe a benefit of Temporal Tables?

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

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

  3. Temporal tables allow better data management by letting the application control data integrity and uniqueness.

  4. Temporal tables provide a quick and easy way to track and record data changes in the table.

Answer: C

Question No: 47

What is the DB2 Load utility?

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

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

  3. The DB2 Load utility is a high-speed, low-level, data loading utility that loads data into a DB2 database.

  4. The DB2 Load utility can be used to load and create external functions in a DB2 database.

Answer: C

Question No: 48

Which one of the following options contains a benefit of the Java Generic Table Functions?

  1. Java Generic Table Functions allow you to specify the output of a table function when you create it, rather than when you reference it.

  2. Java Generic Table Functions allow you to specify the output of a table function when you reference it, rather than when you create it.

  3. Java Generic Table Functions must run on a separate server, thus they don#39;t consume DB2 resources.

  4. Java Generic Table Functions can be implemented in any programming language.

Answer: B

Question No: 49

Which DB2 licensing type is based on the number of users allowed to access the data server?

  1. PVU (Processor Value Unit) licensing

  2. Sub-capacity licensing

  3. Authorized User (AU) licensing

  4. Per Server licensing

Answer: C

Question No: 50

Which one of the following options is CORRECT about Temporal Tables?

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

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

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

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

100% Ensurepass Free Download!
Download Free Demo:P2090-054 Demo PDF
100% Ensurepass Free Guaranteed!
P2090-054 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

This entry was posted in P2090-054 Latest Exam (Jan 2018) and tagged , , , , , , , . Bookmark the permalink.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.