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

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: 31

Consider a scenario where your DB2 pureScale cluster caching facilities are in PEER state. What would be the state of the secondary cluster caching facility upon failure of the primary cluster caching facility and a successful takeover?

  1. ERROR

  2. PEER

  3. PRIMARY

  4. NEW_PRIMARY

Answer: C

Question No: 32

Consider the scenario where a server quot;pscale1quot; hosts a DB2 member and one cluster caching facility. In a situation where a database administrator wants to perform an operating system update on quot;pscale1quot;, which one of the following options will ensure that both the member and cluster caching facility won#39;t be automatically restarted by DB2 cluster services while the system is upgraded?

  1. Log in to any of the hosts as a root user. Stop the member and cluster caching facility.

    Remove the member and cluster caching facility from the cluster.

  2. Log in to any of the hosts as root user.

    Bring the member on quot;pscale1quot; to quiesce mode. Bring the member on quot;pscale1quot; to maintenance mode.

    Bring cluster caching facility on quot;pscale1quot; to maintenance mode.

  3. Log in to quot;pscale1quot; as a DB2 instance user.

    Bring the member on quot;pscale1quot; to quiesce mode and stop the cluster caching facility. Stop the instance on quot;pscale1quot;.

    Log in as DB2 cluster services administrator. Bring quot;pscale1quot; host to maintenance mode.

  4. Log in as a cluster services administrator.

Bring the member on quot;pscale1quot; to quiesce mode and stop the cluster caching facility. Bring the member on quot;pscale1quot; to maintenance mode.

Bring cluster caching facility on quot;pscale1quot; to maintenance mode.

Answer: C

Question No: 33

Consider the scenario where the primary cluster caching facility failed while the secondary cluster caching facility was in CATCHUP state. Which of the following outcomes is CORRECT?

  1. The DB2 pureScale cluster would freeze. A database administrator must restore the database from a previous backup and then roll forward the database to a point in time before the freeze.

  2. DB2 cluster services will initiate a group restart with the former secondary cluster caching facility becoming the primary CF for the cluster. The instance will be temporarily unavailable while the services restart automatically

  3. The instance would be brought down. DB2 cluster services then restarts only the secondary cluster caching facility now in the primary role.

  4. The takeover operation succeeds and the secondary cluster caching facility will be promoted to primary. The cluster would continue processing incoming read-only transactions.

Answer: B

Question No: 34

Which one of the following options contains the minimum configuration for a DB2 pureScale cluster capable of recovering from a member failure?

  1. 1 cluster caching facility and 1 DB2 members.

  2. 2 cluster caching facilities and 1 DB2 member.

  3. 1 cluster caching facility and 2 DB2 members.

  4. 2 cluster caching facilities and 2 DB2 members.

Answer: C

Question No: 35

What is a DB2 instance?

  1. A DB2 instance is just another name for DB2 Database.

  2. A DB2 instance is a copy of a database that can be accessed standalone from the database server.

  3. A DB2 instance is a logical database manager environment where you catalog databases and set configuration parameters.

  4. DB2 does not use instances. It requires only databases to operate.

Answer: C

Question No: 36

Which of the following options best defines the Label-Based Access Control (LBAC) feature?

  1. DB2 LBAC allows you to use labels to reference database objects by a short name instead of the full qualified name.

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

  3. DB2 LBAC monitors table data access and tables modifications made by database users.

  4. DB2 LBAC is the DB2 authority in charge of issuing GRANT and REVOKE statements.

Answer: B

Question No: 37

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

  1. Temporal tables are complex to maintain and require major application changes.

  2. Temporal tables require constant changes to the operating system timestamp in order to navigate through time in the database.

  3. Temporal tables are used to model data in the past and present. They cannot be used to model data in the future.

  4. Temporal tables are used to model data in the past, present, and future.

Answer: D

Question No: 38

Which one of the following options is FALSE about DB2#39;s Multi-Temperature Data Storage capability?

  1. You can use storage groups to implement multi-temperature data management in DB2.

  2. Multi-temperature data management reduces the total cost of ownership by allowing efficient deployment of storage hardware with minimal administrative overhead.

  3. Multi-temperature data management integrates with DB2#39;s Workload Manager feature to let you prioritize your workloads based on the data being accessed.

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

Which one of the following options is TRUE about High Availability and Disaster Recovery (HADR) feature?

  1. HADR allows up to two HADR standby databases.

  2. HADR allows up to three HADR standby databases.

  3. HADR allows up to four HADR standby databases.

  4. HADR allows up to five HADR standby databases.

Answer: B

Question No: 40

What is the purpose of the Self Tuning Memory Manager (STMM) in DB2?

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

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

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

  4. STMM allows DBAs to inspect the current memory allocation by buffer pools.

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.