IBM IBM Certifications P2090-047 Questions & Answers

• Question 41:

  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 42:

  Where are the database log files located?

  A. /var/log

  B. /usr/local

  C. /nz/kit/log

  D. The SYSTEM database

  Correct Answer: C

• Question 43:

  If user A has a minimum resource allocation of 20% and a maximum of 80%, user A can receive what percentage of available resources?

  A. A maximum of 20% of resources when other users are on the system.

  B. A maximum of 50% of resources when other users are on the system.

  C. A maximum of 80% of resources when no other users are on the system.

  D. A maximum of 100% of resources when no other users are on the system.

  Correct Answer: C

• Question 44:

  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-Blade to FPGA to User.

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

  Correct Answer: D

• Question 45:

  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 46:

  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 47:

  Short Query Bias (SQB) allows for reserved 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 48:

  What two conditions must be met to achieve a collocated join between two tables? (Choose two.)

  A. Both tables have primary keys defined.

  B. Both join columns have the same name.

  C. Both tables must be distributed on random.

  D. Both join columns have identical data types.

  E. Both tables must be distributed on their join column.

  Correct Answer: DE

• Question 49:

  Which statement is true 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 50:

  What is the naming convention for system views?

  A. _v_...

  B. nz_v_...

  C. _$v_...

  D. sys_v_...

  Correct Answer: A