Online Access Free P2090-018 Practice Test

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 can be used to load and create external functions in a DB2
  database.
• D.The DB2 Load utility is a high-speed, low-level, data loading utility that loads data into a DB2 database.

Which of the following is TRUE about PL/SQL support in DB2?

• A.The DB2 compiler can process PL/SQL statements and create the required objects in the database. The PL/SQL support is enabled by setting the DB2_COMPATIBILITY_VECTOR registry variable.
• B.DB2 requires third party software to execute PL/SQL statements.
• C.PL/SQL support is only enabled when using federation to access other vendor databases.
• D.You can only execute PL/SQL statements using the CLPPIus interface.

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 best practices recommend that cold data should be stored in faster devices in order to maximize overall system performance.
• 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 reduces the total cost of ownership by allowing efficient deployment of storage hardware with minimal administrative overhead.

What does the table partitioning feature in DB2 allow you to do?

• A.Table partitioning allows you to make smaller tables automatically from large tables, thereby increasing the performance of your DB2 database.
• B.Table partitioning allows you to create very large tables that are divided across multiple storage objects so that you can quickly attach and detach large quantities of data from the tables.
• C.Table partitioning allows you to partition the table data based on the hash values of the primary key.
• D.Table partitioning allows you to create result set tables from a join query, which automatically splits the data into smaller chunks, thereby increasing the performance of your DB2 database.

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 reduces the risk and cost associated with growing your distributed database solution by providing extreme capacity and application transparency.
• C.DB2 pureScale uses the same concept of HADR where the data is replicated from a primary database to a standby database.
• D.DB2 pureScale persists data in the cluster caching facilities (CFs).