최신 DB2 000-614 무료샘플문제:
1. In which scenario should a DBA consider creating a multidimensional clustering (MDC) table instead of a regular base table?
A) To improve index performance in a data warehouse environment.
B) To improve access performance for tables in an OLTP database.
C) To improve query performance in a data warehouse environment.
D) To improve insert/delete performance for tables in an OLTP database.
2. What is the preferred method for reclaiming unused storage in a DMS table space?
A) Perform a REORG on each table within the table space, then perform an ALTER TABLESPACE...LOWER HIGH WATER MARK operation.
B) Perform an ALTER TABLESPACE...LOWER HIGH WATER MARK operation, and then an ALTER TABLESPACE...REDUCE operation.
C) Perform a REORG on each table within the table space, then perform an ALTER TABLESPACE...REDUCE operation.
D) Perform an ALTER TABLESPACE...REDUCE operation.
3. What are two supported methods for providing a low latency, high speed interconnect between DB2 members and the cluster caching facility (CF) in a DB2 pureScale environment? (Choose two.)
A) InfiniBand with RDMA (IB)
B) SCSI RDMA Protocol (SRP)
C) Internet Wide Area RDMA Protocol (iWARP)
D) RDMA over Converged Ethernet (RoCE)
E) iSCSI Extensions for RDMA (iSER)
4. In which situation would you NOT use a redirected restore?
A) To redefine the paths of a defined storage group.
B) To move table space containers onto different physical devices.
C) To restore a backup image to a target machine that is different from the source machine.
D) To restore a backup image from one operating system to another.
5. The following query is executed frequently against the EMPLOYEE table: SELECT empid, salary, bonus FROM employee ORDER BY bonus, salary; Which statement will create an index for optimal query performance?
A) CREATE INDEX bonus_salary_idx ON employee (bonus, salary)
B) CREATE INDEX bonus_salary_idx ON employee (bonus, salary) CLUSTER
C) CREATE INDEX salary_bonus_idx ON employee (salary, bonus) CLUSTER
D) CREATE INDEX salary_bonus_idx ON employee (salary, bonus)
질문과 대답:
| 질문 # 1 정답: C | 질문 # 2 정답: B | 질문 # 3 정답: A,D | 질문 # 4 정답: D | 질문 # 5 정답: B |
0 개 고객 리뷰
품질과 가치ITCertKR 의 높은 정확도를 보장하는 최고품질의 덤프는 IT인증시험에 대비하여 제작된것으로서 높은 적중율을 자랑하고 있습니다.
테스트 및 승인ITCertKR 의 덤프는 모두 엘리트한 전문가들이 실제시험문제를 분석하여 답을 작성한 만큼 시험문제의 적중률은 아주 높습니다.
쉽게 시험패스ITCertKR의 테스트 엔진을 사용하여 시험을 준비한다는것은 첫 번째 시도에서 인증시험 패스성공을 의미합니다.
주문하기전 체험ITCertKR의 각 제품은 무료 데모를 제공합니다. 구입하기로 결정하기 전에 덤프샘플문제로 덤프품질과 실용성을 검증할수 있습니다.
