IBM Netezza Performance Server V11.x Administrator (C1000-085) Practice Test

Questions # 11:

Which two commands can be used to get a plan file for a query?

Options:

nzsql -c "show planfile "

nzsql -c "select plan_text from _v_plan"

nzsql -c "get planfile "

nz_get

nz_plan

Questions # 12:

Which is the most efficient data type for distribution keys?

Options:

integers

internal datatypes (ROWID etc.)

temporal types

strings

Questions # 13:

Which two scenarios can be addressed using the nz_check_disk_scan_speeds command?

Options:

check system status

get skew information distributed across disks

see disk read and write speeds

slow performing SPU or drive

get disk storage utilization details

Questions # 14:

What is a purpose of the command nzsystem?

Options:

to show and change the system state

to show and change nzroot use

to show and change system users

to show and change system access

Questions # 15:

Consider a scenario where a customer has a FACT_SALES table with a column zip_code with data type char(5| They frequently restrict on this column, but the query is very inefficient.

What is the correct way to optimize this query without modifying the column?

Options:

Create a copy of FACT_SALES table with zip_code as integer data type.

alter table fact_sales to organize on zip_code. followed by groom.

CREATE ORGANIZED view for FACT_SALES table

Create a view with a typecast to integer and use view for query purposes

Questions # 16:

When is a PRIMARY KEY (PK) table constraint evaluated during an INSERT statement into the table?

Options:

The PK constraint is never checked when a row is inserted into the table.

After the row is inserted into the table.

Before the row is inserted into the table.

The PK constraint is only checked during a GENERATE STATISTICS operation.

Questions # 17:

What are Clustered Base Tables (CBT)?

Options:

Tables that decrease allocated storage

Tables that contain sorted data using one to four columns.

Tables that increase pre-sorting of new table records before a loading operation.

Tables that replicate the base table.

Questions # 18:

The nzhostbackup command backs up which directory by default?

Options:

/nz/data/

/nzscratch/

/ex port/ho me/nz

/nz/kit/

Viewing page 2 out of 2 pages

Viewing questions 11-20 out of questions

Summer Certification Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Pass the IBM Certified Administrator - Netezza Performance Server V11.x C1000-085 Questions and answers with ExamsMirror

Exam C1000-085 Premium Access

Options:

Options:

Options:

Options:

Options:

Options:

Options:

Options:

TOP CODES