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

Certensure Logo
  1. Home
  2. IBM
  3. IBM Certified Administrator - Netezza Performance Server V11.x
  4. C1000-085 - IBM Netezza Performance Server V11.x Administrator

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

Demo: 9 questions
Total 60 questions
Get C1000-085 Full Access Download C1000-085 PDF

IBM Netezza Performance Server V11.x Administrator Questions and Answers

Question 1

Which statement is true when executing the GROM command on a Clustered Base Table (CBT)?

Options:

A.

It reclaims space from deleted rows and does not re-order data

B.

Enough space is required for GROOM to make a complete copy of the table

C.

GROOM uses CREATE TABLE AS SELECT (CATAS) for CBT to reclaim space and re-order data.

D.

It reclaims space from deleted rows and re-orders data.

Question 2

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:

A.

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

B.

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

C.

CREATE ORGANIZED view for FACT_SALES table

D.

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

Question 3

Which two products or methods can be used for disaster recovery when using IBM Netezza Performance Servers?

Options:

A.

Cloud Pak for Data

B.

InfoSphere Data Replication

C.

Netezza Replication Services

D.

Data Serialization

E.

NPS Backup and Restore

Question 4

Which log file provides a DBA with an actual SQL statement that was executed?

Options:

A.

clientmgr.log

B.

pg.log

C.

sysmgr.log

D.

dbos.log

Question 5

To enable or disable multiple schema support on the IBM Netezza Performance Server, which configuration file needs to be updated?

Options:

A.

system.cfg

B.

pg_hba.conf

C.

postgresql.conf

D.

startup.cfg

Question 6

What are two valid column constraints?

Options:

A.

DEFAULT

B.

INITIALLY IMMEDIATE

C.

INITIALLY DEFERRED

D.

NULL

E.

DEFERRABLE

Question 7

What are two important factors to consider when selecting a distribution key?

Options:

A.

not Nullable constraint

B.

columns used for filters

C.

distinct values

D.

columns used for joins

E.

table constraints

Question 8

What nzsqa option can be used to view workload metrics including usage summary, resource usage and short/long running jobs?

Options:

A.

nzsqa progress

B.

nzsqa wlm

C.

nzsqa responders

D.

nzsqa schedqueues -sys

Question 9

When computing the row size for a table row, what overhead should be accounted for?

Options:

A.

48 bytes for ROWID, CREATEXID and DELETEXID only

B.

32 bytes for ROWID. CREATEXID, DELETEXID and the null vector

C.

32 bytes for ROWID. CREATEXID and DELETEXID and a variable number of bytes for the null vector if there are nullable columns

D.

24 bytes for ROWID. CREATEXID and DELETEXID plus null vector if there are nullable columns and record header depending on string columns

Load More C1000-085 Questions
Demo: 9 questions
Total 60 questions
Get C1000-085 Full Access Download C1000-085 PDF