Is this exam completely free?

ExamCademy offers a free preview for every exam, covering around 20% of the total questions. Full access to all questions is available for free by signing up for an account. Optional supporters unlock AstroTutor (AI tutor) and advanced study modes.

Can I practice IT certification exams from Microsoft, AWS, or CompTIA?

Yes! ExamCademy supports a wide range of IT certification exams including Microsoft Azure, AWS Cloud Practitioner, and CompTIA A+ and Security+.

How accurate are the mock exams?

Our practice questions are community-created and moderator-reviewed to align with realistic exam objectives, style, and difficulty.

C2090-560 by IBM - Page 1 | ExamCademy

Mode Selection

Sort:

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 19

Question 20

Question 21

Question 22

Question 23

Question 24

Question 25

Page 1 of 6 • Questions 1-25 of 131

1 2 3 4 5

→

Know a question that should be here? Contribute to this exam

Which statement regarding temporary tables is TRUE?

A They are limited to 1 terabyte in size
B They may include a DISTRIBUTE ON clause
C They are limited to 16 tables per user per database
D They will be included in any nzbackup of the database

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.

A The default value for this variable is FALSE
B This variable controls whether the system allows users to create and manage multiple schemas
C 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
D 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

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

A NULL
B UNIQUE
C NOT NULL
D RIMARY KEY
E DEFAULT value

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

A /nz/data/postgresql.conf
B /nz/data/config/system.cfg
C /nz/kit/sys/initTopology.cfg
D /nz/kit/log/sysmgr/sysmgr.log

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

A STAHIVAL
B RELREFS
C STALOVAL
D RELTUPLES
E ATTDISPERSION

Which statement or operation will cause IBM Netezza Replication Services to use the "By- VALUE" replication gmethod?

A Insert data from a non-replicated database
B LIMIT ALL
C RANDOMO
D A & C
E B & C

What mechanism does NPS use for LDAP authentication?

A Pluggable Authentication Module (PAM)
B Generic Security Services API (GSSAPI)
C Simple Authentication and Security Layer (SASL)
D Berkeley Software Distribution Authentication (BSDAuth)

The CUSTOMER table is distributed on "c_custkey".
The ORDERS table is distributed on "o_custkey".
Please refer to the SQL Query below:

Question Image

Which of the following statements is TRUE?

A The query plan will show a double redistribute for both tables CUSTOMER and ORDERS followed by a HashJoinNode to compare all rows
B The query plan will show a broadcast for table CUSTOMER so that all rows in CUSTOMER can be compared to all rows in ORDERS using a HashJoinNode
C The query plan will show a broadcast for table CUSTOMER so that all rows in CUSTOMER can be compared to all rows in ORDERS using an ExprJoinNode
D The query plan will show a redistribute for table CUSTOMER so that all rows in CUSTOMER can be compared to all rows in ORDERS using an ExprJoinNode

The Pure Data System for Analytics implements which level of transaction isolation?

A Serializable
B Committed read
C Repeatable read
D Uncommitted read

What is the maximum number of columns you can choose as organizing keys for a clustered base table?

A 1
B 2
C 4
D 8

Which of the following is NOT true about the createxid column?

A They can be queried
B They are updated to zero during a DELETE operation
C Rows loaded in a transaction are assigned the same value
D They contain the ID of the transaction that created the record

What is nzconvert used for?

A To convert compressed external tables into ASCII text
B To convert between character encodings before loading data
C To translate stored procedures into NZPLSOL compatible syntax
D To upgrade/downgrade the database to a different software version

Dirty reads occur when a transaction reads data that is written by concurrentuncommitted transactions. Under what conditions are dirty reads allowed on the IBM
PDA system?

A When an FPGA is busy
B By turning off serialization within the system
C They are never permitted under any conditions
D When the transaction isolation is read-committed

What can be backed up using the nzbackup utility?

A Host data
B pg.log files
C Temporary tables
D User permissions

Which of the following will NOT show the current sessions on the Netezza server?

A nzsql\act
B nzsession
C nzsystem-showSessions
D SELECT* FROM_v_session

Which of the following statements about temporary tables is TRUE?

A Synonyms can be created for temporary tables
B Temporary tables have been deprecated as of NPS 7.0.3
C Temporary tables can be specified as a base table for materialized views
D When a user executes the command "SET SESSION READ ONLY", they are still able to create and write to temporary tables

What are two considerations for usage of materialized views? (Choose two.)

A Materialized views are not supported.
B Materialized views are logical entities.
C Materialized views may improve query performance.
D Materialized views are the same as database views.
E Materialized views are considered for usage by the Optimizer.

Netezza database accounts are NOT created and/or managed using

A The NzAdmin tool
B The Netezza Performance Portal
C The Netezza command line interface
D The Netezza host's command line interface

What database object in the history database will you use to find the version number of the history database?

A _t_version
B _vt_version
C Histversion
D $hist_version

What CANNOT be measured and managed by system views?

A Power supply status for each rack
B Temperature values on an S-blade
C Status of the host attached storage
D Resource group utilization and history

Which of the following is NOT performed by the nzhw utility?

A It shows the current storage topology
B It shows the role of each component in the appliance
C It shows the location of each component in the appliance
D It shows the hardware ID of each component in the appliance

Which statement about external tables is TRUE?

A Materialized views can be created for external tables
B External table data is deleted using the DELETE statement
C The GENERATE STATISTICS command can be run against external tables
D External tables can be used to unload data to a Microsoft Windows directory

Which file format is NOT supported by the nzload utility?

A ASCII delimited format
B Fixed length record format
C gzip compressed file format
D Pure Data System for Analytics compressed file format

Which of the following is a valid data type definition?

A TEXT
B CLOB
C CHAR(128000)
D NUMERIC(38,1)

Which of the following is TRUE regarding distribution keys?

A Up to 4 columns can be specified for a distribution key on a table
B The distribution key cannot be changed on a given table once that table is created
C Rows with the same distribution key value are stored on the same data slice
D All of the above

C2090-560Preview