Pass4Test는 IT업계에서 유명한 IT인증자격증 공부자료를 제공해드리는 사이트입니다. 이는 Pass4Test 의 IT전문가가 오랜 시간동안 IT인증시험을 연구한 끝에 시험대비자료로 딱 좋은 덤프를 제작한 결과입니다. IBM Information Management P2090-050덤프는 수많은 덤프중의 한과목입니다. 다른 덤프들과 같이  IBM Information Management P2090-050덤프 적중율과 패스율은 100% 보장해드립니다. IBM Information Management P2090-050시험에 도전하려는 분들은 Pass4Test 의 IBM Information Management P2090-050덤프로 시험을 준비할것이죠?

NO.1 Which statement istrue regarding the compress engine?

A. Compression ratio is data dependent.

B. Compression is performed by the host.

C. Compression degrades data scan speeds.

D. Compression is performed by the SAS switches.

Answer: A

NO.2 Which is NOT a way to check if the database is online?

A. nzstate

B. cat /proc/database

C. nzsystem showState

D. nzsql -c "select * from _v_system_info;"

Answer: B

NO.3 An ETL/ODBC application is inserting 1 million records in a single transaction against the

PureData System for Analytics. 1 million individual INSERT SQL statements are generated. What can

make this faster?

A. Use a COPY command.

B. Use an EXTERNAL TABLE.

C. Increase the Socket Buffer Size.

D. Set the COMMIT interval to 10,000.

Answer: B

NO.4 When unloading data via an external table, where can the SQL be submitted?

A. From a User Defined Function.

B. From nzsql on an AIX machine networked to the system.

C. From nzsql on Microsoft Windows networked to the system.

D. From an ODBC application on Windows networked to the system.

Answer: D

NO.5 Where are the database log fileslocated?

A. /var/log

B. /usr/local

C. /nz/kit/log

D. The SYSTEM database

Answer: C

NO.6 Why is table skew important to manage?

A. Low table skew negatively impacts performance.

B. High table skew negatively impacts performance.

C. Low table skew negatively impacts data compression.

D. Deleted rows consume disk space until they are freed.

Answer: B