Question 1

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

Options :

A : any column used in table constraints

B : any column with low cardinality

C : a technical or surrogate key

D : any date column commonly used in queries

Answer: A

Question 2

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

Options :

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.

Answer: D

Question 3

Which statement is correct about command nz_responders?

Options :

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

Answer: B

Question 4

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

Options :

A : LDAP

B : SSH

C : Radius

D : PKI-Based

E : Kerberos

Answer: A,D

Question 5

Which three scripts are included in the IBM Netezza Performance Server Software Support Tools?

Options :

A : nzsql

B : nz_ddl

C : nzsqa

D : nz_stats

E : nzbackup

F : nz tables

Answer: A,C

Free C1000-085 Mock Exam – Practice Online Confidently