C1000-085 Online Practice Questions and Answers

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?

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

What are two primary purposes of UDX?

A. it is a required component of all Netezza SQL commands

B. to force execution only on the SPU nodes

C. to offer new and unique types of analyses through customized code

D. to showcase one's capability to write UDX code to duplicate existing SQL functions

E. to accelerate analysis by processing data in-database

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

A. Cloud Pak for Data

B. InfoSphere Data Replication

C. Netezza Replication Services

D. Data Serialization

E. NPS Backup and Restore

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

A. not Nullable constraint

B. columns used for filters

C. distinct values

D. columns used for joins

E. table constraints

What is required in order to restore a specific table using the nz_restore support tool?

A. A table needs to be backed up by using nzbackup utility.

B. A table that is being restored must have the same name in the backup set.

C. The userspace must be provided

D. The table structure (DDL) needs to exist

Which state does the nzstate command show when the IBM Netezza Performance Server system fails to initialize?

A. stopped

B. paused

C. discovering

D. down

What command is used to add an event?

A. nzevent add

B. nzevent insert

C. nzevent load

D. nzevent create

What is the duration of SQB by default?

A. 3 seconds

B. 6 seconds

C. 2 seconds

D. 10 seconds

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

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.

What two files are extracted from the SQL Extension toolkit package?

A. libnetinza-version.tar gz

B. libnetsqlext-version.tar.gz

C. libnetxml-version.tar.gz

D. libnetcrypto-version.tar.gz

E. libnetsqlkit-version.tar.gz