Labour Day Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: suredis

Examstrust Logo
examstrust mcafee
  1. Home
  2. IBM
  3. SWG Technical Mastery
  4. P2090-050 - IBM PureData System for Analytics Technical Mastery Test v1

IBM P2090-050 IBM PureData System for Analytics Technical Mastery Test v1 Exam Practice Test

Page: 1 / 13
Total 131 questions
Get P2090-050 Full Access Download P2090-050 PDF

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

PDF + Testing Engine

  • Product Type: PDF + Testing Engine
$59.5  $169.99
Add to Cart

Testing Engine

  • Product Type: Testing Engine
$42  $119.99
Add to Cart

PDF Study Guide

  • Product Type: PDF Study Guide
$36.75  $104.99
Add to Cart
Question 1

Which is NOT a function of the FieldProgrammable Gate Arrays (FPGA) residing on the Netezza Database Accelerator card?

Options:

A.

Projects

B.

Restricts

C.

Aggregates

D.

Decompresses

Question 2

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.

Question 3

Which statement regarding temporary tables is true?

Options:

A.

They are limited to 1 terabyte in size.

B.

They may include a DISTRIBUTE ON clause.

C.

They are limited to 16per user per database.

D.

They will be included in any nzbackup of the database.

Question 4

Which statement is true?

Options:

A.

All user space is available for database expansion.

B.

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

C.

When creating the database you can specify whichdisks to use.

D.

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

Question 5

What is the maximum number of databases that can be created?

Options:

A.

1

B.

12

C.

31

D.

> 96

Question 6

When doing a CREATE TABLE, constraints can be specified at the column level. Which two constraints are NOT automatically enforced via the database? (Choose two.)

Options:

A.

NULL

B.

UNIQUE

C.

NOT NULL

D.

PRIMARY KEY

E.

DEFAULT value

Question 7

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?

Options:

A.

Plans

B.

Disks

C.

Tables

D.

Queries

Question 8

Which statement about theGROOM TABLE feature is true?

Options:

A.

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

B.

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

C.

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

D.

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

Question 9

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 10

What is the function of the Distributed Replicated BlockDevice (DRBD)?

Options:

A.

High Availability

B.

Load Balancing

C.

High Concurrency

D.

Work Load Management

Question 11

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 12

A SELECT statement spends all its time returning 1 billion rows.What can be done to make this faster?

Options:

A.

Use a CURSOR.

B.

Use an EXTERNAL table.

C.

Use the COPY command.

D.

Increase the PreFetch Count.

Question 13

Which statement is true regarding the compress engine?

Options:

A.

Data automatically gets compressed.

B.

Columns to be compressed must be defined.

C.

The nzcompress utility must be run to compress the table.

D.

The nzcompress utility must be run to compress thedatabase.

Question 14

Why is table skew important to manage?

Options:

A.

Low table skew negatively impacts performance.

B.

High table skew negatively impacts performance.

C.

Low table skew negatively impacts data compression.

D.

Deleted rows consume disk space until they are freed.

Question 15

Which two statements are trueabout queries on the PureData System for Analytics Appliance? (Choose two.)

Options:

A.

Queries are executed in parallel by the host.

B.

Queries must be compressed before they can be executed.

C.

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

D.

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

E.

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

Question 16

A group has a resource allocation maximum of 50% and the job maximum is set to 1. Two users within this resource groupeach 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 17

When setting up a crontab entry, what must be done on a PureData Systemfor Analytics server?

Options:

A.

Create an nzcron event.

B.

nzstop/nzstart the database.

C.

Stop and start the appliance.

D.

Add entry to active host and standby host.

Question 18

Whyshould you avoid using Boolean data types as a distribution key for a table ?

Options:

A.

Table will not join.

B.

Table will not broadcast.

C.

Table is likely to be skewed.

D.

Table is likely to be evenly spread across data slices.

Question 19

Which CREATE DATABASE attributes are required?

Options:

A.

The database name.

B.

The database name and the redo log file name.

C.

Thedatabase name and the table space name.

D.

The database name and the temporary table space name.

Load More P2090-050 Questions
Page: 1 / 13
Total 131 questions
Get P2090-050 Full Access Download P2090-050 PDF