Online P2090-047 Questions Video

IBM PureData System for Transactions Technical Mastery Test v1 Questions and Answers

Question 13

A stored procedure returning one value is created, which two methods can be used to execute the procedure? (Choose two.)

Using the EXECUTE command.

Using the SELECT statement within a FROM clause.

Using the SELECT statement within a HAVING clause.

Using the SELECT statement without a FROM clause.

Using the SELECT statement with tables in the FROM clause.

Question 14

When a poor choice of distribution key is made, what is the impact to storage allocation?

Data is likely to negatively affect views.

Data is likely to negatively affect compression.

Data is likely to generate duplicate sequence values.

Data is likely to be unevenly spread across the system.

Question 15

Which piece of information is NOT gathered as part of the statistical information when generate statistics is run on a table?

The number of rows in the table.

The number of updated rows in the table.

The minimum and maximum value in each column.

The number of unique or distinct values in each column.

Question 16

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

Serializable

Committed read

Repeatable read

Uncommitted read