PureData System for Analytics v7.1

Here you have the best IBM C2090-560 practice exam questions

You have 134 total questions to study from
Each page has 5 questions, making a total of 27 pages
You can navigate through the pages using the buttons at the bottom
This questions were last updated on November 19, 2025
This site is not affiliated with or endorsed by IBM.

Question 1 of 134

Which statement regarding temporary tables is TRUE?

They are limited to 1 terabyte in size

They may include a DISTRIBUTE ON clause

They are limited to 16 tables per user per database

They will be included in any nzbackup of the database

Correct Answer: B

Question 2 of 134

Select the statement about the ENABLE_USER_SCHEMA variable that is TRUE in a system using Netezza Performance Server Release 7.0.3 or higher.

The default value for this variable is FALSE

This variable controls whether the system allows users to create and manage multiple schemas

If the variable is set to TRUE and the user does not specify a schema, the system will connect to the default schema for the database

If the variable is set to FALSE and the user does not specify a schema, the system will connect to a schema that matches the database user name

Correct Answer: B

Question 3 of 134

When using a CREATE TABLE statement, constraints can be specified at the column level. Which two constraints are NOT automatically enforced via the database? (Choose two.)

NULL

UNIQUE

NOT NULL

RIMARY KEY

DEFAULT value

Correct Answer: B, D

Question 4 of 134

What is the host Linux file that must be modified to permanently adjust optimizer settings such as enabling schema support?

/nz/data/postgresql.conf

/nz/data/config/system.cfg

/nz/kit/sys/initTopology.cfg

/nz/kit/log/sysmgr/sysmgr.log

Correct Answer: A

Question 5 of 134

What columns contain row count information in the system tables? (Choose two.)

STAHIVAL

RELREFS

STALOVAL

RELTUPLES

ATTDISPERSION

Correct Answer: B, E