C1000-085 Online Practice Questions and Answers

Which statement is accurate regarding snippets?

A. The number of snippets depends on query and complexity.

B. Every query is always turned into four snippets.

C. Every query is always turned into one snippet.

D. The number of snippets is always based on the size of the system.

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

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

What should be the state of the IBM Netezza Performance Server system in order to run the nz_manual_vacuum command?

A. online

B. running

C. stopped

D. paused

Which level of transaction isolation does IBM Netezza Performance Server implement?

A. uncommitted read

B. serializable

C. repeatable read D. committed read

Which command is used to register a user defined table function in the database?

A. CREATE FUNCTION

B. nzudxcompile

C. ALTER FUNCTION

D. ECHO

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 nzsqa option can be used to view workload metrics including usage summary, resource usage and short/long running jobs?

A. nzsqa progress

B. nzsqa wlm

C. nzsqa responders

D. nzsqa schedqueues -sys

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 is the name of the IBM Netezza Performance Server Replication node at the target nodes when using Netezza Replication Services?

A. SUBORDINATE NODE

B. MASTER NODE

C. STANDBY NODE

D. PRIMARY NODE

Which is a valid statement regarding event rules on the IBM Netezza Performance Server (NPS) Console?

A. New event rules can be added using the queries panel in NPS Console.

B. New event rules can be added using the event rules panel in NPS Console.

C. New event rules can only be added in the host container.

D. New event rules must be added using the npsaddevent command.

The nzhostbackup command backs up which directory by default?

A. /nz/data/

B. /nzscratch/

C. /ex port/ho me/nz

D. /nz/kit/

Which statement is correct about command nz_responders?

A. displays user activity in tabular format

B. displays information from nzsql responders -all in a more user-friendly format

C. displays information from nzsqa responders -sys in a more user-friendly format

D. displays resource utilization statistics in JSON format

Which two file formats are valid for external tables?

A. text-delimited

B. fixed-length

C. JSON

D. HL7

E. XML

Which statement regarding the IBM Netezza Performance Server (NPS) admin database user is true?

A. The admin user should be deleted after installing NPS.

B. The admin user is added to the host OS before installing NPS.

C. The admin user can not be deleted after installing NPS.

D. The admin user is the only owner of a database on NPS.