IBM PureData System for Analytics v7.1 Set 2

1.

Data Restrict Optimization does NOT accomplish which of the following?

Reduces latency of the query Reduces the time taken to process a single snippet Allows multiple different snippets to run concurrently Reduces the number of drives searched by a snippet

2.

When creating a table with nullable columns, which statement is TRUE?

0 is equal to null, the empty string () is equal to null 0 is equal to null, the empty string () is not equal to null 0 is not equal to null, the empty string () is equal to null 0 is not equal to null, the empty string () is not equal to null

3.

Within a single Pure Data System for Analytics, what is the fastest way to copy a very large table from database PROD to database TEST?

Use a CTAS statement Use the COPY command Use external tables and UNIX pipes Use nzbackup and nzrestore commands

4.

Why is generating statistics on a table important to query performance?

The table statistics are used to facilitate dislespace reclamation of deleted rows The optimizer uses statistics to determine the optimal execution plan for queries The zone map information cross references the table statistics for each column to avoid scanning The Field Programmable Gate Array (FPGA) utilizes the statistics to identify which rows/columns to filter

5.

What must be properly defined for a table in order to avoid data skew:

Skew ratio Distribution Organization Statistics generation

6.

When reviewing the output of an EXPLAIN PLANGRAPH in IBM Netezza Performance Portal, how is the output read?

Left to right, from top to bottom Left to right, from bottom to top Right to left, from top to bottom Right to left, from bottom to top

7.

What utility is used to find out which host is currently active?

nzstate nzconfig crm_resource service heartbeat start

8.

What information is the NZDUMPSCHEMA command capable of outputting?

Table definitions only Table definitions, and view definitions only Table definitions, view definitions, and database statistical information only Table definitions, view definitions, database statistical information, and user-defined extensions registered within the database

9.

When enabled, query history always collects information about login failures, session creation, session termination, and query history process startup. Which area does query history NOT collect data?

Plans Disks Tables Queries

10.

When working with sequences, which statement will always be TRUE?

Only integers are generated The default data type is SMALL I NT The first value generated is the number 1 Values generated by the sequence will be unique across all tables and databases

IBM PureData System for Analytics v7.1 Set 2

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 Set 2

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