IBM IBM Certifications P2090-050 Questions & Answers

• Question 41:

  Given the following query: SELECT * FROM TableA; how does data flow through the PureData System for Analytics components?

  A. Disk to FPGA to Host to User.

  B. Disk to FPGA to S-Blade to User.

  C. Disk to Host to S-Bladeto FPGA to User.

  D. Disk to FPGA to S-Blade to Host to User.

  Correct Answer: D

• Question 42:

  Which statement regarding temporary tables is true?

  A. They are limited to 1 terabyte in size.

  B. They may include a DISTRIBUTE ON clause.

  C. They are limited to 16per user per database.

  D. They will be included in any nzbackup of the database.

  Correct Answer: B

• Question 43:

  What two types of notification can be configured for an event? (Choose two.)

  A. Insert a row into TableA.

  B. Run a stored procedure.

  C. Run a command on the active Host.

  D. Send an email to a list of addresses.

  E. Send a Simple Network Message Protocol (SNMP) event.

  Correct Answer: CD

• Question 44:

  The simplest query execution plan file must have the following minimum nodes?

  A. ScanNode, RestrictNode, LimitNode, ReturnNode

  B. ScanNode, RestrictNode, HashNode, ReturnNode

  C. ScanNode, RestrictNode, ProjectNode, ReturnNode

  D. ScanNode, RestrictNode, AggregateNode, ReturnNode

  Correct Answer: C

• Question 45:

  Short Query Bias (SQB) allows forreserved resources to be used for which type of query?

  A. Queries with no joins.

  B. Queries returning only one row in the result set.

  C. SQL statements less than 255 characters in length.

  D. Queries with a runtime estimation of less than 2 seconds.

  Correct Answer: D

• Question 46:

  What is true about queries submitted on the PureData System for Analytics Appliance?

  A. Queries are uncompressed by the host and sent to the user.

  B. Queries are consolidated by the host and executed together in one block.

  C. Queries are compiled by the host and executed in parallel by the S-Blades.

  D. Queries are compressed by the host and optimized for parallel processing.

  Correct Answer: C

• Question 47:

  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.

  Correct Answer: A

• Question 48:

  The PureData System for Analytics implements which level of transaction isolation?

  A. Serializable

  B. Committed read

  C. Repeatable read

  D. Uncommitted read

  Correct Answer: A

• Question 49:

  nzload is invoked with the "allowReplay" option enabled. While the PureData System for Analytics Appliance changes state from online to pausing then to online, which statement is true about the nzload process on the Appliance?

  A. nzload will fail.

  B. nzload automatically continues without user intervention.

  C. nzload must be stopped and resumed by the user from the last check point.

  D. nzload automatically restarts but the user must remove the allowReplay option.

  Correct Answer: B

• Question 50:

  What is the naming convention for system views?

  A. _v_...

  B. nz_v_...

  C. _$v_...

  D. sys_v_...

  Correct Answer: A