IBM PureData System for Analytics Technical Mastery Test v1 - P2090-050 Free Exam Questions

A. Gives permission to execute global operations and to create objects.

B. Gives additional storage to select members of the administrator group.

C. Manages resource allocations for concurrent processing.

D. Provides audit functionality for the database.

A. Run EXECUTION PLAN before the query has been submitted.

B. Issue "SELECT * FROM _V_SESSION;"

C. Turn ODBC tracing ON.

D. Go to the query history within the Windows NzAdmin GUI tool.

E. Issue "SHOW PLANFILE <nn>;" after the query has been submitted.

A. The host, the S-blades and theFPGAs.

B. The S-blades and the FPGAs only.

C. The host only.

D. The host and the S-blades only.

A. Compression degrades data scan speeds.

B. Compression is performed by the SAS switches.

C. Compression is performed by the host.

D. Compression ratio is data dependent.

A. The table statistics are used to facilitate disk space reclamation of deleted rows.

B. The Field Programmable Gate Array (FPGA) utilizes the statistics to identify which row/columns to filter.

C. The optimizer uses statistics to determine the optimal execution plan for queries.

D. The Zone Map information cross references the table statistics for each column to avoid scanning.

A. A SAS cable fails or is disconnected.

B. A chassis or fabric switch port is in a down state for longer than the defined threshold.

C. A power supply has failed.

D. A switch has beenrebooted.