A2090-544 試験問題を無料オンラインアクセス

What would indicate intra-partition parallelism in an Optimizer Plan?

• A.BTQ
• B.LTQ
• C.IP
• D.DTQ

Which data organization schemes are supported?

• A.PARTITION BY HASH and ORGANIZE BY RANGE
• B.PARTITION BY RANGE and ORGANIZE BY
• C.PARTITION BY HASH and ORGANIZE BY
• D.PARTITION BY RANGE and ORGANIZE BY HASH

A partitioned instance named DB2INST1 uses the following db2nodes.cfg file:
If the CREATE DATABASE command is executed on server C, which partition will be the catalog partition?

• A.6
• B.1
• C.0
• D.4

A DBA would like to examine repartitioning options for a partitioned database named PRODDB. Which tool can be used to provide recommendations on re-partitioning?

• A.Configuration Advisor
• B.Workload Manager
• C.Partition Assistant
• D.Design Advisor

Which conditions must be met to implement HADR?

• A.Operating systems on primary and standby servers need not be the same; DB2 versions must be the same; and the databases need not have the same bit-size (32 or 64 bit).
• B.Operating systems on primary and standby servers must be the same; DB2 versions must be the same; and the databases must have the same bit-size (32 or 64 bit).
• C.Operating systems on primary and standby servers must be the same; DB2 versions must be the same; and the databases need not have the same bit-size (32 or 64 bit).
• D.Operating systems on primary and standby servers must be the same; DB2 versions need not be the same; and the databases must have the same bit-size (32 or 64 bit).