최신 IBM Information Management P2090-054 무료샘플문제:
1. Which of the following statements is FALSE when monitoring the high usage of lock memory in a DB2 pureScale environment?
A) Data concurrency issues can arise due to a high number of lock escalations.
B) Lock escalations can take place if there is insufficient memory.
C) Performance will not be affected due to high usage of Lock Memory.
D) Request for locks might be denied.
2. Which one of the following options is NOT a new feature introduced in DB2 10?
A) Temporal Tables
B) Table Partitioning
C) Multi-Temperature Data Management
D) INGEST utility
3. Consider the scenario where a database administrator (DBA) would like to apply operating system updates on the host machine that contains one of the DB2 pureScale members. The primary cluster caching facility and other members are located on different physical machines. Which of the following tasks should be performed by the DBA on the host machine before applying the operating system updates, so that the member will not be restarted?
A) Place the member into quiesce mode.
B) Place the member into maintenance mode.
C) Place the host machine into maintenance mode.
D) Place the cluster caching facility in standby mode.
4. How does DB2 pureScale handle member(s) failover scenarios?
A) All data remains locked until the failover operation is completed.
B) Current connections to the failed member will be on hold until the member recovers and is back online.
C) Future connections are evenly distributed among the surviving members of the cluster.
D) DB2 pureScale requires database administrator intervention to handle failover scenarios.
5. What is a table space in DB2?
A) A table space is a logical storage grouping that can be composed of one or more containers.
B) A table space is a space reserved for catalog tables and base table data.
C) A table space is an area of main memory that has been allocated by the database manager for the purpose of caching table and index data as it is read from the physical media.
D) A table space is a DB2 component that manages access to databases.
질문과 대답:
질문 # 1 정답: C | 질문 # 2 정답: B | 질문 # 3 정답: C | 질문 # 4 정답: C | 질문 # 5 정답: A |