P2090-047 Exam Questions

When creating a database from the workload console, which field is optional?

Which two items are true about automatic database backups via Tivoli Storage Manager?

There are an even number of members in a pureScale cluster. What happens to the pureScale cluster if half of the members and the primary Cluster Caching facility (CF) fail simultan...

A user is not able to delete an instance. What could be the cause of this failure?

If there is a system problem to diagnose, where do you find system logs to download?

PureData System for Transactions top of rack switch supports different connection speeds for integration into the customer network. What are the different connection speeds support...

Which two items regarding PureData database-level backups are true?

Which command can be used by a database administrator to display the status of a pureScale system?

Which operation can be used to stop member 0 with no impact on the running transaction?

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?

When looking up the information for the storage nodes, what does the location information show?

Which is a supported target for database backups?

Which list defines features available with the Database Performance Monitor?

A member's current state is "WAITING_FOR_FAILBACK". What does this state imply?

When creating a database workload standard, users must follow the specified file directory structure within the .zip archive file. Identify the mandatory script(s) required to crea...

Which statement describes how to increase the amount of information collected in the system trace logs?

Connections to database dpq07 have been re-routed from one member to another, all new connections are also being re-routed, and overall transactional throughput has dropped. Which...

In order to use Lightweight Directory Access Protocol (LDAP) with an instance, when does LDAP have to be configured?

What are two advantages of using Database Patterns?

The Database Performance Monitor will automatically perform which task?

What is the minimum configuration for a production pureScale environment within a PureData System for Transactions?

When creating a pureScale instance, the user will be granted which two DB2 authorizations for all databases?

Which statement about client affinity is correct?

There are currently three databases in a small DB2 pureScale instance. Which statement is true about this DB2 pureScale instance?

What type of workload is the default database workload standard optimized for?

When using db2instance -list on a db2 pureScale cluster the following output is received: (Refer to the exhibit that appears below) Which statement is NOT correct?

What are two functions of the IBM System Networking RackSwitch G8264 top of rack switch?

Which statement about the Database Conversion Workbench is NOT true?

What do Database Patterns help capture?

What is the correct procedure to allow user eric SECADM access to the SAMPLE database in the db2sdin instance?

Which two buttons on the Infrastructure Map can be used to determine network utilization of the top of rack switch?

What is stored on the shared file system in a pureScale cluster?

Which two conditions restrict clients from using transaction level workload balancing during COMMIT and ROLLBACK operations on a pureScale instance?

How many unique VLAN(s) must be specified for the PureData System for Transactions to be integrated into the target network?

Which statement about the job schedule is NOT correct?

Which statement about the Database Conversion Workbench is correct?

What is the purpose of the IBM Easy Tier feature?

Which state indicates that a compute node will not accept any new database connections, but the current connections on the compute node will continue to run?

Which statement about an instance-level user is true?

When configuring SNMP trap destinations in the event forwarding pane of the PureData System for Transactions system console, what is the default SNMP community setting?

What two authentication methods are available when configuring an external storage server for archived audit packages?

Where can you check the current power consumption of a PureData System for Transactions compute node?

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

In the authentication/authorization model, how many layers are used in a PureData System for Transactions system?

What is the minimum total storage needed for database creation?

Select two components that are updated in the system maintenance package.

Which permission is granted to a system user by default?

Which statement about a DB2 pureScale instance in a PureData System for Transactions is true?

How frequently does the automatic system backup run?

Which configuration management job can show differences between database tables?