P2090-047 Exam Questions
61 real P2090-047 exam questions with expert-verified answers and explanations. Page 1 of 2.
- Question #1
When creating a database from the workload console, which field is optional?
- Question #2
Which two items are true about automatic database backups via Tivoli Storage Manager?
- Question #3
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...
- Question #4
A user is not able to delete an instance. What could be the cause of this failure?
- Question #5
If there is a system problem to diagnose, where do you find system logs to download?
- Question #6
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...
- Question #7
Which two items regarding PureData database-level backups are true?
- Question #8
Which command can be used by a database administrator to display the status of a pureScale system?
- Question #9
Which operation can be used to stop member 0 with no impact on the running transaction?
- Question #10
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?
- Question #11
When looking up the information for the storage nodes, what does the location information show?
- Question #12
Which is a supported target for database backups?
- Question #13
Which list defines features available with the Database Performance Monitor?
- Question #14
A member's current state is "WAITING_FOR_FAILBACK". What does this state imply?
- Question #15
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...
- Question #16
Which statement describes how to increase the amount of information collected in the system trace logs?
- Question #17
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...
- Question #18
In order to use Lightweight Directory Access Protocol (LDAP) with an instance, when does LDAP have to be configured?
- Question #19
What are two advantages of using Database Patterns?
- Question #20
The Database Performance Monitor will automatically perform which task?
- Question #21
What is the minimum configuration for a production pureScale environment within a PureData System for Transactions?
- Question #22
When creating a pureScale instance, the user will be granted which two DB2 authorizations for all databases?
- Question #23
Which statement about client affinity is correct?
- Question #24
There are currently three databases in a small DB2 pureScale instance. Which statement is true about this DB2 pureScale instance?
- Question #25
What type of workload is the default database workload standard optimized for?
- Question #26
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?
- Question #27
What are two functions of the IBM System Networking RackSwitch G8264 top of rack switch?
- Question #28
Which statement about the Database Conversion Workbench is NOT true?
- Question #29
What do Database Patterns help capture?
- Question #30
What is the correct procedure to allow user eric SECADM access to the SAMPLE database in the db2sdin instance?
- Question #31
Which two buttons on the Infrastructure Map can be used to determine network utilization of the top of rack switch?
- Question #32
What is stored on the shared file system in a pureScale cluster?
- Question #33
Which two conditions restrict clients from using transaction level workload balancing during COMMIT and ROLLBACK operations on a pureScale instance?
- Question #34
How many unique VLAN(s) must be specified for the PureData System for Transactions to be integrated into the target network?
- Question #35
Which statement about the job schedule is NOT correct?
- Question #36
Which statement about the Database Conversion Workbench is correct?
- Question #37
What is the purpose of the IBM Easy Tier feature?
- Question #38
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?
- Question #39
Which statement about an instance-level user is true?
- Question #40
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?
- Question #41
What two authentication methods are available when configuring an external storage server for archived audit packages?
- Question #42
Where can you check the current power consumption of a PureData System for Transactions compute node?
- Question #43
Which statement regarding PureData and Secure Shell (SSH) is true?
- Question #44
In the authentication/authorization model, how many layers are used in a PureData System for Transactions system?
- Question #45
What is the minimum total storage needed for database creation?
- Question #46
Select two components that are updated in the system maintenance package.
- Question #47
Which permission is granted to a system user by default?
- Question #48
Which statement about a DB2 pureScale instance in a PureData System for Transactions is true?
- Question #49
How frequently does the automatic system backup run?
- Question #50
Which configuration management job can show differences between database tables?