IBM PureData System for Analytics v7.1

1.

Which of the following is a valid data type definition?

TEXT CLOB CHAR(128000) NUMERIC(38,1)

2.

Which of the following is TRUE regarding distribution keys?

Up to 4 columns can be specified for a distribution key on a table The distribution key cannot be changed on a given table once that table is created Rows with the same distribution key value are stored on the same data slice All of the above

3.

What will prevent a GROOM TABLE command from running on a table?

There are active materialized views on the table There are active selects running against the table There are active nzloads running against the table There are active updates running against the table

4.

The DBA created and loaded the table CUSTOMER as follows: Please refer to the excerpt (highlighted in bold) of a successful query execution plan which used the CUSTOMER table. Which of the following statements is TRUE?

The FPGA cannot restrict columns declared as CHAR(7) The FPGA can only restrict columns which are distribution columns The FPGA can directly compute the result of the table predicate while reading the rows The FPGA cannot compute the result of the table predicate for varying character columns

5.

What is the maximum factor that page granular zone maps can improve performance over extent- based zone maps?

8 times 16 times 24 times 48 times

6.

Why is it important to manage data skew?

Low table skew negatively impacts performance High table skew negatively impacts performance Low table skew negatively impacts data compression Deleted rows consume disk space until they are freed

7.

When doing a CREATE SEQUENCE, which is always true about INCREMENT BY?

The value may only be positive The value may only be negative Cross-database access is supported The value may be either negative or positive

8.

Heres an excerpt from a successful query execution plan file: What does DownloadTableNode distribute indicate?

A broadcast is going to take place every time the query is executed A redistribution is going to take place every time the query is executed A broadcast is going to take place only the first time the query is executed A redistribution is going to take place only the first time the query is executed

9.

What is a view?

A virtual table stored in memory rather than on disk A pre-defined query executed in real time when the view is accessed A table of which only portions are visible to users based on user permissions All of the above

10.

A user is logged onto the PROD database. The user has access to other databases on the same appliance. Which types of objects from other databases can the user reference in queries?

Views Tables Synonyms All of above

IBM PureData System for Analytics v7.1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

IBM PureData System for Analytics v7.1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner