Free C1000-085 Exam Dumps Preview

Question 1

Multiple choice

Which two commands are used to list all hardware and software components on Cloud Pak for Data System?

1. A

   ap hw

2. B

   nzsw

3. C

   nzhv

4. D

   ap sw

5. E

   oc pod -h -s

Reveal answer details Close answer details

Correct answersA, D

Question 2

Multiple choice

What are two primary purposes of UDX?

1. A

   it is a required component of all Netezza SQL commands

2. B

   to force execution only on the SPU nodes

3. C

   to offer new and unique types of analyses through customized code

4. D

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

5. E

   to accelerate analysis by processing data in-database

Reveal answer details Close answer details

Correct answersD, E

Question 3

Single choice

What command is used to add an event?

1. A

   nzevent add

2. B

   nzevent insert

3. C

   nzevent load

4. D

   nzevent create

Reveal answer details Close answer details

Correct answerA

Question 4

Single choice

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

1. A

   48 bytes for ROWID, CREATEXID and DELETEXID only

2. B

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

3. C

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

4. D

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

Reveal answer details Close answer details

Correct answerA

Question 5

Multiple choice

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

1. A

   Cloud Pak for Data

2. B

   InfoSphere Data Replication

3. C

   Netezza Replication Services

4. D

   Data Serialization

5. E

   NPS Backup and Restore

Reveal answer details Close answer details

Correct answersB, E

Question 6

Single choice

To how many resource groups can a user be assigned?

1. A

   four

2. B

   unlimited

3. C

   three

4. D

   one

Reveal answer details Close answer details

Correct answerC

Question 7

Multiple choice

What are two valid column constraints?

1. A

   DEFAULT

2. B

   INITIALLY IMMEDIATE

3. C

   INITIALLY DEFERRED

4. D

   NULL

5. E

   DEFERRABLE

Reveal answer details Close answer details

Correct answersC, D

Question 8

Single choice

Which date time format is used to capture history activities?

1. A

   system time

2. B

   local time

3. C

   EST

4. D

   GMT

Reveal answer details Close answer details

Correct answerA

Question 9

Single choice

How does IBM Netezza Performance Server store data?

1. A

   Tables are distributed across all data slices compressed

2. B

   Tables are distributed to a single data slice compressed.

3. C

   Tables are distributed across all data slices uncompressed.

4. D

   Tables are distributed across a subset of data slices uncompressed.

Reveal answer details Close answer details

Correct answerA