P2090-050 IBM PureData System for Analytics Technical Mastery Test v1 Questions and Answers

No more than 4 users can be assigned to GroupA.

If users in GroupA submit more than 4 queries they will fail.

If users in GroupA submit more than 4 queries, then they will queue in order.

The job maximum cannot be less than the default concurrent query limit of 48.

Data automatically gets compressed.

Columns to be compressed must be defined.

The nzcompress utility must be run to compress the table.

The nzcompress utility must be run to compress thedatabase.

Serializable

Committed read

Repeatable read

Uncommitted read

From a User Defined Function.

From a JDBC application networked to the system.

From nzsql on an AIX machine networked to the system.

From nzsql on Microsoft Windows networked to the system.

1

12

31

> 96

Active - Active

Active - Stand by

Stand by -Backup

Stand by - Passive

GROOM TABLE requires space to make a complete copy of the table.

GROOM TABLE only operates on tables that include an ORGANIZE ON clause.

GROOM TABLE prevents nzload from adding data while groom is in progress.

GROOM TABLE allows UPDATE, DELETE, and INSERT operations to occur while groom is in progress.

1

2

4

8

They can be set system wide only.

They can be set at the database level only.

They can be set at the session and at the group level.

They can be set system wide and at the session level.

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

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

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

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

Database user ADMIN privileges.

Database user SELECT privileges.

Database user GROUP authentication.

Database user password authentication.

The user has a table spacedefined.

The user can be assigned to more than one group.

The user must have a corresponding host account.

The user can be removed from the default PUBLIC group.

Turn ODBC tracing ON.

Issue "SELECT * FROM _V_SESSION;"

Go to the query history within the Windows NzAdmin GUI tool.

Run EXECUTION PLAN before the query has been submitted.

Issue "SHOW PLANFILE ;" after the query has been submitted.

CREATE TABLE TableA (LastName VARCHAR(20));

CREATE TABLE TableA (LastName VARCHAR(20));

ALTER TABLE TableA ZONEMAP ON (LastName);

CREATE TABLE TableA (LastName VARCHAR(20)) DISTRIBUTE ON (LastName);

CREATE TABLE TableA (LastName VARCHAR(20));

CREATE MATERIALIZED VIEW ViewA AS SELECT * FROM TableA ORDER BY LastName;

Queries are executed in parallel by the host.

Queries must be compressed before they can be executed.

Queries are compiled into snippets and executed in parallel by the S-Blades.

Queries must be uncompressed by the user and executed in parallel by the host.

A query is compiled into a snippet which is executed across all available S-Blades.

kill

abort

nzstop

nzsession