What type of workload is the default database workload standard optimized for?
A. Data Warehousing
B. OLAP (On Line Analytic Processing)
C. ODS (Operational Data Store)
D. OLTP (On Line Transaction Processing)
正解:D
解説: (Pass4Test メンバーにのみ表示されます)
質問 2:
What two servers must be available on the network for the initial deployment of the PureData System for Transactions?
A. LDAP server
B. SNMP server
C. NTP server
D. DNS server
E. TSM server
正解:C
質問 3:
What is the correct procedure to allow user eric SECADM access to the SAMPLE database in the db2sdin instance?
A. Log onto the Workload Console, open up the list of databases. Highlight the database SAMPLE and add user eric. Then log onto one of the instance hosts (or use Data Studio)
with proper access to grant SECADM on SAMPLE to user eric.
B. Log onto the Workload Console, open up the list of instances. Highlight the instance db2sdin and add user eric and set its group to g_sysadm. This will implicitly grant SECADM to all databases under the instance db2sdin.
C. Log onto the System Console, add userid eric. Once completed, select the user from the list and grant "Administrators" rights to this user.
D. Log onto the System Console, add userid eric. Once completed, select the user from the list and grant "Workgroup resources administration" rights to this user.
正解:D
質問 4:
Which two conditions restrict clients from using transaction level workload balancing during COMMIT and ROLLBACK operations on a pureScale instance?
A. An encrypted password is used.
B. Sequence values are used and DB2_ALLOW_WLB_WITH_SEGUENCES is enabled.
C. The secondary CF is in CATCHUP state.
D. PL/SQL packages or SQL/PL modules are used.
E. The member host which initiates the COMMIT or ROLLBACK operation is defined as the last entry in the db2dsdriverxfg configuration file.
正解:A,D
解説: (Pass4Test メンバーにのみ表示されます)
質問 5:
What do Database Patterns help capture?
A. Historical data
B. Configuration best practices
C. Real time statistics
D. User access information
正解:B
質問 6:
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 "Create new patterns" right under Workload Management.
B. Grant jane the "Manage all databases and client configurations (Full permission)" rights under Workload Management.
C. Bring up the list of instances. Highlight the instance db2sdin9 and add user jane to the list of "Access granted to" users.
D. Bring up the list of instances. Highlight the instance db2sdin9 and add user jane to the list of "Instance available to" users.
正解:C
Ooki -
本番試験が終わって、本当に合格することができました。Pass4Testに感謝感謝です