P2090-047 Sample Questions Answers

High Availability

Load Balancing

High Concurrency

Work Load Management

Disk to FPGA to Host to User.

Disk to FPGA to S-Blade to User.

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

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

Hash join.

Merge join.

Expression join.

Cross product join.

From a User Defined Function.

From nzsql on an AIX machine networked to the system.

From nzsql on Microsoft Windows networked to the system.

From an ODBC application on Windows networked to the system.

A DELETE from TableA

A SELECT from TableA

A TRUNCATE of TableA

An nzbackup of the database in which TableA resides

It includes a date portion.

It includes a timezone offset.

The value is reevaluated each time the row is selected.

The value is initially assigned when the row is first created.

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;

1

2

4

8

The system does not have a limitation on floating-point data types.

The system cannot perform any type of join on floating-point data types.

The system cannot perform a fast sort merge join on a floating point data type, but instead must perform a slower hash join.

The system cannot perform a fast hash join on a floating point data type, but instead must perform a slower sort merge join.

All user space is available for database expansion.

Each database is assigned it's own section of disk space.

When creating the database you can specify which disks to use.

When you create a database you can set the maximum space it is allowed to use.

Serializable

Committed read

Repeatable read

Uncommitted read

Groom allows the user to add row level security.

Groom validates primary key constraints on the table.

Groom reorders rows based on the DISTRIBUTE ON clause.

Groom allows the user to reorganize tables based on the ORGANIZE ON clause.

sar

nzhw

nzsystem

nzinventory

kill

abort

nzstop

nzsession

When a SAS switch has failed.

When the path the path between an S-Blade and its disks has failed.

When a disk enclosure's voltage sensor is reading outside the nominal range.

When an S-Blade has ownership of more dataslices than is optimal (usually following a disk replacement).

Create an nzcron event.

nzstop/nzstart the database.

Stop and start the appliance.

Add entry to active host and standby host.