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

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

• Cloud Pak for Data
• InfoSphere Data Replication
• Netezza Replication Services
• Data Serialization
• NPS Backup and Restore

Which two external methods can IBM Netezza Performance Server use to authenticate database users?

• LDAP
• SSH
• Radius
• PKI-Based
• Kerberos

When integrating IBM Spectrum Protect into IBM Netezza Performance Server (NPS) for backup and restore, how must the NPS host be defined?

• as a client of the storage manager server
• as the primary storage manager server
• as the primary backup target
• as a cloud storage repository

Which two file formats are valid for external tables?

• text-delimited
• fixed-length
• JSON
• HL7
• XML

The nzhostbackup command backs up which directory by default?

• /nz/data/
• /nzscratch/
• /ex port/ho me/nz
• /nz/kit/

When choosing a distribution key for a large fact table, what is a valid choice?

• any column used in table constraints
• any column with low cardinality
• a technical or surrogate key
• any date column commonly used in queries

How does IBM Netezza Performance Server store data?

• Tables are distributed across all data slices compressed
• Tables are distributed to a single data slice compressed.
• Tables are distributed across all data slices uncompressed.
• Tables are distributed across a subset of data slices uncompressed.

What are Clustered Base Tables (CBT)?

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

What ap cli command is used to disable a node?

• ap node power off
• ap node set__personality fail
• ap stopnode
• ap node disable

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

• New event rules can be added using the queries panel in NPS Console.
• New event rules can be added using the event rules panel in NPS Console.
• New event rules can only be added in the host container.
• New event rules must be added using the npsaddevent command.