Online Access Free C2090-310 Practice Test

The Database Performance Monitor will automatically perform which task?

• A.Perform RUNSTATS on tables to provide updated statistics.
• B.Inspect tables for evaluating possible compression candidates.
• C.Capture historical performance metrics for comparison.
• D.Schedule automated table reorganizations.

You need to grant user jane the ability to create new databases on an instance db2sdin9. Which statement describes the correct procedure to grant user jane this access?

• A.Grant jane the "Manage all databases and client configurations (Full permission)" rights under Workload Management.
• B.Bring up the list of instances. Highlight the instance db2sdin9 and add user jane to the list of "Instance available to" users.
• C.Grant jane the "Create new patterns" right under Workload Management.
• D.Bring up the list of instances. Highlight the instance db2sdin9 and add user jane to the list of "Access granted to" users.

Which list defines features available with the Database Performance Monitor?

• A.Database alerts, user-defined alerts, and system templates for monitoring
• B.Instance alerts, user-defined alerts and system templates for monitoring
• C.Instance alerts, database alerts, user-defined alerts, and system templates for monitoring
• D.Instance alerts, database alerts, and system templates for monitoring

Which statement regarding PureData and Secure Shell (SSH) is true?

• A.Full functionality of IBM Data Studio features will not be available without SSH.
• B.PureData utilizes SSH to access Cloud Resources.
• C.SSH is required to support the PureData web console.
• D.Automatic Client Re-route (ACR) requires SSH.

Which statement about the Database Conversion Workbench is correct?

• A.The Database Conversion Workbench is distributed as a plug-in for the IBM Data Studio tool.
• B.The Database Conversion Workbench is available from one of the compute nodes that are part of the DB2 pureScale instance cluster.
• C.. The Database Conversion Workbench can be used to convert databases in the IBM PureData System for Transactions to non-IBM databases.
• D.The Database Conversion Workbench can only be used with databases created on the Linux operating system for compatibility with databases in the IBM PureData System for Transactions.