IBM PureData System for Analytics v7.0 Set 1

1.

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

Use a CURSOR Use an EXTERNAL TABLE Use the COPY command Increase PreFetch Count

2.

What function can nzbackup perform?

Back up pg.log files. Back up TEMP tables. Back up host data (catalog metadata). Back up the data using the specified number of streams.

3.

When loading a local ASCII file into table via an external table, where can the SQL be submitted?

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.

4.

Which is NOT a function that can be performed by nzbackup?

Backup data Backup schemas Backup users/groups Backup the /nz/data directory

5.

You have access to two databases, DEV and PROD. Currently you are connected to the DEV database. Which operation is permitted?

Delete from PROD..TableA Select * from PROD..TableA Truncate table PROD..TableA Insert into PROD..TableA select * from DEV..TableB

6.

Which statement is true?

MATERIALIZED VIEWS can be run against EXTERNAL tables GENERATE STATISTICS can be run against EXTERNAL tables. EXTERNAL table data is deleted using the SQL DELETE command. EXTERNAL tables can be used to unload data to a Microsoft Windows directory.

7.

When is the ToplogyImbalance event triggered?

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

8.

The query history data collected DOES NOT provide insight to which of the type of performance and behavior questions?

The typical or most common types of queries. The longest and shortest running queries on the system. The queries submitted by specific users or groups of users. The rotational speed of the disk drives during query execution.

9.

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

Create an nzcron event. nzstop/nzstart the database. Stop and start the appliance. Add entry to active host and standby host.

10.

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

AIX-HA Linux-HA SuSE-HA Solaris-HA

IBM PureData System for Analytics v7.0 Set 1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

IBM PureData System for Analytics v7.0 Set 1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner