IBM P2090-047 dumps - 100% Pass Guarantee!

When is the ToplogyImbalance event triggered?

A. When a SAS switch has failed.

B. When the path the path between an S-Blade and its disks has failed.

C. When a disk enclosure's voltage sensor is reading outside the nominal range.

D. When an S-Blade has ownership of more dataslices than is optimal (usually following a disk replacement).

Which statement is true regarding the compress engine?

A. Data automatically gets compressed.

B. Columns to be compressed must be defined.

C. The nzcompress utility must be run to compress the table.

D. The nzcompress utility must be run to compress the database.

When creating a table, you can specify a column constraint for each individual column of either "NULL" or "NOT NULL". When column values are later evaluated within a query statement, which of these is true?

A. 0 is equal to null, the empty string ( '' ) is equal to null.

B. 0 is equal to null, the empty string ( '' ) is not equal to null.

C. 0 is not equal to null, the empty string ( '' ) is equal to null.

D. 0 is not equal to null, the empty string ( '' ) is not equal to null.

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.

All database users are members of what predefined database group, which governs the basic access permissions that are granted to the system?

A. GUEST

B. USERS

C. PUBLIC

D. GLOBAL