Online Access Free P2090-054 Exam Questions

A database administrator executed a db2iupdt command in order to drop a cluster caching facility from a DB2 pureScale cluster. Which command can be used to verify that the cluster caching facility is no longer part of the cluster?

• A.db2instance -all -cfs
• B.db2instance -list -cfs -details
• C.db2instance -list
• D.db2instance -display -cluster -modifications

How can you verify that a DB2 installation was successful?

• A.Verification is automatically performed by the AUTO_CONFIGURE feature.
• B.Verification is completed by the DBA using the database verification toolkit.
• C.Verification is performed by running the VERIFY INSTALL command.
• D.Verification can be done by successfully creating a SAMPLE database and running SQL commands to retrieve sample data.

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

• A.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.
• B.Log in to any of the hosts as root user.
  Bring the member on "pscale1" to quiesce mode.
  Bring the member on "pscale1" to maintenance mode.
  Bring cluster caching facility on "pscale1" to maintenance mode.
• C.Log in as a cluster services administrator.
  Bring the member on "pscale1" to quiesce mode and stop the cluster caching facility.
  Bring the member on "pscale1" to maintenance mode.
  Bring cluster caching facility on "pscale1" to maintenance mode.
• D.Log in to "pscale1" as a DB2 instance user.
  Bring the member on "pscale1" to quiesce mode and stop the cluster caching facility.
  Stop the instance on "pscale1".
  Log in as DB2 cluster services administrator.
  Bring "pscale1" host to maintenance mode.

Which one of the following options is correct about the differences between the IMPORT and INGEST utilities?

• A.The IMPORT utility can import data into a database, while the INGEST can only create database objects based on a script file.
• B.The INGEST is capable of transforming and streaming data from files and pipes at high speeds into DB2 tables. The IMPORT utility cannot transform the data.
• C.The IMPORT utility can perform lightweight transformations on the data being processed. The INGEST utility cannot transform data.
• D.The IMPORT utility is now deprecated and INGEST is the recommended alternative.

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

• A.Multi-Temperature Data Management
• B.Table Partitioning
• C.Temporal Tables
• D.INGEST utility