CertsTopics Logo

New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Free and Premium IBM P2090-050 Dumps Questions Answers

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

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

Question 1

Using a date column as a distribution key may distribute rows evenly across dataslices, why is this a poor choice of a distribution key?

Options:

A.

Queries on the table will invoke compression.

B.

Queries on date range may involve processing skew.

C.

Queries on date range will utilize only host processing.

D.

Queries on the table will invoke compression on the date columns.

Buy Now
Question 2

To create a database table, at a minimum, what must be specified?

Options:

A.

column name and data type.

B.

column name, data type and primary key.

C.

column name, data type and default constraint.

D.

column name, data type and distribute on clause.

Question 3

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 4

In order to set a runaway query event totrigger when a query runs longer than two minutes, which two items must be configured? (Choose two.)

Options:

A.

The runaway query event was enabled.

B.

The pg.log file was configured for two minutes.

C.

The runaway query event was configured for two minutes.

D.

The nzsystem command was used to set the QUERYTIMEOUT to two minutes.

E.

The CREATE USER command was used to set the QUERYTIMEOUT to two minutes.

Question 5

What operating system runs ona PureData System for Analytics host?

Options:

A.

AIX

B.

SUSE Linux

C.

Nucleus OS

D.

Redhat Linux

Question 6

Given the following query: Select count(*) from TableA; How can you view the query plan without executing the query?

Options:

A.

Use explain.

B.

Use statistics.

C.

Use pg.log file.

D.

Set show_plan = true;

Question 7

nzbackup/nzrestore with the -user option has been replaced with which option to allow multi-level security (MLS) information, suchas categories, cohorts, and levels to be backed up/restored?

Options:

A.

-all

B.

-mls

C.

-users

D.

-globals

Question 8

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 9

In order for an ODBC application running on Microsoft Windows to connect to PureData System for Analytics, which two steps must be performed? (Choose two.)

Options:

A.

Install nzsql forWindows.

B.

Install nzAdmin for Windows.

C.

Install an ODBC driver for Windows.

D.

Install an ODBC Driver Manager for Windows.

E.

Create or modify a Data Source Name (DSN) for a connection to a database.

Question 10

Which component failure does NOT trigger a HardwareServiceRequested event?

Options:

A.

Fan

B.

Disk

C.

Host

D.

S-Blade

Question 11

Which statement is NOT true?

Options:

A.

nzbackup backs up selected tables.

B.

nzbackup backs up to a file system destination.

C.

nzbackup backs up to a Veritas NetBackup destination.

D.

nzbackup backs up to a IBM Tivoli Storage Manager destination.

Question 12

Given the following query: SELECT * FROM TableA; how does data flow through the PureData System for Analytics components?

Options:

A.

Disk to FPGA to Host to User.

B.

Disk to FPGA to S-Blade to User.

C.

Disk to Host to S-Bladeto FPGA to User.

D.

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

Question 13

What is required to troubleshoot a query?

Options:

A.

nzevents and the pg.log.

B.

nzsql andthe ODBC config.

C.

nzinventory and the dbos.log.

D.

nzdumpschema and the execution plan.

Question 14

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

Options:

A.

1

B.

12

C.

31

D.

> 96

Question 15

When unloading data via an external table, where can the SQL be submitted?

Options:

A.

From a User Defined Function.

B.

From nzsql on an AIX machine networked to the system.

C.

From nzsql on Microsoft Windows networked to the system.

D.

From an ODBC application on Windows networked to the system.

Question 16

Which statement is NOT true regarding the nzload utility?

Options:

A.

nzload runs on windows.

B.

nzload runs on SuSE Linux.

C.

nzload blocks update/delete against the target table.

D.

nzload runs on the PureData System for Analytics host.

Question 17

The primary copy of a dataslice is spread across how many disks?

Options:

A.

1.

B.

2.

C.

4.

D.

12.

Question 18

What should be considered when you are asked to select the distribution key columns for avery large fact table?

Options:

A.

As many columns as possible.

B.

Columns that contain many nulls.

C.

Columns that contain few unique values.

D.

Columns used to join to other large tables.

Question 19

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).

Exam Detail
Vendor: IBM
Certification: IBM Other Certification
Exam Code: P2090-050
Exam Name: IBM PureData System for Analytics Technical Mastery Test v1
Last Update: Jan 2, 2025
P2090-050 Question Answers
Page: 1 / 5
Total 131 questions
Get P2090-050 Full Access Download P2090-050 PDF