March Sale Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70special

IBM P2090-047 IBM PureData System for Transactions Technical Mastery Test v1 Exam Practice Test

Page: 1 / 13
Total 132 questions

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

Testing Engine

  • Product Type: Testing Engine
$36  $119.99

PDF Study Guide

  • Product Type: PDF Study Guide
$31.5  $104.99
Question 1

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

Options:

A.

If there are any materialized views on the table TableA.

B.

If there are any active selects running against the table TableA.

C.

If there are any active nzloads running against the table TableA.

D.

If there are any active updates running against the table TableA.

Question 2

When is the ToplogyImbalance event triggered?

Options:

A.

When a SAS switch has failed.

B.

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

C.

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

D.

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

Question 3

Which component failure does NOT trigger a HardwareServiceRequested event?

Options:

A.

Fan

B.

Disk

C.

Host

D.

S-Blade

Question 4

What CANNOT be measured and managed by system views?

Options:

A.

Temperature values on S-blade.

B.

Status of the host attached storage.

C.

Power supply status for each frame.

D.

Resource group utilization and history.

Question 5

Which statement is true about data flowing in/out of the PureData System for Analytics Appliance?

Options:

A.

Bypasses the host.

B.

Flows through the host.

C.

Compressed on the host.

D.

Uncompressed on the host.

Question 6

OLE-DB based applications on UNIX requires which PureData System for Analytics software?

Options:

A.

Install the JDBC driver for UNIX.

B.

Install the ODBC driver for UNIX.

C.

Install the OLE-DB driver for UNIX.

D.

OLE-DB is not supported on UNIX.

Question 7

TableA is currently being accessed in a number of long running queries. Which of the following operations is NOT blocked, thus allowing the operation to immediately proceed?

Options:

A.

DROP TABLE TableA

B.

ALTER TABLE TableA

C.

TRUNCATE TABLE TableA

D.

GRANT SELECT ON TableA TO UserA

Question 8

What is the host Linux file that must be modified to adjust optimizer settings permanently?

Options:

A.

/nz/data/postgresql.conf

B.

/nz/data/config/system.cfg

C.

/nz/kit/sys/initTopology.cfg

D.

/nz/kit/log/sysmgr/sysmgr.log

Question 9

A group has a resource allocation maximum of 50% and the job maximum is set to 1. Two users within this resource group each execute 1 job at the same time, which statement is correct?

Options:

A.

Each job gets 25% and both run at the same time.

B.

Each job gets 50% but only one job runs at a time.

C.

Each job gets 50% and both run at the same time.

D.

You cannot set the job maximum per resource group.

Question 10

Which High-Availability (HA) mechanism is used by the PureData System for Analytics Appliance?

Options:

A.

AIX-HA

B.

Linux-HA

C.

SuSE-HA

D.

Solaris-HA

Question 11

If data is being nzload'ed into TableA, which of the following operations will be blocked until the load has completed?

Options:

A.

A DELETE from TableA

B.

A SELECT from TableA

C.

A TRUNCATE of TableA

D.

An nzbackup of the database in which TableA resides

Question 12

What are two considerations for usage of materialized views? (Choose two)

Options:

A.

Materialized views are not supported.

B.

Materialized views are logical entities.

C.

Materialized views may improve query performance.

D.

Materialized views are the same as database views.

E.

Materialized views are considered for usage by the Optimizer.

Question 13

Which statement is true regarding any database user?

Options:

A.

The user has a table space defined.

B.

The user can be assigned to more than one group.

C.

The user must have a corresponding host account.

D.

The user can be removed from the default PUBLIC group.

Question 14

The simplest query execution plan file must have the following minimum nodes?

Options:

A.

ScanNode, RestrictNode, LimitNode, ReturnNode

B.

ScanNode, RestrictNode, HashNode, ReturnNode

C.

ScanNode, RestrictNode, ProjectNode, ReturnNode

D.

ScanNode, RestrictNode, AggregateNode, ReturnNode

Question 15

Which is NOT a way to check if the database is online?

Options:

A.

nzstate

B.

cat /proc/database

C.

nzsystem showState

D.

nzsql -c "select * from _v_system_info;"

Question 16

In a UNIX 64bit environment, a 64bit application requires which software to execute SQL statements via ODBC? (Choose two.)

Options:

A.

nzsql

B.

An ODBC driver manager.

C.

The system does not support 64 bit ODBC.

D.

A 64-bit ODBC driver for the same UNIX environment.

E.

A 32-bit ODBC driver for the same UNIX environment.

Question 17

What is true about queries submitted on the PureData System for Analytics Appliance?

Options:

A.

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

B.

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

C.

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

D.

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

Question 18

If user A has a minimum resource allocation of 20% and a maximum of 80%, user A can receive what percentage of available resources?

Options:

A.

A maximum of 20% of resources when other users are on the system.

B.

A maximum of 50% of resources when other users are on the system.

C.

A maximum of 80% of resources when no other users are on the system.

D.

A maximum of 100% of resources when no other users are on the system.

Question 19

Within a single PureData System for Analytics, what is the fastest way to copy a 10TB TableA from DatabaseA to another DatabaseB?

Options:

A.

Use the COPY command.

B.

Use external tables and UNIX pipes.

C.

Use nzbackup and nzrestore commands.

D.

Use a CTAS (Create Table as Select) SQL statement.

Page: 1 / 13
Total 132 questions